Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to sum the pivoted column

My data is in the below format 

  

Name    Year    Sales
IBM2013100
MS2013200
APPLE2013300
IBM2014150
MS2014250
APPLE2014300
IBM2015350
MS2015200
APPLE2015300

I need out put in below format

Output Format
Name201320142015  (2013+2015)(2013+2014)(2014+2015)
IBM100150350  100+350100+150150+350
MS200250300  200+300200+250250+300
APPLE300300300  300+300300+300300+300

I should be able to add the pivoted columns (Year ) .Please help me with logic.

Thanks

11 Replies
sunny_talwar

Very nice Stefan. How do you think of all these ideas man. I need to start thinking like you somehow

swuehl
MVP
MVP

You are too kind!

This flag multiplication is definitely something to remember, not that it is something new, far from that, it was and is quite common in Qlik world (maybe a bit less used with the arrival of set analysis, though there is an ongoing discussion which is more performant).

If the OP wants more like a front end solution, maybe something using your ValueList() samples could also work here?

(You probably can read my mind...)