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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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.