Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
sspawar88
Creator II
Creator II

Total keyword in set analysis?

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

5 Replies
sunny_talwar

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

alexandros17
Partner
Partner

It seems right ...

swuehl
MVP
MVP

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
Creator II
Creator II
Author

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

Great