topic Re: clarifications on Waterfall Chart in QlikView

clarifications on Waterfall Chart

Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys ,

i have an Urgent requirement on Qlikview Waterfall Chart , i went through the blogs but i am not getting how to do the below requirement.

Can you guys please help me in solving this .

Requirement :

i have calculated YTD NSV LY and YTD NSV Actual in the expression tab.

i have the doubts how to use the Unit (Eg : UK , France , Germany ...) to calculate both YTS NSV LY and YTD NSV Actual .

YTD NSV LY : Sum({<Year={'2015'}>}NSV)

YTD NSV Actual : Sum({<Year={'2016'}>}NSV)

Attached the Mock up .

Thanks

Divya

Re: clarifications on Waterfall Chart

Anonymous — Mon, 31 Oct 2016 15:53:05 GMT

check this ..

YTD NSV LY :

aggr(Sum({<Year={'2015'}>}NSV),Unit)

Re: clarifications on Waterfall Chart

Mon, 31 Oct 2016 22:07:32 GMT

Hi Divya,

Uploading QVW is an option for you?

Re: clarifications on Waterfall Chart

Tue, 01 Nov 2016 13:56:24 GMT

Hi Allu ,

It is not working , Do you have any other solution