topic Re: Select In Field Trigger. Select one filter to force the selection of another in QlikView

Select In Field Trigger. Select one filter to force the selection of another

kaylaramsey2 — Sat, 16 Nov 2024 18:20:07 GMT

I'm struggling with my Select In Field Trigger.

I have a container object with 3 different charts in them. One of the charts has Patient, ComplicationNM, and ComplicationNBR. The ComplicationNBR can either be 1 or 0 (I'm using this field as a Numerator vs Denominator). What I would like to have happen is whenever a ComplicationNM is selected I would like the ComplicationNBR to always be 1.

I need to use a trigger to force the other 2 charts in the container object to show my new population.

Anyone able to help?

Re: Select In Field Trigger. Select one filter to force the selection of another

benvatvandata — Wed, 22 Jul 2020 22:10:24 GMT

Can't you do something in your expression like:

=if( getselectedcount(ComplicationNM)>0, only({< ComplicationNBR = {"1"} >} ComplicationNBR), only(ComplicationNBR))

Let me know if that works. It would help to see your expressions if it doesn't.

Thanks,

Ben

Re: Select In Field Trigger. Select one filter to force the selection of another

kaylaramsey2 — Thu, 23 Jul 2020 13:31:39 GMT

That didn't seem to work for my trigger. I was doing an 'OnActivateSheet' Trigger with the Field being ComplicationNM and the Search String as the expression you suggested.

Again, It has to be a trigger to force the other charts on the same page to filter on ComplicationNBR = '1' when a ComplicationNM is selected.

What you provided I think would work if I was only worried about the one chart but I need two other charts to function the same. I suppose I could add that expression in each chart but I think I would rather use a trigger.

Re: Select In Field Trigger. Select one filter to force the selection of another

benvatvandata — Thu, 23 Jul 2020 15:43:37 GMT

Try:

Go to Settings > Document Properties > Triggers > Field Event Triggers > Select ComplicationNM field and then click Add Action(s) button under OnSelect > Add 'Select in Field' action > Type in ComplicationNBR for the Field > Type in =1 in the Search String box.

Now whenever ComplicationNM field is selected, ComplicationNBR should automatically filter on 1.

Thanks,

Ben