Waterafall model Qliksense

[abhaysingh]

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

[fredericmante]

You have an extension in "Branch website". look if it fits your needs.

Waterfall Chart

regards

[brunobertels]

Hi,

You may find a waterfall chart Sense Visualization in qlik branch :

here :

A customizable waterfall chart for Qlik Sense

Waterfall Chart

by

Alexander Karlsson 
Bruno

[abhaysingh]

but it is taking 1 dimension and 1 measure only....i have 5 measure how i can plot it in this extension??

[brunobertels]

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

[abhaysingh]

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

[brunobertels]

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

[Alexander_Thor]

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) )