Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

beck110979
Valued Contributor III

zero value

Hi Folks

i have a question, i am using this expression:

num# (Einstandspreis, '#.#', '.', ',') as Einstandspreis

i have some ZeroValue, but i am not able to convert these zero values into 'no values'

does anybody have any idea how to resolve this issue

Thanks a lot

Beck

1 Solution

Accepted Solutions
big_dreams
Contributor III

Re: zero value

can you explain with sample data??

try like

Replace(Trim(Replace(fieldName,'0',' '),' ','0') as newFieldName

Regards,

5 Replies
big_dreams
Contributor III

Re: zero value

can you explain with sample data??

try like

Replace(Trim(Replace(fieldName,'0',' '),' ','0') as newFieldName

Regards,

Ivan_Bozov
Valued Contributor

Re: zero value

Maybe this: If(Einstandspreis>0, YourExpression) as Einstandspreis

felipedl
Valued Contributor III

Re: zero value

Hi Beck,

Not quite sure I understood, but you want to have null values when the value of your Einstandspreis is zero?

If so, you can use a conditional on your load statement, like this:

Table:

Load

     if (num# (Einstandspreis, '#.#', '.', ',')>0,num# (Einstandspreis, '#.#', '.', ','),null() as Einstandspreis

From [Whatever];


If your number interpretation is greate than zero, it will input null as "value".

If I misunderstood your problem, please add more to it and i'll try to help.


Felipe.

beck110979
Valued Contributor III

Re: zero value

Hi Felip,

i am using this expression:

num# (Einstandspreis, '#.#', '.', ',') as Einstandspreis

and i want to replce zero-values with 'no value' and this is my problem

big_dreams
Contributor III

Re: zero value

can you explain with sample data???

Regards,

Community Browser