topic Re: Use of Variable in Set Analysis? in QlikView

Use of Variable in Set Analysis?

dmohanty — Tue, 28 Apr 2015 22:58:15 GMT

Hi All,

I am calculating YES and NO using certain condition and storing in a Variable.

For example, vYesNo = if ( Avg(Total) - Avg(Actual) > 1 , 'YES' , 'NO')

and using the same variable I have to Count a certain dimension. For example:

Count (Materials) where vYesNo = 'YES' (have to use this variable in Set Analysis - HOW?)

Count (Materials) where vYesNo = 'NO' (have to use this variable in Set Analysis - HOW?)

Can someone please help here - How to use the variable in Set Analysis?

Re: Use of Variable in Set Analysis?

danieloberbilli — Tue, 28 Apr 2015 23:46:51 GMT

Set Analysis deals mainly with fields. If you would have a field F1 with the values YES and NO, you could use your variable to control this like

count({<F1={$(vYesNo)}>} Materials)

but in your case you wouldnt use set analysis and rather somthing like

count (if($(vYesNo)='YES', Materials)

Re: Use of Variable in Set Analysis?

dmohanty — Wed, 29 Apr 2015 00:01:32 GMT

Hi Daniel,

Thanks for some help.

But as, by calculated variable is using Aggregation Function, so using the variable in Count(). is not allowing to do a Nested Aggregation.

Any other help please?

Re: Use of Variable in Set Analysis?

danieloberbilli — Wed, 29 Apr 2015 00:06:13 GMT

could you describe a bit more the situation (object/dimension/data)? At the moment, I don't consider this as a nested aggregation but a simple condition resulting in true/false. A nested aggregation would be sth like sum(aggr(count...))

Re: Use of Variable in Set Analysis?

danieloberbilli — Wed, 29 Apr 2015 00:10:45 GMT

ah - I think see what you mean - sorry - I thought you are calculating the variable only once in the script - but its dynamic on the dashboard level

Re: Use of Variable in Set Analysis?

danieloberbilli — Wed, 29 Apr 2015 00:21:30 GMT

what about

=if($(vYesNo)='YES', count(Materials))

=if($(vYesNo)='NO', count(Materials)) ?

Re: Use of Variable in Set Analysis?

dmohanty — Wed, 29 Apr 2015 00:31:49 GMT

Yes,

I am calculating the variable at script level and using the formula in a Text Object.

But this has not helped either

Re: Use of Variable in Set Analysis?

danieloberbilli — Wed, 29 Apr 2015 00:37:47 GMT

maybe you should post an example qvw with dummy data and also what result you would expect.

In my case I dont see any problem when creating a dummy by myself.