im trying to do a real time counter on qlikview what i need is for my orders to be counted by Today only and the figure updates everytime the document reloads which is every 5 mins
what is the best way of doing this i have tried using the Today() function and doing a count on my orders but this doesnt appear to be picking up any figures.
in the script, after loading your orders, add this
load recno() as counter resident orders where date >= Today()
be careful in the date format between date and Today()
I assume orders in the name of the table with orders
then add a textbox with this expression :