topic Re: Set Analysis ignore fields does not working properly - Qlikview12 in QlikView

Set Analysis ignore fields does not working properly - Qlikview12

Anonymous — Sat, 21 Apr 2018 13:45:46 GMT

Hi Guys,

I got an strange behavior of ignoring the fields in set analysis in my line chart. I have 3 expressions in a line chart and have ignored the Year & Month filter in all three expressions, but in one expression it doesn't work properly and works perfectly in the other two.

Expressions are below,

Exp 1 : Sum({<Month=,Year=>}Sales)

Exp 2: Sum({<Month=,Year=>}Cost)

Exp 3: Avg({<Month=,Year=>}Cost)

All three expressions are used in line chart against the date field as dimension. Exp 1&2 works fine but Exp 3 is not ignoring the Month & Year field selections.

Did anyone face any issues similar to this, while searching i found one similar issue but with Qliksense not with Qlikview.

I'm using Qlikview 12 SR 4.

Link to the community discussion : Qlik Sense - Set Analysis Ignore field does not work properly

Please help.

Re: Set Analysis ignore fields does not working properly - Qlikview12

Gysbert_Wassenaar — Sat, 21 Apr 2018 16:43:04 GMT

Make sure you use the exact case sensitive field names. Try removing the third expression and recreating it as a new expression.

Re: Set Analysis ignore fields does not working properly - Qlikview12

shiveshsingh — Mon, 23 Apr 2018 05:08:25 GMT

Can you share your app?

Re: Set Analysis ignore fields does not working properly - Qlikview12

Anonymous — Sun, 29 Apr 2018 16:12:11 GMT

Thanks all for your reply, I didn't find the cause of the issue. But changed the way the Month and Year getting calculated in the script level and the issue got resolved.

Thanks again.