Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Michiel_QV_Fan
Specialist
Specialist

Text in chart, num() not working

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.



1 Solution

Accepted Solutions
Michiel_QV_Fan
Specialist
Specialist
Author

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

View solution in original post

2 Replies
Miguel_Angel_Baeyens

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.

Michiel_QV_Fan
Specialist
Specialist
Author

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