topic Re: Logic Help.. in QlikView

Logic Help..

abhaysingh — Tue, 17 Nov 2015 11:50:57 GMT

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

maxgro — Tue, 17 Nov 2015 11:58:25 GMT

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

abhaysingh — Tue, 17 Nov 2015 12:14:59 GMT

thanks but not working

maxgro — Tue, 17 Nov 2015 12:17:49 GMT

could you post a small .qvw with your data?

Anonymous — Tue, 17 Nov 2015 12:19:55 GMT

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 — Tue, 17 Nov 2015 12:41:49 GMT

no these are values 20,21, etc

Mark_Little — Tue, 17 Nov 2015 13:05:33 GMT

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