clarifications on Waterfall Chart

[#1]

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

[Anonymous]

check this ..

YTD NSV LY :

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

[#3]

Hi Divya,

Uploading QVW is an option for you?

[#4]

Hi Allu ,

It is not working , Do you have any other solution