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

devarasu07 — Wed, 03 May 2017 03:16:58 GMT

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

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

tresB — Wed, 03 May 2017 04:53:01 GMT

Try sales expression like:

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

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

topic Re: Column() function & Pivot row into Column transformation not working? in Visualization and Usability

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

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