topic Decimal Places in Chart Labels in QlikView

Decimal Places in Chart Labels

Wed, 25 May 2011 10:51:20 GMT

Hello!

Just getting into using Qlikview and have hit a funny hurdle.

Have created charts that display summed values in the labels but cannot get them to adhere to decimel places or seperators.

An example is;

='Value : £'&sum(if(wildmatch(product_range_desc,'*Fleet*'),dt_qty*dt_net_price,0))

What am i missing?

Can anyone assist?

Thanks

Decimal Places in Chart Labels

Wed, 25 May 2011 11:16:02 GMT

Hi,

Maybe this would work:

='Value : £'& Num(sum(if(wildmatch(product_range_desc,'*Fleet*'),dt_qty*dt_net_price,0)),#.##0)

Decimal Places in Chart Labels

Thu, 26 May 2011 15:24:08 GMT

thanks for your response.

It hasn't solved my issue. when i attempt to use the amended code it starts highlighting a numsum function along with claiming that the format information at the end is a bad field name(s).

Can you or anyone assist further?

Is there another approach we could take over using the num feature to achieve the formatting we're after?

Thanks

Decimal Places in Chart Labels

Thu, 26 May 2011 15:40:31 GMT

There are a couple of ' missing at end of the expresion, where the number format. It should be:

='Value : £'& Num(sum(if(wildmatch(product_range_desc,'*Fleet*'),dt_qty*dt_net_price,0)),'#.##0')