Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
You can use the code below as reference for your problem:
Load * Inline [
Num(PurgeChar([OriginalValue],'%')/100,'#,##0%') AS [TreatedValue]
DROP TABLE [TempOriginalValues];
This will generate this result:
purgechar(fieldname,'%') This is delete all the percentage fromthe number .You can use
and use number format as %