CODEWITHSUNDEEP
qlikview
gabba
gabba

Reputation: 2880

Inequality in Qlikview set expressions

Example from Qlikview help:

sum( {$<Year = {“>1978<2004”}>} Sales )

I try this code, but it did't works

Count( {$<Damages.DamageDate = {">Min(OtherDate)"}>} Damages.Id)

Looks like qlikview did't support dates in inequalities. Any way if anyowne know how to do things like this please help.

Upvotes: 0

Views: 1903

Answers (4)

dreTa
dreTa

Reputation: 27

Another posibility to your question is create a variable for example: vMinDate = Min(OtherDate)

And then you can use your variable in the expression like this:

Count( {$<Damages.DamageDate = {'$(vMinDate)'}>} Damages.Id)

Upvotes: 1

Stefan Walther
Stefan Walther

Reputation: 938

I'd use

// Reopen or share this result by using the following Url:
// http://tools.qlikblog.at/SetAnalysisWizard/?sa=J0LC

Count({$<[Damages.DamageDate]={">$(=Min(OtherDate))"}>}[Damages.Id])

Note: I think you should square brackets for qualified field names like "Damages.DamageDate". You can use the Set Analysis Wizard to change the expression.

Hope this helps!

Regards Stefan

Upvotes: 2

gabba
gabba

Reputation: 2880

I not find the way how to calculate what I need in qlikview, but I workaround it by make all calculation in sql query.

UPDATE:

Also combination of count and if may be helpful. And don't forget place user selected values into document variables before use it in expressions

Upvotes: -1

Imre Greilich
Imre Greilich

Reputation: 3412

As I remember, you must use a dollar-sign expansion within the set expression. Look up "Set Modifiers with Dollar-Sign Expansions" in the manual. The Min function will then be evaluated and so the set expression should work.

It will look sg like this: 

Count( {$<Damages.DamageDate = {">$(=Min(OtherDate))"}>} Damages.Id)

Or perhaps 

Count( {$<Damages.DamageDate = {">$(#=Min(OtherDate))"}>} Damages.Id)

Upvotes: 5

Related Questions