topic Re: *-value in QlikView

*-value

bobbydave — Thu, 22 Jan 2015 09:25:12 GMT

= aggr(if(rank(avg([Metric Value]))<=6,Grouping),Year,[Cost Center])

I am creating a ranking system and the above equation resolves this.

However, there is one value in Grouping that I do not want in the equation called 'Cost'

= aggr(if(rank(avg([Metric Value]))<=6,Grouping='*@-'Cost'),Year,[Cost Center])

Obviously the 2nd equation is incorrect.

Anyone know how i would rewrite this to allow for Grouping to remove 'Cost'?

Thanks

alexandros17 — Thu, 22 Jan 2015 09:31:07 GMT

Try with

aggr(if(rank(avg([Metric Value]))<=6,If(Grouping<>'Cost', Grouping, Null())),Year,[Cost Center])

Gysbert_Wassenaar — Thu, 22 Jan 2015 09:33:21 GMT

= aggr(if(rank(avg([Metric Value]))<=6 and Grouping <> 'Cost',Grouping),Year,[Cost Center])

bobbydave — Thu, 22 Jan 2015 09:39:49 GMT

Thanks guys

bobbydave — Thu, 22 Jan 2015 09:39:57 GMT

Thanks guys