topic Re: Create Sheet Action on Master Dimension in App Development

Create Sheet Action on Master Dimension

shannonmarshall_329 — Tue, 05 Mar 2024 21:19:43 GMT

Hello, I have created a master dimension that looks at field values across tables and is aggregated to a single field. When I use the master dimension as a filter it works good, however since it is aggregated to a single field I cannot create a bookmark because the field values will not update. I would like to create an action on the sheet to set the value of the master dimension but it appears that is not valid in Qlik. Any help would be greatly appreciated.

Thanks,

Shannon

Re: Create Sheet Action on Master Dimension

okcmoi — Wed, 06 Mar 2024 15:43:39 GMT

Hello @shannonmarshall_329 !

The page action you should select since you have a dynamic dimension is "select a value in a field" and then enter the expression of the Value you want.

If the value you want is not dynamic and there are several, remember that to write it, it is like :

='Value1;Value2;Value5'.

Re: Create Sheet Action on Master Dimension

shannonmarshall_329 — Wed, 06 Mar 2024 20:27:50 GMT

Thanks for the suggestion, however, the master dimension is not available for me to pick in the list of fields to select a value from.