Set Analysis - QlikView 12 vs Qlik Sense

[Anonymous]

This works just fine in QlikView 12 but not in Qlik Sense. Qlik Sense returns no result.

Is there something we need to add being stuck in the Qlik Sense web setup vs the client setup on QlikView?

sum({<RampDate = {'<=$(=WeekEnd(Today()))'}>}RampDayGoal)

[p_verkooijen · Accepted solution]

@Anonymous this syntax is "officially not correct" but has been a bug in Qlik for a long time

See https://community.qlik.com/t5/New-to-Qlik-Analytics/Set-analysis-difference-between-single-quote-and-double-quote/m-p/1339063/highlight/true#M96140

Official guidelines

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalysis/set-modifiers-advanced-searches.htm

So for a search you should use double qoutes " instead of single '

• sum({<RampDate = {"<=$(=WeekEnd(Today()))"}>}RampDayGoal)

• 

So it seems the bug has been fixed ..

[hic]

Well, it's because of the single quotes. Try double quotes instead. (QlikView accepts the single quotes if the app is old.)

See more on https://community.qlik.com/t5/Design/Quotes-in-Set-Analysis/ba-p/1471824