topic Re: Sorting in bar chart in App Development https://community.qlik.com/t5/App-Development/Sorting-in-bar-chart/m-p/1124507#M19545 <HTML><HEAD></HEAD><BODY><P>hi</P><P>you can do something like this</P><P>create the chart</P><P>use the date field as dimension</P><P>and use this expression</P><P>sum({&lt;Date={'&gt;$(=date(max(Date)-5))'}&gt;}Sales)</P></BODY></HTML> Sun, 10 Jul 2016 14:23:48 GMT lironbaram 2016-07-10T14:23:48Z Sorting in bar chart https://community.qlik.com/t5/App-Development/Sorting-in-bar-chart/m-p/1124506#M19544 <HTML><HEAD></HEAD><BODY><P>Hello everyone <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>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.</P><P>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.</P><P>Can anyone explain how to sort the last 5 days in bar chart?</P><P>Thanks in advance <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sat, 16 Nov 2024 10:31:19 GMT https://community.qlik.com/t5/App-Development/Sorting-in-bar-chart/m-p/1124506#M19544 2024-11-16T10:31:19Z Re: Sorting in bar chart https://community.qlik.com/t5/App-Development/Sorting-in-bar-chart/m-p/1124507#M19545 <HTML><HEAD></HEAD><BODY><P>hi</P><P>you can do something like this</P><P>create the chart</P><P>use the date field as dimension</P><P>and use this expression</P><P>sum({&lt;Date={'&gt;$(=date(max(Date)-5))'}&gt;}Sales)</P></BODY></HTML> Sun, 10 Jul 2016 14:23:48 GMT https://community.qlik.com/t5/App-Development/Sorting-in-bar-chart/m-p/1124507#M19545 lironbaram 2016-07-10T14:23:48Z