QlikView App Dev

[clik_reporter]

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.

[Gysbert_Wassenaar]

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

[shiveshsingh]

Can you share your app?

[clik_reporter · Accepted solution]

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.