topic Re: Trigger--listbox in QlikView

Trigger--listbox

rdsuperlike — Mon, 18 May 2015 23:49:11 GMT

I have a list box with with Qtr = Q1, Q2 and Q3.

I have another list box with Final Qtr = Q1, Q2, Q3.

When I select on Qtr= Q1, I want to create a trigger to pick up Final Qtr = Q1 too.

Also, In the selection box i want to see only Qtr = Q1 selected.

I dont want user to see that calculation happening at backend. So Current selectio box should show only Qtr = Q1.

Any help?

Re: Trigger--listbox

SergeyMak — Tue, 19 May 2015 02:06:21 GMT

Hi,

The answer is bellow.

Try to use Field Event Trigger

Re: Trigger--listbox

rdsuperlike — Tue, 19 May 2015 04:50:49 GMT

works fine.

But it doesn't work if I select Qtr 2 and 3 both.

I want that to be reflected too.

Also, is there a way that If i use current selection box, I dont show final qtr values in the current selection box?

Re: Trigger--listbox

jonathandienst — Tue, 19 May 2015 05:08:57 GMT

Do you really need a trigger? I would define a globally evaluated variable (ie one with a leading = sign), like this (if you define it in your script (assuming Qtr is a string field):

Set vMaxQ = =MaxString(Qtr); // the = = is not a typo

This variable will contain the maximum possible Qtr, so if nothing is selected, it will be the max Qtr in your model, or if something is selected, it will contain the selected value (actually the max of the selected values).

You can use vMaxQ in set expressions and chart captions

Sum({<Qtr = {"$(=vMaxQ)"}>} Sales) //expression

='Sales for ' & vMaxQtr //caption or label

HTH

Jonathan

Re: Trigger--listbox

rdsuperlike — Tue, 19 May 2015 05:14:26 GMT

No. We dont want to add any changes to the script

Re: Trigger--listbox

abhaysingh — Tue, 19 May 2015 05:14:28 GMT

Hi, you need to set Field Event Trigger

select field qtr, set add action , go to select in field and pass field Final Qtr and in select string write getfieldselection(Qtr).

make sure both field value should be same

regards

Abhay

Re: Trigger--listbox

tresB — Tue, 19 May 2015 05:15:38 GMT

Check the attached sample qvw. For not showing the selection in the current selection box, play the trick of HidePrefix system variable in the script.

Re: Trigger--listbox

jonathandienst — Tue, 19 May 2015 05:20:17 GMT

If you don't want to change the script, then define the variable in the Variable Overview dialog. Define it with a leading = sign:

=MaxString(Qtr)

Re: Trigger--listbox

Thu, 21 May 2015 16:56:00 GMT

Hi tresesco‌

I wonder if you can help me on how to hide the list box , take the example of your qvd , but to try do not hide me the picture, which is what I need , I attached to the example and mine , for you to see

Help me

Re: Trigger--listbox

tresB — Fri, 22 May 2015 04:36:21 GMT

Sorry, did not get your point.

Re: Trigger--listbox

Fri, 22 May 2015 12:44:39 GMT

thanks for replying , understood the qvd for triggers,I did not know where to configure this condition tresesco‌