topic where clause in expressions in QlikView

where clause in expressions

Wed, 06 May 2015 11:39:22 GMT

Hi Experts,

I have a requirement in my project where an user enters the min and max limit of a column(through input box).

I am saving these in variables ...var1 & var2.

I need to show the value of Avg(column1) where value of column1 > $(var1) and < $(var2) in a textbox.

I am not able to create this successfully.

Any help would be much appreciated.

Thanks in advance.

rubenmarin — Wed, 06 May 2015 11:51:47 GMT

Hi Nayana, supossing you have a table with a dimension 'Dim' and value 'Data' you can use this expression in table:

If(Sum(Data)>=$(var1) and Sum(Data)<=$(var2), Sum(Data))

For the average check the total type as 'average'

In a text box you can show the Avg() with this expression:

=Avg(Aggr(If(Sum(Data)>=$(var1) and Sum(Data)<=$(var2), Sum(Data)), Dim))