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...
...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...
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 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...
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...
Hi,
In my qliksense dashboard I have declared vCity variable like the syntax below and it perfectly works fine
vCity = IF($(vCountry)=0,'CityFlag={1}','CityFlag={2}')
Now I want to read this variable...
Hello,
I have several excel files which needs to be loaded. Each of the files starts with one of the following prefixes: AMS, BFS, MIL. ie: AMS_New23, BFS_01/01/25 etc. Sometimes one of the files w...
I am trying to read a list of values from an excel sheet where the name of the variable is in column A and the value of the variable is column B
Name
Value
ListA
['abc','def','g...
