Discussion Board for collaboration related to QlikView App Development.
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):
could u help me with the expression?
thanks in advance!
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?
Hope this helps you.