Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
MBV
Contributor II
Contributor II

Expression works in QV 12.10 but not in QV 12.40

Hey guys

We are using this expression in a pivot table to calculate the ytd value in QV 12.10:

Sum({$< Year={$(YTDYear)}, Month={'<=$(MaxBP)'} >}[Value])

The variables:
YTDYear= Year(Max(Date))
MaxBP=Max(Num(Month))

Why is it working in the older version but not in QV 12.40? 

The expressions seems to be ok but the result is always 0.

 

Thanks for your help

 

 

Labels (4)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

There has been some issues with set analysis and single/double quotes in some of the past releases. 

Try changing your single quotes to double. 

You could also take a look at these suppport cases: https://support.qlik.com/articles/000063567 and Quotes in Set Analysis with Dual Fields

View solution in original post

3 Replies
Vegar
MVP
MVP

There has been some issues with set analysis and single/double quotes in some of the past releases. 

Try changing your single quotes to double. 

You could also take a look at these suppport cases: https://support.qlik.com/articles/000063567 and Quotes in Set Analysis with Dual Fields

MBV
Contributor II
Contributor II
Author

Thank you so much!! It seems to work 😊

tresesco
MVP
MVP

With new QIX engine, thumb rule is - use single quotes for string matching and double quotes for searching.