Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
gavinjohn
New Contributor

Qliksense Bar Chart Limitation with Slider

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.

3 Replies
ericasense
New Contributor III

Re: Qliksense Bar Chart Limitation with Slider

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
New Contributor III

Re: Qliksense Bar Chart Limitation with Slider

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

Capture.PNG

gavinjohn
New Contributor

Re: Qliksense Bar Chart Limitation with Slider

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