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

    Near Realtime Counter

    Jason Westwood

      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

          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