Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.