topic Re: Replace . instead of , in QlikView

Replace . instead of ,

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

Hello,

I tried this, Why this is not allowing

Sales

1,34

2,34

avg(Replace(Replace('Sales',','),'.') Sales)

Expected O/P is

Sales

1.34

2.34

Re: Replace . instead of ,

migueldelval — Thu, 28 Jul 2016 11:39:18 GMT

Hi Anil,

Could you post your answer, to help other people?

Regards

Miguel del Valle

Re: Replace . instead of ,

robert_mika — Thu, 28 Jul 2016 11:40:40 GMT

Is this front or back end?

Is Sales entry per each row or is this a field name?

Re: Replace . instead of ,

Anil_Babu_Samineni — Thu, 28 Jul 2016 11:43:39 GMT

Front End only, But i don't want to change use subfield from Scripting.

I am trying to create Pivot table. In that Pivot measure i need to use . instead of ,

Re: Replace . instead of ,

robert_mika — Thu, 28 Jul 2016 12:55:19 GMT

Could you post your data please?

Screenshot maybe?

Re: Replace . instead of ,

Anil_Babu_Samineni — Thu, 28 Jul 2016 13:05:49 GMT

PFA.

I mention Expected O/P Also

Re: Replace . instead of ,

adamdavi3s — Thu, 28 Jul 2016 13:07:50 GMT

Does your data field 'Sales' actually have a , in it or is this just the way the number is being displayed?

Check your decimal separator in the default block of the load script

Re: Replace . instead of ,

MindaugasBacius — Thu, 28 Jul 2016 13:09:09 GMT

replace(Text(Sales), ',', '.')

But you will get not number but text instead.

Re: Replace . instead of ,

Anil_Babu_Samineni — Thu, 28 Jul 2016 13:09:28 GMT

Adam, Check the Attachment

Re: Replace . instead of ,

Anil_Babu_Samineni — Thu, 28 Jul 2016 13:10:11 GMT

I want to calculate Average with That?

Re: Replace . instead of ,

Thu, 28 Jul 2016 13:12:42 GMT

Hi Anil,

Please try below in your load statement,

Replace(Sales, ',', '.') as Sales

Thanks,

Narsi

Re: Replace . instead of ,

adamdavi3s — Thu, 28 Jul 2016 13:15:08 GMT

Your formula is just slightly out, please see attached.

avg(replace(Sales,',','.'))

Adam

Re: Replace . instead of ,

Anil_Babu_Samineni — Thu, 28 Jul 2016 13:29:55 GMT

My Expression is Working, Properly.

avg(Replace(Replace('Sales',','),'.') Sales) - ' Error

Unfortunately, I didn't test the formula @ Text Object. Thanks Guys...!

Re: Replace . instead of ,

robert_mika — Thu, 28 Jul 2016 13:50:20 GMT

Or like this:(I added some extra line in the inline-table)

Re: Replace . instead of ,

Anil_Babu_Samineni — Thu, 28 Jul 2016 14:16:32 GMT

Still Didn't get Proper Values(Null Values) Only

PFA

Re: Replace . instead of ,

robert_mika — Thu, 28 Jul 2016 14:35:54 GMT

That's different data set....

What is in AVGFurn....?

Re: Replace . instead of ,

Anil_Babu_Samineni — Thu, 28 Jul 2016 15:43:49 GMT

Robert, Client Don't want to show the Average. Because, That is Pivot Table That is why don't Require. Meantime, I show that Average in Text object. But, Client Want Normal Text with Decimal values. Can you please help me for that.

I Apologize for previous conversation. After that Client send me the mail

Re: Replace . instead of ,

adamdavi3s — Fri, 29 Jul 2016 06:19:30 GMT

I am very confused about what your actual issue is.

Have you looked at the file I uploaded? This shows the strings in the load, as decimal numbers in the table, I've just tested with your 0,19 etc and this works fine.

However, in your screenshot above, the other numbers are showing with , as the decimal separator, (e.g. hangtime shows 0,07) and assuming you haven't altered your listbox that thinks the AVGFurn is a numeric as well.

As I previously suggested, check the start of your load script to see what your decimal separator is set to.

Or are you trying to mix formats within a table? e.e hangtime = 0,07 and AVGFurn = 0.07

Can you upload an example of your data with the actual issue explained?

Re: Replace . instead of ,

Anil_Babu_Samineni — Fri, 29 Jul 2016 06:55:31 GMT

In that Application it is working, But my application see this

Re: Replace . instead of ,

adamdavi3s — Fri, 29 Jul 2016 06:59:56 GMT

Hi,

Yes I have seen your screenshot hence my follow up questions above.

Have you checked your decimal format?