Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
stephenedberkg
Creator II
Creator II

pivot chart YTD values from previous column

i want to show YTD (Rangesum) values in pivot chart based on previous column values.

i have attached the sample applications

I have data like below

  

Year201320132013201320132013201320132013201320132013
ProductMonthJanFebMrzAprMaiJunJulAugSepOktNovDez
P1 847364527640700690886596789844405530
P2 6431236652806875638708767784759971893

i want to show like that

   

Year201320132013201 !320132013201320132013201320132013201320132013201320132013201320132013201320132013
MonthJanJan YTDFebFeb YTDMrzMrz YTDAprApr YTDMaiMai YTDJunJun YTDJulJul YTDAugAug YTDSepSep YTDOktOkt YTDNovNov YTDDezDez YTD
84784736412115271738640237870030786903768886465459652507896039844688340572885307818
643643123618796522531806333787542126384850708555876763257847109759786897188398939732
1 Solution

Accepted Solutions
tresesco
MVP
MVP

2 Replies
stephenedberkg
Creator II
Creator II
Author

Is it possible in qlikview???

stalwar1

tresesco
MVP
MVP

Like this (PFA)?