Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
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.
hi,
in the script, after loading your orders, add this
Counter_tabl:
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 :
=only({<$Table={'Counter_tabl'}>} $Rows)
Regards
Gilles