Is Qlikview can read value from a excel for calulations?
I have requirement to read values from a excel file(value in excel is a Flag value) into a variable to use in my calculations(without reload).
Here is my Orginal requirement:
In a TV Monitor we are showing daily sales progress chart..That chart has to switch different products like: TotalSales==>ProductA==>ProductB==>Product3==>TotalSales ..in this order cycle for every 1 minute automatically.
For this requirement I have used now function to switch the products .. However, this now() is not working to rotate automatically in access point??(unless we keep the session interactive or using the auto refresh web page plug-in)..Also now() is consuming 100% CPU..
Now I have thinking of alternatives..
To change value in my variable for every 1 minute..so that I use that value in chart..Is this possible to change value using Macro? (Pls share some sample macro that can change value of my variable every 1 minute)
if not , is it possible to read a value from excel file into variable ?(so that I will change the value in excel file using some external program )
Please share your thoughts. Thank you so much in advance.