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

[devarasu07]

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

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

Thanks,

Deva

[tresesco · Accepted solution]

Try sales expression like:

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

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