topic Re: variable with set analisys in QlikView

variable with set analisys

ilanbaruch — Sun, 10 Jul 2016 13:50:27 GMT

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?

Re: variable with set analisys

trdandamudi — Sun, 10 Jul 2016 13:59:27 GMT

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

Re: variable with set analisys

ecolomer — Sun, 10 Jul 2016 13:59:41 GMT

which is the content of vValue??

Re: variable with set analisys

qlikviewwizard — Sun, 10 Jul 2016 14:10:18 GMT

Can you provide the sample data and expected output?

Re: variable with set analisys

ilanbaruch — Sun, 10 Jul 2016 14:10:48 GMT

hi,

vValue holds: sum(flag_field)

flag_field contains (0/1)

Re: variable with set analisys

ilanbaruch — Sun, 10 Jul 2016 14:17:34 GMT

hi,

vValue holds: sum(flag_field)

flag_field contains (0/1)

Re: variable with set analisys

trdandamudi — Sun, 10 Jul 2016 14:25:25 GMT

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.

Re: variable with set analisys

ilanbaruch — Sun, 10 Jul 2016 14:28:59 GMT

my apologies,

flag_field contain 0/1 ;

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

Re: variable with set analisys

trdandamudi — Sun, 10 Jul 2016 14:34:50 GMT

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

Re: variable with set analisys

ilanbaruch — Sun, 10 Jul 2016 14:42:01 GMT

no error in the editor , but wrong calc..

Re: variable with set analisys

trdandamudi — Sun, 10 Jul 2016 14:43:48 GMT

Please share some sample data with the required output, so that we can take a look and come up with a solution...

Re: variable with set analisys

vinieme12 — Sun, 10 Jul 2016 14:51:57 GMT

Try this instead

Count({<$(vValue) = {">=3"} >} DISTINCT OrderID)

count(distinct if(sum(flag_field)>=3,OrderID))

count(distinct if($(vValue)>=3,OrderID))