topic Re: Remove selected fields from dimension in QlikView

Remove selected fields from dimension

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Remove selected fields from dimension

Chanty4u — Thu, 07 Apr 2016 06:54:18 GMT

did u try select in field trigger?

Re: Remove selected fields from dimension

tresB — Thu, 07 Apr 2016 07:00:10 GMT

May be like:

Chart dim: Product

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

Re: Remove selected fields from dimension

vikasmahajan — Thu, 07 Apr 2016 07:07:00 GMT

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

Vikas

Re: Remove selected fields from dimension

Kushal_Chawda — Thu, 07 Apr 2016 07:12:22 GMT

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

Dimension: Product

Expression:

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

Update

Re: Remove selected fields from dimension

Thu, 07 Apr 2016 07:25:31 GMT

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