1 Reply Latest reply: Sep 13, 2011 10:15 AM by Gilles Gerbouin RSS

    Near Realtime Counter

      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



          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 :

          =only({<$Table={'Counter_tabl'}>} $Rows)