Qliksense Bar Chart Limitation with Slider

[gavinjohn]

Hi

I have a table with 1 dimension and 3 measures. I have sorted descending by measure 1. I use a slider (vSlider) to limit the number of lines I wish to see.

If I use the same slider with a bar chart I am not able to maintain sort by measure 1.

All suggestions welcomed.

[ericasense]

The sort you've used in the bar chart is  calculated using the measure, not the dimension name.

You can try limiting the number of values returned in the expression by using set analysis in a clever way? or an if statement

=if(replace(Reason,'Reason','')<= vSlider,Avg(Kpi1))

This will return null whenever the last digit of "Reason" is greater than vSlider, and the chart will not compile null items.

Erica

[ericasense]

....And this is what it says under the option to limit the x axis:

[gavinjohn]

Thanks Erica. It works perfectly

Your solution works perfectly with the test app I uploaded.

I am stumped when applying same to my actual data. My attempt on sheet 2 second bar graph.

Thank you in advance

Gavin J