Qlik sense formatted percentage shows as decimal number in front end

[fionna51]

Hi guys,

I use something like num(round([# Rate], 0.01), '##0%') as [# Rate] in load script to get rate as percentage. And after I reloaded in Qlik sense app front end,  it shows as 0.81. But I load that qvd by QV qvw, I can see 81%. I tried all format options in QS, all not working.  I don't want to handle the rate format in front end, any suggestions?

Thanks in advance.

Fion

[Gysbert_Wassenaar]

Apply the format in the load script when you load the data from the QVD.