Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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
Master
Master
Author

Enclosed my QV chart which is work fine.