Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
abhaysingh
Specialist II
Specialist II

Logic Help..

Hi All,

i have one table in which Temperature,minimum and maximum temperature is available against assets,,

i want in text object that when Asset Temperature is in range it will give count of Day.

i.e. Number of Days assets works properly.

if a Asset Temperature is in Range of Min and Max Temperature than it is gud and i want to calculate no of Days for Assets is gud..

Pls suggest

6 Replies
maxgro
MVP
MVP

sum( {$<AssetTemperature = {“>MInTemp<MaxTemp”}>} distinct Days )

abhaysingh
Specialist II
Specialist II
Author

thanks but not working

maxgro
MVP
MVP

could you post a small .qvw with your data?

Anonymous
Not applicable

may be Temprature format is the issue?

How you are storing Temprature and Min/Max values? may be like 23 C??

Try to convert it into Num()

abhaysingh
Specialist II
Specialist II
Author

no these are values 20,21, etc

Mark_Little
Luminary
Luminary

Hi,

have you thought about adding a flag in the data?

Something Like

If(Temp>= Min and Temp<=Max, 1,0) as InRange,

Then you can then just Sum(InRange)?

Mark