topic Re: How to filter away rows in set analysis in QlikView

How to filter away rows in set analysis

Tue, 25 Feb 2014 14:45:46 GMT

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

Re: How to filter away rows in set analysis

Tue, 25 Feb 2014 15:08:02 GMT

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

Re: How to filter away rows in set analysis

Tue, 25 Feb 2014 15:15:42 GMT

Thank you Aunez!

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