topic Re: Set Analysis in QlikView

Set Analysis

Wed, 09 Jul 2014 10:31:26 GMT

Hi,

I have a set analysis statement that produces a ratio/percentage, something like this:

=(Sum ( {$<flag={'FALSE'}>} counted))/(Sum ( {$<flag=>} counted))

I want this value to be unaffected by users making a selection on the 'flag' value (for use with other charts) - I can replace the $ with 1 to ignore selections, but that ignores all selections. I want the value to be affected by other selections the user chooses.

So, I want it to take into account the 'flag' values set in the statement, but then ignore any user selections on that 'flag' field.

Can this be done, or is there a better way of structuring things?

Thanks

Re: Set Analysis

Wed, 09 Jul 2014 10:48:10 GMT

can you make your requirements more precise. Its difficult to understand. If you share any example it will be easy to help

Re: Set Analysis

ashfaq_haseeb — Wed, 09 Jul 2014 10:54:58 GMT

Hi your expression

=(Sum ( {$<flag={'FALSE'}>} counted))/(Sum ( {$<flag=>} counted))

Does the same

Regards

ASHFAQ

Re: Set Analysis

Wed, 09 Jul 2014 11:07:42 GMT

If I create a selection box of the 'flag' field, which has the values TRUE and FALSE, and select TRUE, I get nulls for all values, as this:

=(Sum ( {$<flag={'FALSE'}>} counted))/(Sum ( {$<flag=>} counted))

effectively turns to this:

=0/(Sum ( {$<flag=>} counted)

I want to maintain the result generated with the set analysis statement regardless of the 'flag' user selection.

Re: Set Analysis

sasikanth — Wed, 09 Jul 2014 11:09:40 GMT

hi,

write like

if(getSelectedCount(Flag)>0,(Sum ( {1<flag={'FALSE'}>} counted))/(Sum ( {1<flag=>} counted)),=(Sum ( {$<flag={'FALSE'}>} counted))/(Sum ( {$<flag=>} counted))

Re: Set Analysis

ashfaq_haseeb — Wed, 09 Jul 2014 11:16:24 GMT

HI,

It must work fine it should not return zero.

Can you share a sample app.

Regards

ASHFAQ

Re: Set Analysis

richard_pearce6 — Wed, 09 Jul 2014 11:17:39 GMT

Hi Tom,

It maybe worth sharing a sample app and checking on a small set of data.

{$<flag={'FALSE'}>} Will select in field flag = FALSE regardless of the users selection.

{$<flag=>} Will effectively remove any selections that may be present within the 'flag' field.

Did you check your spelling, capitilisation and spaces in field? Maybe its 'False' or 'false'. Maybe there's a trailing space 'FALSE '. In this type of set analysis you need to be exact.

Regards

Richard

Re: Set Analysis

mahesh_agrawal — Wed, 09 Jul 2014 11:21:28 GMT

Hi,

Declare a variable in Variable Overview with "Sum ( {$<flag={'FALSE'}>} counted)".

Remember to add a '=' before the expression in the variable Overview window as it makes the expression global and independent of current selection.

Re: Set Analysis

Wed, 09 Jul 2014 12:14:46 GMT

Hi Richard,

Sorted - yes that was the case, a mistake on my part. Some very helpful info from everyone else though.

Thanks a lot

Tom

Re: Set Analysis

richard_pearce6 — Wed, 09 Jul 2014 12:19:57 GMT

No problem Tom. Pleased you got it sorted!

Richard