Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Yes, that would be better. Something like this then :
And finaly in your chart :
I can send you the qvf if you want 🙂
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
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
Hello @sde821,
Could you paste here the data in tabular mode ? (and not in picture)
Then I can try on my Qlik 🙂
Thanks
Hi Antoine,
in my example I would need the sum of the datapoints closed, cancelled and waiting.
Thank you!
Anna
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)
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?
Yes, that would be better. Something like this then :
And finaly in your chart :
I can send you the qvf if you want 🙂
Thank you! Perfect solution!