Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
help4qv123
Creator II
Creator II

Pivot in different way (waterfal)

Hi guys,

I need some help. i have a requirement like a waterfall. bit confused .

Capture.PNG

i got the sol as

Capture2.PNG

I need as above. Thanks ! in advance. I am attaching sample data and QVW.

1 Reply
petter
Partner - Champion III
Partner - Champion III

From your data it is hard to see where the numbers above the gray shaded ones on the diagonal would come from... Are they calculated based on the numbers on the diagonal or are they simply missing in your Excel Sheet? Could you please give us a bit more information about how you want to derive the extra data?