KPIs and Tables.

Luis_Arocho-LLantin — Wed, 22 Jun 2022 15:40:51 GMT

A customer is using KPIs and Tables with the same formula and she is getting different results. She wants to know why this is happening. Is there anything wrong with the formula?

Thanks in advance!

Re: KPIs and Tables.

Qlik_Eric_Thomas — Wed, 22 Jun 2022 16:50:46 GMT

Are they suppressing NULL values for 'Respondent Name' or ''Email Address' in the table?

Re: KPIs and Tables.

rwunderlich — Wed, 22 Jun 2022 19:54:12 GMT

The differences may have something to do with suppressing nulls, but I would suggest that the expression is incorrectly formulated to begin with. I understand the user wants to "count CountResponseNumber where ResponseStatusFilter is not 'Partial Response' or 'Status Not Reported'".

If I understand the requirement correctly, then the correct structure would be to put the if test inside the Count().

Count(DISTINCT If(ResponseStatusFilter <> 'Partial Response' or ResponseStatusFilter <> 'Status Not Reported', CountResponseNumber))

or better

Count(DISTINCT If(not Match(ResponseStatusFilter, 'Partial Response', 'Status Not Reported'),CountResponseNumber))

or even better still use Set Analysis:

Count({<ResponseStatusFilter -= {'Partial Response', 'Status Not Reported'}>} DISTINCT CountResponseNumber)

There is a logical difference between putting the If() inside or outside of an aggregation.

if(test, Sum(x))

If the test is true, Sum(x) -- that's all x values.

Sum(if(test, x))

Sum x values only where the test is true.

My guess is that in the example, all the reported counts for CountResponseNumber are too large.

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

topic KPIs and Tables. in App Development

KPIs and Tables.

Re: KPIs and Tables.

Re: KPIs and Tables.