Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to Input Box which will have default value of Max(Sales Order). By default report will show data for Max(sales Order). If user changes value in Input Box then the report output should also change accordingly.
Hi,
Set a variable with value Max(sales Order) and use that variable in input box and in report expressions.
Hope this is your need.
Celambarasan
I created input box and assigned variable with max(sales order) value to it.
Now how do I use it in expression?
Hi,
Use this variable in the expressions which you used in the charts.
Regards,
Jagan.
Can you send me sample expression syntax?
Hi,
Please check the set analysis expression below from Qlikview help file
sum( {$<Year = {$(#vLastYear)}>} Sales )
returns the sales for the previous year in relation to current selection. Here, a variable vLastYear containing the relevant year is used in a dollar-sign expansion.
Regards,
Jagan.
Hi,
For example you create a variable as vMaxSales
You can use this variable in expressions as $(=vMaxSales) instead of Max(sales Order).Then the report will show the result based on the value that you providing to the variable in the input box.
Celambarasan