topic How to write an expression so selection on variable-name is excluded from computation in the expression in QlikView

How to write an expression so selection on variable-name is excluded from computation in the expression

Tue, 20 Apr 2010 18:39:20 GMT

Assume variable "gender" with values "men" and "women"

Assume variables "age" associated with each record. Values can ge "young" or "old"

In one bar chart with 4 bars, I want to compare count on "young men" with count on "all men" and count on "young women" with count on "all women"

I think the string ($<age>=) goes in there somewhere, but I can make this work.

Help

How to write an expression so selection on variable-name is excluded from computation in the expression

Tue, 20 Apr 2010 19:08:25 GMT

Hey Bill, in your case that can be solved with set analysis your expression should look similar to this:

count({gender = {'men'}, age = {'young'}} PersonID)

You can modify the above to get your 4 expressions.

Regards

How to write an expression so selection on variable-name is excluded from computation in the expression

Wed, 21 Apr 2010 06:52:02 GMT

Hi,

you could use formulas as under:

For counting the young males = count ( if ( Gender = 'Male' and Age = 'Young' , ID,))

you would need to repeat for all the 4 criterias.

How to write an expression so selection on variable-name is excluded from computation in the expression

Wed, 21 Apr 2010 15:31:05 GMT

Hi Bill, Umang approach is very straight forward and easy to understand, however I suggest trying with set analysis which is commonly faster, or even better, try both and I see what works for you.

Regards