Sorting Bar Chart

[sde821]

Hi all,

I have a problem by sorting a bar chart by dimension quarter. I want to show only the last 4 quarters in my bar chart. It should change dynamically when data of the next quarter is available. At the moment my bar chart looks like this:

instead of Q3 2023, Q4 2022 is shown. 

Settings of sorting is numerically ascending. 

other settings:

It looks like Qlik is still sorting by measure 'Zugänge'.

I don't know whats wrong and how to change this. 

I appreciate every help.

[sde821]

[Antoine04]

Hello,

Indeed, you won't be able to show the last 4 by using this option.

My best advice would be to use a formula in the set analysis to do this.

Something like : Sum({<QuarterName={">=$(=QuarterName(AddMonths(Today(),-12)))"}>}Sales)

Best regards,

Antoine L

[Antoine04]

I just tried and it's working.

My DATA are shown in the table :

Here is the formula of the barchart :

Sum({<Date={">$(=AddMonths(Max(Date),-12))"}>}Amount)

Best Regards,

Antoine L

[Antoine04]

Hello @sde821,

Could you paste here the data in tabular mode ? (and not in picture)

Then I can try on my Qlik 🙂

Thanks

[sde821]

Hi Antoine,

in my example I would need the sum of the datapoints closed, cancelled and waiting.

Thank you!

Anna

[Antoine04]

OK, I see. So what you need to do in the Excel file is first to associate a Date to each Quarter, so maybe something like this in the load script :

Then, I get this. Does it fit your expectation ?

The formula is : Sum({<Date={">$(=AddMonths(Max(Date),-12))"}>}Amount)

[sde821]

I would need to put the datapoints into different groups. For example open, waiting and and new as group 1, old, closed and cancelled as group 2 and so on. Maybe I can do this in my load script?

[Antoine04 · Accepted solution]

Yes, that would be better. Something like this then :

And finaly in your chart :

I can send you the qvf if you want 🙂

[sde821]

Thank you! Perfect solution!