Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER 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

View solution in original post