topic Re: Triggers on calculated dimensions in QlikView

Triggers on calculated dimensions

Anonymous — Thu, 10 Dec 2015 18:16:58 GMT

Hi Qlik Experts,

How to set triggers on calculated dimension and how to lock/unlock a field on leaving sheet from one to other sheet.

Ex: this is how data is being displayed in straight table, where 1,2,3 are the result of calculated dimension in sheet X, upon selection 1 in the table, it display only that row when we move from sheet X to Sheet Y which has the same straight table when we click on 1 it has to come normal state displaying 3 rows, which is not happening.

S.No product sales

1 A 100

2 B 200

3 C 300

Thanks in Advance.

Re: Triggers on calculated dimensions

sunny_talwar — Thu, 10 Dec 2015 18:19:58 GMT

I don't think this need any trigger. This is what should be happening by default. Can you share a sample which shows that this is not what is happening?

Re: Triggers on calculated dimensions

Anonymous — Thu, 10 Dec 2015 18:26:41 GMT

When we are in the same sheet its working Sunny, but when we move from one sheet to the other its not working the selection in the current selection box is getting unlocked. may i know whether we can implement a action/trigger on calculated dimension.

Thnks

Re: Triggers on calculated dimensions

Anonymous — Thu, 10 Dec 2015 18:59:42 GMT

Calculated Dimensions can be a pain and I am pretty sure you cannot have a trigger on them

How about you do the calculation in the script to create a proper dimension? Then everything should be lot simpler.

Re: Triggers on calculated dimensions

Anonymous — Fri, 11 Dec 2015 20:49:31 GMT

Thnks Bill,

Re: Triggers on calculated dimensions

Anonymous — Fri, 11 Dec 2015 22:00:16 GMT

Hello John,

it seems like it is a simple issue that can be cured by changing Sheet Properties. So for Sheet Y where u dont want the selection from X to carry over, you can go to sheet properties ----------> Triggers ---------> On Activate sheet ----------->

add Action------------> Clear All. so when u select 1 in sheet X and go to Y, Y, it will have a normal state with out any selections carried over. hth