topic Aggregate using a Variable in QlikView

Aggregate using a Variable

Anonymous — Mon, 22 Sep 2014 13:25:39 GMT

I have defined a variable $(vPlace) that can either be 0 or 1. I want to try and find the max value of "rating" if $(vPlace) equals 1 but with my current attempt the result returned is null

My expression is: =aggr(max(rating),($(vPlace)='1'))

I'm struggling to find the correct syntax to make this work - any help appreciated.

Thanks

Matt

Re: Aggregate using a Variable

JonnyPoole — Mon, 22 Sep 2014 13:27:48 GMT

if( $(vPlace) = 1 , max(rating) ) -> will calculate the max rating if your variable is 1.

Is place a field in your data model and you want to calculate the maximum rating when place = 1 ?

something like this

max ( {$<Place = {'$(vPlace)'}>} Rating )

Re: Aggregate using a Variable

anbu1984 — Mon, 22 Sep 2014 13:30:34 GMT

=Max(If($(vPlace)='1',rating))

Re: Aggregate using a Variable

Anonymous — Mon, 22 Sep 2014 13:47:16 GMT

Thanks Anbu. Seems I didn't need to use aggr after all.