Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis - Set Modifier with Variable and Less Than or Equal too

I am trying to create a chart using set analysis that will show all years up to what the user has selected.  I have a "Year" selection box set to "must have one value selected" with values from 2008-2011.  If the user selects 2010, the chart needs to show 2008-2010.  If the user selects 2011, looking for chart to show 2008-2011.  Attempting to use set analysis with less than or equal.  I have tried putting the less than or equal to on the Year field itself or with a variable that returns the value of the year currently selected.  Neither case works.  However, if I hard code in a year, the less than or equal to will work.  Ex.

= sum ( { 1 < Year = { "<= 2010"}>} Balance) works fine, and no matter what value is selected in the Year field, my chart is correctly showing the sum for years 2008, 2009, and 2010.  However, when I attempt to use either the Year field itself, or a variable returning the value of the field, as shown below, I get "No Data to display"

= sum ( { 1 < Year = { "<=Year"}>} Balance) does not work, returns no data to display, also:

= sum ( { 1 < Year = { "$(<=$(YearSelected))"} > } Balance) returns no data to display.

YET, if I remove the less than symbol from the code with the variable name, and just keep the = sign, the chart will display the single data point for the year selected

= sum ( { 1 < Year = {"$(=$(YearSelected))"} > } Balance) returns the single data point for the currently selected year.

I'm assuming I must have a syntax error somewhere, but my syntax follows what I've found in other threads.

Am I just totally missing something???

Thanks in advance for any help

1 Solution

Accepted Solutions
Not applicable
Author

{$< Year = {"<=$(=Max(Year))"}>}

View solution in original post

4 Replies
Not applicable
Author

{$< Year = {"<=$(=Max(Year))"}>}

Not applicable
Author

Appriciate the fast response, but unfortunetly that also returns "no data to display"

We are on QV v9, SR 6 if that matters.

Not applicable
Author

How about

{$< Year = {"<=$(=GetFieldSelections(Year))"}>}

Not applicable
Author

Went to try the 2nd suggsetion and found I had a typo in your first suggestion.  That worked!! Thank you so much for helping a noob!!