topic Re: Sorting Qliksense bar chart in chronological order in App Development

Sorting Qliksense bar chart in chronological order

mkb_Qlik — Sat, 16 Nov 2024 20:09:24 GMT

Hi,

Kindly help me to sort to show below chart in chronological order of month. In this i am comparing Current year vs last year data.

Normal view giving me the chart in chronological order if i select particular year say 2019, chart alignment is going like above screenshot. Kindly help to fix this.

my expression:

Measure 1: Sum({$<ID ={'$(v_ID)'},Year = {'$(vMaxYear)'},Month_Name=,Month_Year=>}value)
Measure 2: Sum({$<ID ={'$(v_ID)'},Year = {'$(vMaxYear-1)'},Month_Name=,Month_Year=>}value)

Thanks in advance.

Re: Sorting Qliksense bar chart in chronological order

Vegar — Mon, 02 Sep 2019 21:30:43 GMT

How doea the chart sorting property look like? You could try to change it to this expression with ascending order.

=Only({1}Month)

Re: Sorting Qliksense bar chart in chronological order

mkb_Qlik — Tue, 03 Sep 2019 13:22:53 GMT

HI Vegar,

I used expression to sort the month in chronological order but this is working well in normal view.

When i filter 2019 data then alignment getting jumpled.

Re: Sorting Qliksense bar chart in chronological order

Vegar — Wed, 04 Sep 2019 05:51:04 GMT

Hmm... it's hard to say without looking at the application. It looks like you are not getting any sort order value for your unsorted months.

You could try to only sort by last years months by applying your set.

=Only({$<ID ={'$(v_ID)'},Year = {'$(vMaxYear-1)'},Month_Name=,Month_Year=>}Month)

If this doesn't work it then my tip is to do the following in order to understand what's going on.

Make a copy of your chart
Transform it into a straight table
Add your sort order expression as a measure in your table
Adjust it so you get a numeric value per row that correspond to your desired sort order
Copy this expression back into the sort order for your original chart.

Good luck