Dynamic min and max values for Slider Object

Thu, 14 May 2015 18:17:22 GMT

Hello,

I have a graph comparing 2 quarters, users can select any 2 quarters to compare and the graph updates accordingly. I am accepting 2 variables from users (each for one quarter) and using set expression for my X axis on the graph.

The expression looks like this -

=Sum({<YearQuarter= {'$(vYearQuarter1)'}>}MValue) - Sum({<Year = {'$(vYearQuarter2)'}>}MValue)

Now I want to obtain min and max values for the above set expression i.e. the min and max values from my X axis and use that as an input to the slider such that users will have ability to filter the values on X axis (e.g. to weed out the outliers). I will use a variable to capture the threshold set by slider and will show only values greater than the slider threshold. So my above graph expression will be

=IF(Sum({<YearQuarter= {'$(vYearQuarter1)'}>}MValue) - Sum({<Year = {'$(vYearQuarter2)'}>}MValue) > vthreshold, =Sum({<YearQuarter= {'$(vYearQuarter1)'}>}MValue) - Sum({<Year = {'$(vYearQuarter2)'}>}MValue))

But when I try to use Min and Max on the above set expression, I get garbage value error

=Min(Sum({<YearQuarter= {'$(vYearQuarter1)'}>}MValue) - Sum({<Year = {'$(vYearQuarter2)'}>}MValue))

How do I get the min and max values from the above expression i.e. min and max values for my X axis.

Thanks!

Re: Dynamic min and max values for Slider Object

sunny_talwar — Thu, 14 May 2015 18:32:14 GMT

Try this:

For Min:

=Min(Aggr(Sum({<YearQuarter= {'$(vYearQuarter1)'}>}MValue) - Sum({<Year = {'$(vYearQuarter2)'}>}MValue), YourChartDimensions)

For Max:

=Max(Aggr(Sum({<YearQuarter= {'$(vYearQuarter1)'}>}MValue) - Sum({<Year = {'$(vYearQuarter2)'}>}MValue), YourChartDimensions)

HTH

Best,

Sunny

Re: Dynamic min and max values for Slider Object

Thu, 14 May 2015 20:52:20 GMT

worked perfectly! thanks!

Re: Dynamic min and max values for Slider Object

sunny_talwar — Thu, 14 May 2015 20:54:41 GMT

Awesome

topic Re: Dynamic min and max values for Slider Object in QlikView

Dynamic min and max values for Slider Object

Re: Dynamic min and max values for Slider Object

Re: Dynamic min and max values for Slider Object

Re: Dynamic min and max values for Slider Object