topic Re: Take decimals out of a table in App Development

Take decimals out of a table

Manuel174102 — Fri, 12 Aug 2022 12:33:46 GMT

Hello everyone.

My source table (The table I upload in the data manager), which I cannot modify (It is not an excel), has values like this:

34,0000000000000000

So when I make a table in my sheet, and I add the values, they seem huge, but in reaity that is just a 34.

How could I change that? I want it to be display just like "0"

Should I make a change in the datamanager or in the table in my sheet?

Greetings

Re: Take decimals out of a table

Digvijay_Singh — Fri, 12 Aug 2022 12:44:44 GMT

I think you should be able to format the field in the data manager or in the chart expression. I just tried this below sample like this. I don't use data manager that often, I am a script editor fan 🙂

Test:
Load * inline [
Value
'34,000000000'
'35,000000000'
'36,000000000'
'37,000000000'
'38,000000000'
]

Re: Take decimals out of a table

Manuel174102 — Fri, 12 Aug 2022 12:53:40 GMT

Thanks!

And what if I have a 3,7500000? How do I change it so I have only 3,75?

Or a date that is represented like 24.06.2014 00:00:00, if I only want 24.06.2017?

Re: Take decimals out of a table

Digvijay_Singh — Fri, 12 Aug 2022 13:05:51 GMT

Do you have timestamp, decimal values all mixed together in the same field? How is that field being used? as a Date or a number? Based on different value types you need to frame your logic and it wouldn't be easy to identify without knowing how many different formats you got. If you share sample data, may be someone will be able to give you a logic that can fit your needs.

Re: Take decimals out of a table

Manuel174102 — Fri, 12 Aug 2022 13:15:25 GMT

Ok, I have something like this

Number	Date
3,75000000	11.01.2021 00:00
10,00000000	17.09.2022 00:00

And I want it to look like this

Number	Date
3,75	11.01.2021
10,00	17.09.2022

Thanks for answering!

Re: Take decimals out of a table

Manuel174102 — Fri, 12 Aug 2022 13:18:15 GMT

i found the solution to the date problem, but to the number i did not 😞

Re: Take decimals out of a table

Digvijay_Singh — Fri, 12 Aug 2022 13:47:00 GMT

Try something like this may be , Normally in this situation we use num# to interpret the text, as per my test this works but not sure if your locale format is same as mine for decimal, thousand etc -

=num(Subfield(Value,',',1) &'.' & subfield(Value,',',2),'#.##','.')

Re: Take decimals out of a table

Digvijay_Singh — Fri, 12 Aug 2022 13:48:14 GMT

Some ideas in this link as well -

https://community.qlik.com/t5/New-to-Qlik-Sense/Convert-Text-to-Number/td-p/1601959

Re: Take decimals out of a table

Manuel174102 — Fri, 12 Aug 2022 14:00:57 GMT

It is still not working for me, when I write that all i get is - .

But I really appreciate u helping me out

Re: Take decimals out of a table

Digvijay_Singh — Fri, 12 Aug 2022 14:03:14 GMT

If possible can you share a sample app, I am sure someone will figure out the solution for you..