topic Re: Total keyword in set analysis? in QlikView

Total keyword in set analysis?

sspawar88 — Wed, 01 Jul 2015 10:31:27 GMT

Hi Community,

here i'm using this Set analysis for WEST region with the help of Total keyword

but have a doubt that this expression could be fail after loading millions record.

Can i using Total keyword in set analysis..is it right way?

Count({$<param_name={'Temperature'},param_value={'<=-1'},region_name={'WEST'}>}param_value)/

Count(total{$<param_name={'Temperature'},region_name=,param_value=>}param_value)

Count of temperature less than -1 (-1,-2,-3..onward) for west region upon total values count for all region

sunny_talwar — Wed, 01 Jul 2015 10:33:26 GMT

Total can be used the way you have. Are you not getting the output you are expecting?

alexandros17 — Wed, 01 Jul 2015 10:34:05 GMT

It seems right ...

swuehl — Wed, 01 Jul 2015 10:35:18 GMT

Basically, the TOTAL qualifier is not used within the set expression, it's a qualifier to the aggregation function Count().

It will only make sense when used in a chart with dimensions or advanced aggregation.

I believe it won't fail after loading millions of records.

sspawar88 — Wed, 01 Jul 2015 10:39:19 GMT

Hi Sunindia,

basically i'm using this expression in Bar chart.

it works fine.

but i was not confident for this one. but now damn sure

sunny_talwar — Wed, 01 Jul 2015 10:44:59 GMT

Great