Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

sum of count?

Hello everyone!

I have troubles with such expression (in chart http://s017.radikal.ru/i408/1505/cd/9aa79ad6c971.png) :

measure  - count of such values, groupped by different ranges (dimension, formed by huge bunch of "IF"s, like

if ([uniq_city.avg_metr] > 150000, '> 150',if ([uniq_city.avg_metr] > 140000 and [uniq_city.avg_metr] <150000,'140-150'...etc)

I want to count a rate by total sum of counts(without breaking by ranges which i pointed out above), smth like this (instead real values):

count({$}[uniq_city.avg_metr])/sum(aggr(count([uniq_city.avg_metr]),"smth_i_dont_know"))

could u help me with the expression?

thanks in advance!

1 Reply
Highlighted
Partner
Partner

Re: sum of count?

Hi,

I'm not sure that understand you properly but  check my example.

Do you want find a ratio of this week to total or previous week to total or both?

PFA

Hope this helps you.

Regards,

Andrei