topic Text in chart, num() not working in QlikView

Text in chart, num() not working

Michiel_QV_Fan — Wed, 08 Sep 2010 10:43:28 GMT

Hi,

I have this expression as text in chart:

= 'Value: '&

((1 -round

(sum({$<Year_A= {"<=$(=Year-1)"},Year_B= {">=$(=Year-1)"} , Waiting_days = {"< 366"} >}Waiting_days

) /

sum({$<Year_A= {"<=$(=Year)"},Year_B= {">=$(=Year)"}, Wainting_days = {"< 366"} >}Waiting_days), 0.01))*100)

I want to have a % format and added num (expression), '###.#%') but this results in nothing.

I don't know why.

All help is appreciated.

Text in chart, num() not working

Miguel_Angel_Baeyens — Wed, 08 Sep 2010 11:13:44 GMT

Hello Michiel,

Make sure your format options follows your DecimalSep and ThousandSep variables at the top of your main script tab. Num syntax is

Num(expression, '#.##0,00 %')

in my case, using "." for thousands and "," for decimals. Check for missing brackets.

Regards.

Text in chart, num() not working

Michiel_QV_Fan — Wed, 08 Sep 2010 11:26:08 GMT

Tnx Miguel,

I found the solution. The first comma in the script messed the expression because the num expected this comma. I removed the round function and added the num(). Now I have the desired output.

Thanks

Michiel