Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter Report Data

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.

6 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

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

Not applicable
Author

I created input box and assigned variable with max(sales order) value to it.

Now how do I use it in expression?

jagan
Luminary Alumni
Luminary Alumni

Hi,

Use this variable in the expressions which you used in the charts.

Regards,

Jagan.

Not applicable
Author

Can you send me sample expression syntax?

jagan
Luminary Alumni
Luminary Alumni

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.

CELAMBARASAN
Partner - Champion
Partner - Champion

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