topic Remove wrong legend in QlikView

Remove wrong legend

Anonymous — Mon, 16 Dec 2013 16:12:08 GMT

Hi community,

I have dimension

=MYear&' (n='&aggr(Count([qID_10395_Purpose of visit MARKETING]),MYear)&')'

and in result

How can I remove (n=1)?

It works where I use only MYear without aggregation.

Thanks,

swuehl — Mon, 16 Dec 2013 16:14:23 GMT

Maybe like

=MYear& if(MYear,' (n='&aggr(Count([qID_10395_Purpose of visit MARKETING]),MYear)&')')

Anonymous — Mon, 16 Dec 2013 16:18:48 GMT

Thank you!!!!!