Sub function

enriquem — Thu, 15 Dec 2016 16:22:28 GMT

Hi All!!

I'm trying to do a function like i show, but i can't get the result that i hope.

The function it's transformating the value of the parameter to a format value even Milllion, thousands....

Here I put some examples to do this with a function:

SUB formatNum (Value)

IF Value<num(100000) THEN

Value = Num(Value,'#.##0 €;-#.##0 €')

ELSEIF Value<num(1000000)

Value = Num(Value/num(1000),'#.##0,0 k€;-#.##0,0 k€')

ELSE

Value = Num(Value/num(1000000),'#.##0,00 M€;-#.##0,00 M€')

ENDIF

ENDSUB

OR with a Calculated Variable:

LET suma= 'IF($1<num(99999), Num($1,"#.##0 €;-#.##0 €"), IF($1<num(1000000), Num($1/num(1000),"#.##0,0 k€;-#.##0,0 k€"), Num($1/num(1000000),"#.##0,00 M€;-#.##0,00 M€")))';

The code its rigth, but i can't call the sub function from an text object, and i can't get the correct result with the calculatedValue because I dont escape the simple comma char.

Note: to call the calculated variable use:

=$(suma(3131231211231223))

Thanks All and Regards.

Re: Sub function

MK_QSL — Thu, 15 Dec 2016 18:01:28 GMT

Don't know whether this will help or not but you can also use below for formatting your numbers.

Scaling Numbers and DSE Tips | Qlikview Cookbook

topic Re: Sub function in QlikView

Sub function

Re: Sub function