topic Advanced Set Analysis in QlikView

Advanced Set Analysis

Wed, 10 Oct 2012 16:38:44 GMT

Hello

I'm looking for some advanced expression assistance with attached qvw file.

In the file there are some Ids associated to some regions and some numbers.

I'm looking to add a calculated dimension which will do a count of all Age_Buckets (column in the file) as one field.

For e.g. If you select AVI6 (second in the list) you can find two age buckets (0 to 1 and 2 to3) Both have individual counts (3 and 11 respectively)

I'd like to club/add both counts and display as one column so that users can see a consolidate count (which will be 14 in this case) of age buckets.

Apologies if this is some way confusing or too specific.

Thanks for your help.

Wed, 10 Oct 2012 17:24:07 GMT

Remove Age_Bucket from the dimension. This will roll your count to the 2 remaining dimension. recid and region.

CELAMBARASAN — Wed, 10 Oct 2012 23:14:57 GMT

Go to presentation tab --> Click on Age_bucket which is in Dimensions and Expressions

and select show partial sums check box below.

You will get the total.

Celambarasan

Thu, 11 Oct 2012 06:48:42 GMT

Hai,

Please find the attachment May be this is what you are looking for.

Thanks,

Rathish

Thu, 11 Oct 2012 10:13:31 GMT

Thanks everyone for your help.