Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi guys,
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??
kindly suggest..
regards
Abhay
Hi,
You may find a waterfall chart Sense Visualization in qlik branch :
here :
by
but it is taking 1 dimension and 1 measure only....i have 5 measure how i can plot it in this extension??
Hi
Try this :
It's a trick in Qsense to simulate a waterfall chart,
Not sure nethertheless it's accepting multiple mesures
https://community.qlik.com/docs/DOC-8293
Bruno
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..!!
kindly suggest
Hi
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
Sorry
Bruno
That's because you don't 5 separate measures, just pick/match or do conditional IFs
Measure:
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) )