I have one excel with this column how to loadexcelvariable to Qliksense variable dummy excal
vBudget
sum({<year = {$(=max(Year))},ReportingMonth={$(=num(month(MonthEnd(max({<F...
Hi, I'm trying to load 2 variables from an Excel file, and use the first one in the set analysis of the second one. Here are the variables:
vDateRange
if(vSwitch=1, '>='&m...
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...
...ditor which Excel table to load, but somehow, the variable containing the sheet name is not being evaluated properly. My code (based on a thousand forum answers) is the f...
...elow variable with actual folder path */
LET vExcelFilePath = '..\Files'; // Root folder path on which all the excel files are stored. It might contain sub folders as well.
LET vFileExtension = 'x...
Hello guys, I have a lot of automatic exports of data in excel. My problem is that not all excel files have the same columns and I don't know how to load them all in an unique load script. Here I...
Hi,
I am trying to create variables using the values in an excel file:
Table: LOAD "Variable Name", "Variable Value", "Variable Definition" FROM my_excel_file.xlsx;
let v...
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. I have this section of code
[Inbound]: LOAD INVOICENO, TRANSDATE, TRANSTYPEID, WHSCODE, left(SENDER,6) as 'CUSTID', CHARGETYPE, CHARGEDESC, CHARGEQTY, "RATE", CHARGE FROM [l...
I would like to not only loadvariables via an excel file, but also add tags and descriptions
How should we specify the load expression
Variables_Labels:
// Load...
