Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
stephenedberkg
Creator III
Creator III

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 III
Creator III
Author

Is it possible in qlikview???

stalwar1

tresesco
MVP
MVP

Like this (PFA)?