If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
need your help to extract some data.
I have a table like this :
Now for example if the current time is from 9 to 10 it should only show that particular hour data not the other ones. then in the next run it should show next hour data on the dashboard.
Try like below
LOAD * INLINE [Hour, Sales8 to 9, 1009 to 10, 40010 to 11, 26711 to 12, 13512 to 13 , 15613 to 14, 789]Where Trim(SubField(Hour,' ', 1)) = Hour(Now());
Might be, it helps or give idea
View solution in original post
Hi @MayilVahanan ,
I just took yours and used it in a visual instead of in the load.
I use the same clause as MayilVahanan just in an if statement in a chart. Please see below screenshot: