Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thank you so much!! It seems to work 😊
With new QIX engine, thumb rule is - use single quotes for string matching and double quotes for searching.