Problem doing a function

enriquem — Fri, 16 Dec 2016 08:41:30 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: Problem doing a function

Gysbert_Wassenaar — Fri, 16 Dec 2016 09:02:01 GMT

Try this:

SET 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€')));

Re: Problem doing a function

enriquem — Fri, 16 Dec 2016 09:52:52 GMT

Thank you!! It's a good solutions and learn how to resolve it!!

topic Problem doing a function in QlikView

Problem doing a function

Re: Problem doing a function

Re: Problem doing a function