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

[thuan]

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

[dplr-rn · Accepted solution]

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'}

[kaushiknsolanki]

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

[thuan · Accepted solution]

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.

[thuan]

Like this. 

[dplr-rn]

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