Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
clik_reporter
Contributor II
Contributor II

Set Analysis ignore fields does not working properly - Qlikview12

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.

1 Solution

Accepted Solutions
clik_reporter
Contributor II
Contributor II
Author

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.

View solution in original post

3 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
shiveshsingh
Master
Master

Can you share your app?

clik_reporter
Contributor II
Contributor II
Author

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.