topic Re: Num format in QlikView

Num format

souadouert — Mon, 12 Feb 2018 12:24:04 GMT

HELLO

I need to use the num function to format a number, but the number of digits

after the comma is dynamic according to a column

sunny_talwar — Mon, 12 Feb 2018 12:25:53 GMT

What do you mean? Would you be able to show an example?

prma7799 — Mon, 12 Feb 2018 12:28:12 GMT

Please share some sample

souadouert — Mon, 12 Feb 2018 12:33:29 GMT

YoussefBelloum — Mon, 12 Feb 2018 12:39:30 GMT

Hi,

try this:

if(NB=3, num(...,'FORMAT1'), if(NB=2, num(...,'FORMAT2'), num(...,'FORMAT3')

souadouert — Mon, 12 Feb 2018 12:44:44 GMT

Hello youssef , i need to test this format in load script

YoussefBelloum — Mon, 12 Feb 2018 12:54:35 GMT

yes you can do it like this on the script.

try it

YoussefBelloum — Mon, 12 Feb 2018 13:17:58 GMT

Sorry this method didn't works for me on the script, as soon as I found a solution I'll let you know

YoussefBelloum — Mon, 12 Feb 2018 13:26:23 GMT

Maybe this:

num(YOUR_COLUMN,if(match(NB,'3'),'FORMAT1',if(match(NB,'2'),'FORMAT2','FORMAT3'))) as ...

niccolo_chiodar — Mon, 12 Feb 2018 13:38:19 GMT

What about something like this?

The results might depend on what type of chart you're plannig to use the expression, works for me in a pivot table.

Num([CH] ,'#.##0,' & Repeat('0', [NB]))

MarcoWedel — Mon, 12 Feb 2018 21:12:05 GMT

Do you also want to round the number to the specified decimal places or just format (i.e. keep the underlying value unchanged)?