Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ivanyang25
New Contributor III

How to group dimension by expression in master item?

Dear QS Experts

I am new to QS and I am a front end user (Which means I don’t write script fm QS backend side). I have a question regarding to dimension set up in master item


Below is my raw data and there are 13 types in [Product] column which are:

Unship / Unrelease / Delay / New / Credit / Quality / Supply / Timing / VIP / Customer / Partner / Medic / School

捕获.PNG

Usually I can group them in dimension master item by below expression and use it for pivot table.

捕获.PNG

Now I want to set up one group (name ‘Scope’) which excludes ‘Unship’ & ‘Unrelease’ without writing other 11 types in expression as below.

The reason I don’t wanna writing other 11 types in expression is these types are dynamic in raw data. Today we have 13 types tomorrow we may have 15 types and 20 in the next week. But one thing I am sure that is ‘Unship’ & ‘Unrelease’ always exists in everyday raw data. That’s why I wanna exclude them in dimension (I don't need to exclude them while importing raw data to QS, no need to change any script fm back end). I try Product = - ‘Unship’ or Product =-‘Unrelease’ but neither one can work


捕获.PNG

You could kindly check raw data and test apps in the attachment for your reference


Thank you for your support in advance


Best Regards

Ivan

1 Reply
OmarBenSalem
Esteemed Contributor

Re: How to group dimension by expression in master item?

Maybe :

=if(Product ='Unship' or Product='Unrelease' , 'Static','Dynamic')

see the attached app:

Community Browser