topic Filter Report Data in QlikView

Filter Report Data

Fri, 03 Feb 2012 05:23:01 GMT

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.

Filter Report Data

CELAMBARASAN — Fri, 03 Feb 2012 06:07:21 GMT

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

Filter Report Data

Fri, 03 Feb 2012 07:11:29 GMT

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

Now how do I use it in expression?

Filter Report Data

jagan — Fri, 03 Feb 2012 07:19:43 GMT

Hi,

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

Regards,

Jagan.

Filter Report Data

Fri, 03 Feb 2012 07:38:22 GMT

Can you send me sample expression syntax?

Filter Report Data

jagan — Fri, 03 Feb 2012 07:42:20 GMT

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.

Filter Report Data

CELAMBARASAN — Fri, 03 Feb 2012 11:52:03 GMT

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