I ask for help in working with variables. I loadvariables from an Excel file. For example, vFact and vPlan. After I begin to conduct mathematical operations on them, the result behaves quite s...
I'm trying to get a value from a cell in Excel that I calculate with a formula and then load the said value into a variable, to be used further down into the macro. I've tried with: set v...
Hi All, stalwar1 I have an excel with a field. Now in qlikview i want to load that field fromexcel and assign to a variable. Is it is possible? Thanks, Bharat
Hi, Is it possible to achieve the following: 1. Set a variable in the script 2. Define the variable as a value in Excel field 3. Load the field fromExcel and have the variable's v...
Hello Users, I am trying to set the variablefrom the excel table which is loaded. The value of the variable is set based on the condition that it should pick the value of 0.75 of the total rows....
Hi, how do I load a table from an Excel_file if I know the file_name, but not the sheet_name - it is usually "owssvr", but it might be "owssvr (1)" - I don't know the reason. I'm trying to keep t...
...s in an excel file, with these columns (see image attached): Variable Name, Store Number I know how to do this from a text file, but the idea is for users to go to the Excel File and change t...
Hi All We have an Excel with a seperate tab for all the KPI's with the expressions we use in the QV dashboard. I'm trying to create a loop so all variables will be automaticly be created. I...
...he value for each of these. I have attached the Excel spreadsheet that I have created, but it doesn't there yet... Could you please help? The variable vPeriod and vPriorPeriod is created in Q...
