topic Re: Setting decimal point in a script in QlikView

Setting decimal point in a script

Fri, 20 Dec 2013 14:41:01 GMT

Hi,

We currently have the following script on the popup up label on our map. Showing correct data however, it isnt restricting the decimal points. So for example is showing:

0.89463795

1 Bloggs Avenue

1.57683045

....

Can you advise how in the script you can get it to fix to 2 decimals points. Here is current script:

[Distance (miles)] &' '& [Address]&' '& [Distance (miles)2]&' '& [Distance (miles)3]&' '& [Distance (miles)4]&' '& [Distance (miles)5]&' '& [Distance (miles)6]&' '& [Distance (miles)7]

Cheers

Chris

Re: Setting decimal point in a script

swuehl — Fri, 20 Dec 2013 14:44:17 GMT

have you tried the num() function, like

num(Value, '#.00')

Re: Setting decimal point in a script

Fri, 20 Dec 2013 15:09:34 GMT

Hi,

No we havent. Can you advise how that would be written in the script?

Cheers

Chris

Re: Setting decimal point in a script

swuehl — Fri, 20 Dec 2013 15:50:06 GMT

num([Distance (miles)],'#.00') &' '& [Address]&' '& num([Distance (miles)2],'#.00')&' '& num([Distance (miles)3],'#.00')&' '& num([Distance (miles)4],'#.00') &' '& num([Distance (miles)5],'#.00')&' '& num([Distance (miles)6],'#.00') &' '& num([Distance (miles)7],'#.00')

Re: Setting decimal point in a script

Fri, 20 Dec 2013 16:13:11 GMT

Hi Chris,

Hope, you can effort this

Use Num (number, format),

For Ex,

Num (Entity,’###########,##’) .

Regards,

Raja.

Re: Setting decimal point in a script

Fri, 20 Dec 2013 16:18:24 GMT

Hi,

Thanks very much for this.

Lst question (and applies to all pop up boxes on maps) how do you put additonal text in them? So currently the pop up is as follows:

0.89

1 Bloggs Avenue

1.57

Love if we could get it to show as follows:

Location 1: 0.89 miles

1 Bloggs Avenue

Location 2: 1.57 miles

.....

Chris

Re: Setting decimal point in a script

swuehl — Fri, 20 Dec 2013 17:48:53 GMT

'Location 1: ' & num([Distance (miles)],'#.00') &' miles' &' '&

[Address]& ' ' &

'Location 2: ' & num([Distance (miles)2],'#.00') & ' miles' & ' ' &

'Location 3: ' & num([Distance (miles)3],'#.00') & ' miles' & ' ' &

'Location 4: ' & num([Distance (miles)4],'#.00') & ' miles' & ' ' &

'Location 5: ' & num([Distance (miles)5],'#.00') & ' miles' & ' ' &

'Location 6: ' & num([Distance (miles)6],'#.00') & ' miles' & ' ' &

'Location 7: ' & num([Distance (miles)7],'#.00') & ' miles'