Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

devarasu07
Honored Contributor 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

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

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

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

1 Reply
MVP
MVP

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

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

Community Browser