Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to filter away rows in set analysis

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

2 Replies
Not applicable
Author

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

Not applicable
Author

Thank you Aunez!

I solved it by using a calculated dimension instead - but thanks for the link!