topic Re: Number format issue in QlikView

Number format issue

komminenianusha — Sat, 09 Feb 2019 08:55:50 GMT

Hi All,

How to show field values in % format.I have one field which contains values like 20%,45%,2,4,55% etc.. when i select number format as % in qliksense it shows like 20%,45%,200%,400%,55% but its wrong i want to display like 20%,45%,2%,4%,55% etc..

Please help me for getting this.

Thanks in advance.

Regards,

Anusha

Re: Number format issue

agni_gold — Sat, 09 Feb 2019 10:04:27 GMT

Divide these numbers by 100 first and then select % as number format.

Re: Number format issue

pradosh_thakur — Sat, 09 Feb 2019 12:17:50 GMT

purgechar(fieldname,'%')

This is delete all the percentage fromthe number .

You can use

purgechar(fieldname,'%')  /100

and use number format as %

Re: Number format issue

marksouzacosta — Sun, 10 Feb 2019 05:43:58 GMT

Hi Anusha,

You can use the code below as reference for your problem:

[TempOriginalValues]:
Load * Inline [
OriginalValue
20%
45%
2
4
55%
];

[Treatedvalues]:
Load
    [OriginalValue],
    Num(PurgeChar([OriginalValue],'%')/100,'#,##0%') AS [TreatedValue]
Resident
    [TempOriginalValues]
;

DROP TABLE [TempOriginalValues];

This will generate this result: