Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys,
i have one exp with the one field i.e.
CurrentTime_Date
i want to define a fromDate and ToDate in My Expression..i cant use Aggregation function since value contain Date and Time..
How can i define it in set Analysis..
{<FromDate = >FromDate and ToDate= < ToDate>} CurrentTime_Date
Please Suggest
Abhay
For your drilling & Trend you need to take Avg(Temp) & slight change which I have done.
PFA..and to represent better Hour value you can use Class Function in the drilling for SHour which would give you output like..
0-1, 1-2, 2-3, 3-4 instead of 0,1,2,3,4....
You can use this expression in drilling for SHour....
=SubField(Class(SHour,1),'<',1)&'-'&SubField(Class(SHour,1),'<',3)
Which would give you result like....10-11,11-12,12-13 etc
Replace Avg(Temp) with Min(Temp)......
Its working..
How to Do sorting in it??
0-1, 1-2, 2-3,3,3-4 and so on
Sorting Done In QlikSense