7 Replies Latest reply: Aug 25, 2015 9:42 AM by Alexander Karlsson

# Waterafall model Qliksense

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

• ###### Re: Waterafall model Qliksense

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

Waterfall Chart

regards

• ###### Re: Waterafall model Qliksense

Hi,

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

here :

## Waterfall Chart

by

• ###### Re: Waterafall model Qliksense

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

• ###### Re: Waterafall model Qliksense

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

• ###### Re: Waterafall model Qliksense

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

• ###### Re: Waterafall model Qliksense

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

• ###### Re: Waterafall model Qliksense

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