Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can someone help me?
Im still new using qlik sense. I have a problem using variables / functions inside an expression. Whats wrong with this.
I have a variable vHour
HOUR(TIMESTAMP(NOW()))
running this return 0 value (current time im running this is at 12:50)
=Count({<DepartureTimeScheduleAddedHour={"<=$(=vHour)"}>}DepartureTimeScheduleAddedHour)
running this returns a value of 18
=Count({<DepartureTimeScheduleAddedHour={"12"}>}DepartureTimeScheduleAddedHour)
Can you guide me as to what im doing wrong
Thanks
Hey Can you try this
=Count({<DepartureTimeScheduleAddedHour={"<=$(vHour)"}>}DepartureTimeScheduleAddedHour).
also.. you can try
=Count({<DepartureTimeScheduleAddedHour={"=$(HOUR(TIMESTAMP(NOW())))"}>}DepartureTimeScheduleAddedHour)
May be this -
=Count({<DepartureTimeScheduleAddedHour={"<=$(vHour)"}>}DepartureTimeScheduleAddedHour)
Hey Can you try this
=Count({<DepartureTimeScheduleAddedHour={"<=$(vHour)"}>}DepartureTimeScheduleAddedHour).
also.. you can try
=Count({<DepartureTimeScheduleAddedHour={"=$(HOUR(TIMESTAMP(NOW())))"}>}DepartureTimeScheduleAddedHour)
What are the expected value ?
is your dimension DepartureTimeScheduleAddedHour having values as integers representing hours?
thanks..
thanks