Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a straight table with a traffic light and some percentages. Some of my customers dont have any data so i write an ERROR in their trafficlight column - But cant i sort them out somehow?
my expression is like this:
=if(sum({<DateCleanLog={">=$(=Date(Today()-1))"}>}Rows) = 0, 'ERROR',((avg(aggr(sum({<DateCleanLog={"<$(=Date(Today()-1))"}, MonthYearLog={'feb-2014'}>}Rows),DateCleanLog,LogCustomerID)) -
sum({<DateCleanLog={">=$(=Date(Today()-1))"}>}Rows)) /
avg(aggr(sum({<DateCleanLog={"<$(=Date(Today()-1))"}, MonthYearLog={'feb-2014'}>}Rows),DateCleanLog,LogCustomerID)))*-1)
Thanks in advance
Thomas,
I have published a doc on Set Analysis:
http://community.qlik.com/docs/DOC-4951
Chapter 4.6.2 should answer your question. But I cannot (I do not see where to put the extra thing)
Fabrice
Thank you Aunez!
I solved it by using a calculated dimension instead - but thanks for the link!