topic Re: Set analysis, Sum if in Qliksense return wrong result when i filter field in condition. in App Development

Set analysis, Sum if in Qliksense return wrong result when i filter field in condition.

thuan — Fri, 02 Apr 2021 08:06:11 GMT

Hi everybody,

I have a question about. Sum if in QLiksense

I have 1 KPI with name is "Manual JEs"

This is my formula.

SUM({<B06_ZF_ENTRY_TYPE={'Manual'}>} [B06_ZF_NUM_GL_LINES])

But. When i Filter B06_ZF_ENTRY_TYPE ='Regular' .I mean different with condition in my formula.

The result should be returned for me "Nothing".

But result return for me the same "284k" ( Same with B06_ZF_ENTRY_TYPE={'Manual} ). Why ???

If someone knows that. Please lets me know. Thanks all

Re: Set analysis, Sum if in Qliksense return wrong result when i filter field in condition.

dplr-rn — Tue, 10 Sep 2019 15:42:44 GMT

When you use set analysis any other selection of B06_ZF_ENTRY_TYPE is ignored.
If you want it to consider other selections change it to
B06_ZF_ENTRY_TYPE*={'Manual'}

Re: Set analysis, Sum if in Qliksense return wrong result when i filter field in condition.

kaushiknsolanki — Tue, 10 Sep 2019 15:42:50 GMT

Hi,

When you use a field in a set analysis it always overrides the selection made in same field. Meaning it will always show you result for the same value which you have passed in set analysis.

Thus even after making selection in the field it shows the earlier result.

Regards,

Kaushik Solanki

Re: Set analysis, Sum if in Qliksense return wrong result when i filter field in condition.

thuan — Wed, 11 Sep 2019 04:01:56 GMT

sum({<B06_ZF_ENTRY_TYPE *= {'Manual'}>} B06_ZF_NUM_GL_LINES)

Yes, I add * before = , So it's work nice for me.

Thank you very much.

Re: Set analysis, Sum if in Qliksense return wrong result when i filter field in condition.

thuan — Wed, 11 Sep 2019 04:02:51 GMT

Like this.

Re: Set analysis, Sum if in Qliksense return wrong result when i filter field in condition.

dplr-rn — Wed, 11 Sep 2019 14:15:06 GMT

Happy to have helped. but the whole point of this community is to appreciate the people helping you by marking their answers as the solution.

Not your own

Otherwise there is not incentive to help