Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner
Partner

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

3 Replies
Partner
Partner

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Contributor II
Contributor II

Thank you so much!! It seems to work 😊

MVP
MVP

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