Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Waterfall charts with metrics created using expressions

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

0 Replies