Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

paulyeo11
Valued Contributor II

In QS does it support Add Calculated Dimension ?

Hi All

I have a chart work fine in QV , and when i try to create the same chart in QS.

In QV I need to place the below expression at Dimension at Add Calculated Dimension :-

=if(aggr(sum({<eXP={eXP}>}Amount*-1),EXP_TYPE) / aggr(sum(total <year> {<eXP={eXP}>}Amount*-1), $(ColumnDim101)) > 0.001, EXP_TYPE, 'OTHERS')

I not sure where to place it in QS.

Hope some one can share with me.

Paul

1 Reply
paulyeo11
Valued Contributor II

Re: In QS does it support Add Calculated Dimension ?

Enclosed my QV chart which is work fine.

Community Browser