Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Live Chat, June 29th 10AM ET. Bring your Qik Sense Enterprise, Client Managed questions! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
demaina1995
Contributor III
Contributor III

Expression with calculated field

Hello,

I have the following table :

IDOld DateNew DateDifference
210/10/201810/10/20180
510/10/201815/10/2018-5

My "Difference field is defined thanks to the following expression :

=If(NetWorkDays([Old Date],[New Date])>0,

NetWorkDays([Old Date],[New Date])-1,

-NetWorkDays([New Date]],[Old Date)+1)

I would like to add a KPI showing the number of ID that have the "Difference" field different to 0.

I tried the following expression :

Count({< If(NetWorkDays([Old Total Date début],[New Total Date début])>0,

NetWorkDays([Old Total Date début],[New Total Date début])-1,

-NetWorkDays([New Total Date début],[Old Total Date début])+1)<>{0}>} MSN)


But it's not working, I'm not very familiar with Set modifiers.

Could I give a name to the expression in blue in order to use it again ? I created a custom measure but doesn't seem to work if I want to use the name of my measure.

Best regards,

Caroline

11 Replies
teiswamsler
Partner
Partner

Hi Caroline

No, just load new data and the table will recalculate.

/teis

Please closed the issues if above solves the problem.

shaileshs
Contributor
Contributor


Try replacing following in your expression :



<> 0"} 


With


= {"<>0"}




So it would look From:

+1) <> 0"}>} ID)

To

+1) ={"<>0"}>} ID)



NOTE: You would have reformat your expression to escape double quotes.


I had issue when used > sign with a number and only way to achieve that was to pass it with "equal to sign" and comparison condition(signs) as a part of the string.

Let us know if you still have issues with modified expression.

Thanks