Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Waterfall chart with time dimension

Hello,

i would like to create a waterfall chart with time dimension. That means I can choose between year and month and the measure are based the selection. The starting point should be the measures of the last mont. For exampel, if I want to show the sales of December 2016, the first sales measure must be November 2016 and the last one December 2016.  I have taken the dynamic waterfall chart to create the waterfall chart I want. But I don´t get working.

I hope my problem is understable.

Does anybody have created something like that or know how to do it?

Thanks for every answers!

Christian

7 Replies
sunny_talwar
Not applicable

Re: Waterfall chart with time dimension

Would you be able to share a sample of where you have been trying this out?

Not applicable

Re: Waterfall chart with time dimension

Hello Sunny,

the sample you aked for.

I took the script structure like it is used in the example of the dynamic waterfall chart.

But I don´t know if I should include the time dimension in the script or in formula.

Thanks for your help.

Christian

sunny_talwar
Not applicable

Re: Waterfall chart with time dimension

So for right now, without selections everything looks good? All you want is that once you make a selection in particular Datum, it should show the selected month and the previous month? Do I understand this right?

Not applicable

Re: Waterfall chart with time dimension

Hi Sunny,

sorry my late response. I thought I have already answered your question.

Yes, you got it right. I have a screenshot how it looks like in excel:

The bar on the left side, shows the privious month (October) and right one shows the cumulated measures of November.

I hope it makes my issue more clear.

Thanks

Christian

Not applicable

Re: Waterfall chart with time dimension

No one can help me with my problem?

sunny_talwar
Not applicable

Re: Waterfall chart with time dimension

I understand what you are looking for, but what are these dimension values here? These seems very different from the chart?

Capture.PNG

Is this the Sum of all individual values for last period? and the one on the right the same for this period and then use the in between bars to show the change?

agrimroquette
Not applicable

Re: Waterfall chart with time dimension

Hi Sunny i have a question i want help only from you,

i have a column name of students, how can i exclude onle one name to show in qlik sense filter. PLEASE HELP