topic Re: Qliksense Bar Chart Limitation with Slider in App Development

Qliksense Bar Chart Limitation with Slider

gavinjohn — Sat, 16 Nov 2024 08:49:34 GMT

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.

Re: Qliksense Bar Chart Limitation with Slider

ericasense — Tue, 23 Jan 2018 14:24:04 GMT

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

Re: Qliksense Bar Chart Limitation with Slider

ericasense — Tue, 23 Jan 2018 14:25:06 GMT

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

Re: Qliksense Bar Chart Limitation with Slider

gavinjohn — Tue, 23 Jan 2018 14:58:23 GMT

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