Remove selected fields from dimension

[#1]

Please consider the following 3 triggers for different product:

Trigger1 - Product1

Trigger2 - Product2

Trigger3 - Product3

I have a field for product consisting of above 3 products :

Product

Product1

Product2

Product3

How can I make a table with a dimension 'Product' which work as follows :

If 'Trigger1' is selected, the dimension table shows 'Product2' and 'Product3' ,

If 'Trigger2' is selected, the dimension table shows 'Product1' and 'Product3' ,

If 'Trigger3' is selected, the dimension table shows 'Product1' and 'Product2' ,

If 'Trigger1' and 'Trigger2' is selected, the dimension table shows 'Product3'

.....

Basically, whichever triggers are selected, the same products shouldn't come in the dimension while calculating expressions.

[Chanty4u]

did u try select in field trigger?

[tresesco]

May be like:

Chart dim: Product

Exp: Sum({<Trigger=e(Trigger)>}Amount)

[vikasmahajan]

check with this https://community.qlik.com/thread/87839

Vikas

[Kushal_Chawda]

Instead you can try to use the product Field itself to select

Dimension: Product

Expression:

=Sum({<Product = e(Product)>}Amount)

Update

[#6]

You can put a select in field trigger in Actions

For Trigger1 => Product1

in Field type Product

and in Search String put ("Product2"|"Product3") , don't use = sign in search string

For Trigger2 =>

in Field type Product

and in Search String put ("Product1"|"Product3") , don't use = sign in search string

For Trigger3 =>

in Field type Product

and in Search String put ("Product1"|"Product2") , don't use = sign in search string

Regards,

Anjali Gupta