Discussion board where members can get started with Qlik Sense.
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
Go to Solution.
can you explain with sample data??
Replace(Trim(Replace(fieldName,'0',' '),' ','0') as newFieldName
Maybe this: If(Einstandspreis>0, YourExpression) as Einstandspreis
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:
if (num# (Einstandspreis, '#.#', '.', ',')>0,num# (Einstandspreis, '#.#', '.', ','),null() as Einstandspreis
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.
i am using this expression:
and i want to replce zero-values with 'no value' and this is my problem
can you explain with sample data???