variable with set analisys

[ilanbaruch]

hi all,

trying to count orders that are above value in a variable,

tried like this :

Count(DISTINCT{$<'$(vValue)' >= {'3'} >} order_id)

but.. wont work, any ideas?

[trdandamudi]

May be as below:

=Count(Distinct {$<'$(vValue)' = {'>= 3'}>}order_id)

If this doesn't work, can you please share the value in the variable vValue

[ecolomer]

which is the content of vValue??

[qlikviewwizard]

Can you provide the sample data and expected output?

[ilanbaruch]

hi,

vValue holds:  sum(flag_field)

flag_field contains (0/1)

[ilanbaruch]

hi,

vValue holds:  sum(flag_field)

flag_field contains (0/1)

[trdandamudi]

It is little confusing, because you are saying flag_field contains (0/1) but in the expression you want to check for >=3 ?. Can you please share a sample app with desired output.

[ilanbaruch]

my apologies,

flag_field contain 0/1 ;

and the value in  the variable  is an aggregation of flag_field: sum(flag_field)

[trdandamudi]

Got it... Did you tried the expression ? If not are you getting any error ?

[ilanbaruch]

no error in the editor , but wrong calc..