topic Near Realtime Counter in QlikView

Near Realtime Counter

Tue, 13 Sep 2011 13:27:28 GMT

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.

Near Realtime Counter

Tue, 13 Sep 2011 14:15:37 GMT

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