Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
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