Discussion Board for collaboration related to QlikView App Development.
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
How could i set it?
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)'
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
I success to make it by
generation of a new resident table in the script
Sum(Sales) as Daily_Sales
group by Date;
and than i set the (OnChange) trigger ("Select in field" action) to: