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

Wed, 16 Nov 2011 18:41:47 GMT

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

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

Wed, 16 Nov 2011 18:47:20 GMT

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

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

Wed, 16 Nov 2011 18:53:37 GMT

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

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

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

Wed, 16 Nov 2011 19:10:23 GMT

How about

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

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

Wed, 16 Nov 2011 20:05:51 GMT

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!!

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

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

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

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

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

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