topic Re: Linear guage Max value in QlikView

Linear guage Max value

Thu, 10 Oct 2013 15:52:16 GMT

Hi again

This is baffling me. I have this SUM formula that works in my model:

sum({<Group = {'$(=Concat(if(aggr(rank(sum([PO count])),Group)=1,Group,null()), chr(39) & ',' & chr(39)))'} >} [PO count]) * 1.02

However, the COUNT equivalent is giving me problems.

I have created a small demo (attached) to show you more detail.

Any help is as usual very appreciated.

Oli

Clever_Anjos — Thu, 10 Oct 2013 16:17:03 GMT

you need an extra ')'

=count(

{<Type={'$(=concat(if(aggr(rank(count(distinct Supplier)), Type)=1,Type,null())))'}

distinct Supplier) * 1.02

Fri, 11 Oct 2013 08:44:58 GMT

Thank you