topic Re: triggers - select based on expression in QlikView

triggers - select based on expression

shahafei2 — Mon, 24 Dec 2018 10:25:24 GMT

Hi all,

There is a way to set a trigger (OnChange of a variable - vMaxSales) that will select the required dates based on expression?

I would like to select the dates where the

sum(sales)<=$(vMaxSales)

How could i set it?

Re: triggers - select based on expression

Gysbert_Wassenaar — Mon, 24 Dec 2018 10:46:16 GMT

Add a Select in Field action to the OnChange variable trigger of your variable. Use your date field as the field in which to select the values. And use as search string ='=sum(sales)<=$(vMaxSales)'

Re: triggers - select based on expression

shahafei2 — Mon, 24 Dec 2018 10:51:57 GMT

Thank you

I tried to set it with an action "Select in field" but its not working for some reason

in the field i set "Date"

and in the search string i set

='=sum(Sales)<=$(vMax_Sales)'

Re: triggers - select based on expression

shahafei2 — Mon, 24 Dec 2018 11:08:16 GMT

I success to make it by

generation of a new resident table in the script

Daily sales:

Date,

Sum(Sales) as Daily_Sales

resident data

group by Date;

and than i set the (OnChange) trigger ("Select in field" action) to:

Field:

Daily_Sales

Search string:

='<=$(vMax_Sales)'

Re: triggers - select based on expression

Gysbert_Wassenaar — Mon, 24 Dec 2018 11:14:52 GMT

Perhaps the OnInput variable trigger works.