0 Replies Latest reply: Sep 12, 2018 9:15 AM by Pankaj Sharma RSS

    Waterfall charts with metrics created using expressions

    Pankaj Sharma

      Hi All,

       

      I am trying to create a waterfall chart for sales data.

      The reasons/restrictions resulting in sales drop are listed in a column called "Restrictions" and it also has the total sales and actual sales after deducting each restriction value from sales.

       

      This table is created using ETL flow and all business rules have been taken into account for fetching the values into these columns.

       

      the structure looks like:

       

      Product     Restriction     Metric

      A               total               100

      A               expenses        30

      A               taxes               20

      A                actual              50

       

      Now,I am creating metrics in waterfall chart by manually adding expressions like

      Sum({<[RESTRICTION] = {'EXPENSES'}>} SALES)

       

      Now, in future if a new restriction say abc comes due to which sales have been dropped, that won't be automatically refreshed in the report. We would need to manually add it.

       

      Is there any way to make the expression dynamic in Qliksense so that new restrictions are added and made dynamic insted of hard coding it?

       

      Thanks