1 Reply Latest reply: Jul 10, 2016 10:28 AM by Liron Baram RSS

    Sorting in bar chart

    Sergey Kazantsev

      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