topic Re: Waterfall Comparison in QlikView

Waterfall Comparison

keithlawrence — Wed, 05 Aug 2015 09:02:45 GMT

I'm trying to do a waterfall that shows the difference between this period and last period.

I have a count of sites for last period of 100 and this period of 98. Obviously that is a difference of -2 but is made up of taking on an additional 4 sites and disposing of 6 sites. How do I count the number of disposals last period and count the number of additions this period?

My data looks like this:

Site No YearMonth

1 201502

2 201502

3 201502

4 201502

5 201502

1 201503

2 201503

3 201503

6 201503

This example would show 2 disposals (site 4 and 5) and 1 addition (site 6).

My goal is to allow the user to select which periods they want to compare but hopefully I'll be able to adjust the formula to allow this.

Any help would be appreciated.

Thanks

Re: Waterfall Comparison

Gysbert_Wassenaar — Wed, 05 Aug 2015 15:57:52 GMT

See attached example.

Re: Waterfall Comparison

keithlawrence — Thu, 06 Aug 2015 07:09:11 GMT

Thanks Gysbert but I'm looking for a Waterfall chart so need to remove the dimension. When that happens, the expressions don't return the correct results.

Re: Waterfall Comparison

rubenmarin — Thu, 06 Aug 2015 07:43:10 GMT

Hi Keith, I modified a bit the document provided by Gysbert so you can remove the dimension.

Re: Waterfall Comparison

Gysbert_Wassenaar — Thu, 06 Aug 2015 07:51:07 GMT

See attached qvw.

Re: Waterfall Comparison

keithlawrence — Thu, 06 Aug 2015 08:22:22 GMT

Thanks Ruben.

I can see yours worked in the example but I couldn't get it to apply to my model.

Thanks Gysbert it works exactly as I needed when I adjust to my app.

I spent all day trying to get it to work and you've cracked it in a few minutes! Perfect work.

Thanks again

Re: Waterfall Comparison

Thu, 06 Aug 2015 17:26:09 GMT

im not able to open da qvw file..

will u pls give the expressions involved in dat qvw file.

it will be more helpful for me if u give the expressions.

im also struggling with the same water fall chart problem