Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
stephenedberkg
Creator II
Creator II
‎2018-03-16 01:27 AM

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
Before test.qvw
696 Views
0 Likes
1 Solution

Accepted Solutions
tresesco
MVP
MVP
‎2018-03-16 02:19 AM

In response to stephenedberkg

Like this (PFA)?

View solution in original post

Before test2.qvw
601 Views
0 Likes
2 Replies
stephenedberkg
Creator II
Creator II
‎2018-03-16 01:58 AM
Author

Is it possible in qlikview???

stalwar1‌

601 Views
0 Likes
tresesco
MVP
MVP
‎2018-03-16 02:19 AM

In response to stephenedberkg

Like this (PFA)?

Before test2.qvw
602 Views
0 Likes