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: 
devarasu07
Master II
Master II

Column() function & Pivot row into Column transformation not working?

Hi All,

How can we achieve this in qlik sense. (this is so simple in qlik view using - Column function and pivot table >> row into column transformation  or calculated dimension method). but qlik sense default chart unable to find such a feature. is there any extension?

FYI

Capture.JPG

using qlikview able to achieve but how to do this in qlik sense?

qlik.JPG

Thanks,

Deva

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try sales expression like:

If ( Dimensionality()=1, Sum(Sales),

  Num((Sum({<Year={2017}>}Sales)-Sum({<Year={2016}>}Sales))/Sum({<Year={2017}>}Sales),'#,##0.0%'))


Capture.PNG

View solution in original post

1 Reply
tresesco
MVP
MVP

Try sales expression like:

If ( Dimensionality()=1, Sum(Sales),

  Num((Sum({<Year={2017}>}Sales)-Sum({<Year={2016}>}Sales))/Sum({<Year={2017}>}Sales),'#,##0.0%'))


Capture.PNG