topic Re: variable in text box in QlikView

variable in text box

Mon, 19 Nov 2012 11:06:37 GMT

Hi All,

I have a variable that works out an average for me, i am using this in a straight table with a product dimension then i have the totals summed up giving me a total of all the averages. (Top table below)

Does anyone know how i can use the variable in a text box but displaying the total instead

this is my variable

$(vTargetAvg_Listings)

avg({$<

[it_target_type]={"Listings"},

[ld_Dist]={"4"},

[ld_Outlet_Check_Date]={">=$(=Timestamp(FirstDayCurrentFiscalYear))"}

>}

[it_target_value]

)

Re: variable in text box

swuehl — Mon, 19 Nov 2012 11:23:11 GMT

You'll probably need to use advanced aggregation, i.e. the aggr() function, maybe like this:

=sum(

aggr(

avg({$<
[it_target_type]={"Listings"},
[ld_Dist]={"4"},
[ld_Outlet_Check_Date]={">=$(=Timestamp(FirstDayCurrentFiscalYear))"}
>}
[it_target_value]
)

,Brand )

)

Re: variable in text box

Mon, 19 Nov 2012 11:32:13 GMT

Great, thanks for the answer