Qlik Community

Qlik Sense App Development

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

Not applicable

Sorting in bar chart

Hello everyone

Yesterday I faced with the following problem in Qlik Sence. I have some sales data by days from the beginning of 2016Y. First of all I showed the total amount of sales by the last available day. This case was successfully solved.

Then I would like post the bar chart below the KPI. On X-axis - days, Y-axis - Sum of amount. BUT! I need show the sales amount by the last 5 days. In default settings I can sort top-10/50/100 by the total sum or write some formulas for sorting, but also it links with total sum, not the days.

Can anyone explain how to sort the last 5 days in bar chart?

Thanks in advance

1 Reply
lironbaram
Honored Contributor II

Re: Sorting in bar chart

hi

you can do something like this

create the chart

use the date field as dimension

and use this expression

sum({<Date={'>$(=date(max(Date)-5))'}>}Sales)