topic Re: Set format variable in QlikView

Set format variable

intervigilium — Wed, 25 Nov 2020 16:16:04 GMT

In the script i convert some strings to a number, where " . " is the decimalseperator.

That works fine.

If i want to calculate with it, it transforms back to " , " as decimalseperator. Tried anything without succes, should be simple i think

In script from string to number i used:

Num#(X_LL,'#.#', '.' , ',') as longitude,

Num#(Y_LL,'#.#', '.' , ',') as latitude

I works fine.

But after calculating the median it comes with an " , "

var_mid_lat=median(latitude);

If i add a textbox with the following code:

=num#((var_mid_lat), '#.##', '.' , ',')

It gives back the correct value.

How to combine both so the variable format is correct?

For example i would expect something like:

in the variable:

var_mid_lat = '=num#(median(latitude),'#.#' , '.' , ',' )';

But this is not working, wrong syntax

Re: Set format variable

Anil_Babu_Samineni — Fri, 17 Mar 2017 02:45:22 GMT

May be doing Replace

LET var_mid_lat = num#(Replace(median(latitude),'.' , ',' ),'#.#');

Re: Set format variable

vishsaggi — Fri, 17 Mar 2017 03:11:00 GMT

In your main script near environment set variables change this like below: And run your script again

ThousandSep as Comma and DecimalSep as Dot. .

SET ThousandSep=',';

SET DecimalSep='.';

Re: Set format variable

intervigilium — Fri, 17 Mar 2017 07:16:20 GMT

Hi Anil and Vishwarath,

Thanks for your help!

The answer of Vishwarath did solve the problem. The syntax of your solution Anil gives an error (dont know why). Next time i will add the excel, so you can reload the script.

THanks again for all your help!!