Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

beck110979
Valued Contributor III

Numberformat problem

Hi Folks,

i have a situation,

my textbox with numbers does look like (see attached screenshot)

if i open my app in desktop: my numbers do look like: 166,5M (with comma)

but if i open my app in server: my number do look like : 166.5M (without comma)


i know this is a format problem.


what is the best way to resolve it?



Thanks a lot

Beck

7 Replies
MVP
MVP

Re: Numberformat problem

What is the expression you have used for this particular KPI?

beck110979
Valued Contributor III

Re: Numberformat problem

Hi Sunny,

my expression does look like:

Sum({<DatenTyp={'Personalkosten','Reisekosten'}>}Anzahl)

Thanks a lot for your help und time

Beck

kkkumar82
Valued Contributor III

Re: Numberformat problem

Why don't you format yourself using Num(Sum({<DatenTyp={'Personalkosten','Reisekosten'}>}Anzahl), '$#,##0.00')


for eg like above

beck110979
Valued Contributor III

Re: Numberformat problem

Hi Kiran,

first of all, thanks a lot for taking the time to help me,

to situation: i tried and i uses this expression: {'Personalkosten','Reisekosten'}>}Anzahl), '$#,##0.00')

but nothing has changed i still have the same problem.

Thanks a lot

Beck



kkkumar82
Valued Contributor III

Re: Numberformat problem

How are you checking your file into Server , once check this variable in edit script in your server file and desktop file

SET DecimalSep='.';

beck110979
Valued Contributor III

Re: Numberformat problem

Hi Kiran,

what do you meean with: SET DecimalSep = ' ';

if you see my attached example, some textobjects show me my numbers with correct format, although i use the same way of creating of variable, i understand that server do not recognize my numbers in correct format.

Do you have an example?

thanks a lot

kkkumar82
Valued Contributor III

Re: Numberformat problem

it is a system variable which you can see in the data load editor of your app,.community1.png