Discussion board where members can get started with Qlik Sense.
i want to create a waterfall model in qliksense.....
i have few measure like Revenue, budget, expenses, Margin which i am calculating at front end through some logic.
i qlikview i can design Waterfall Chart with offset.. but in qliksense how i can achieve it??
You have an extension in "Branch website". look if it fits your needs.
You may find a waterfall chart Sense Visualization in qlik branch :
but it is taking 1 dimension and 1 measure only....i have 5 measure how i can plot it in this extension??
Try this :
It's a trick in Qsense to simulate a waterfall chart,
Not sure nethertheless it's accepting multiple mesures
in this script all measures define in inline ... but how i can define all measure in inline?? as i m calculating all at front-end..!!
A don't know how to help you otherwise.
You should post a sample of your qlik app or sample of data so that the community could help
That's because you don't 5 separate measures, just pick/match or do conditional IFsMeasure:If(Dimension = 'Value1', Sum(Expression1),
if(Dimension = 'Value2', Sum(Expression2))
and so on
Dont have a dimension at all? Then create one using valuelist,
ValueList('Dimension1', 'Dimension2', 'Dimension3')
Then in your measure
If( ValueList('Dimension1', 'Dimension2', 'Dimension3') = 'Dimension1', Sum(Expression1) )