Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an order table which includes three dimensions: industry, region, and product. In the Data Load Editor, I group the orders by these three dimensions and write a IF statements for customer OR conditions, which serve as labels. In the Qlik Sense front table, if I filter a single dimension, such as industry, can the labels change accordingly based on the selected industry orders?
If the three dimensions are set as variables and aggregated in the script, can the labels change accordingly with the front table filters?
Hi
Based on my understanding, if you are creating the combination of three field values, and based on any single field, you want to display the corresponding combination values?
if so, you can use Minstring() or Maxstring() function. Because, might be, one industry can have different products. In that case, Minstring / Maxstring can display any one combination values.
Hi, Here is my formula, how can I write Minstring / Maxstring? It seems like the following formula is not working properly.
SET vVariable1 = 'Industry';
SET vVariable2 = 'BU';
LIB CONNECT TO 'CH1_DI_SE';
PY_1:
LOAD $(vVariable1),
$(vVariable2),
"ECODE",
sum("ORVALUE") as "ORVALUE"
group by
"ECODE",
$(vVariable1),
$(vVariable2);
SQL SELECT
"FROZENDATE",
"AKZ",
"BU",
"BUSEGMENT",
"GCK",
Industry,
"ORVALUE",
"ORDERSOURCE",
"CONTROLLINGAREA",
"SELLINGPARTY",
"ORTYPE",
"CONTRACTNO",
"COMPANYNAMECN",
"COMPANYNAMEEN",
"COMPANYCNOC",
"COMPANYSAPNO",
"IFA",
"BUYERCN",
"BUYEREN",
"BUYERCNOC",
"BUYERSAPNO",
"VBEZ",
"SALESNAME",
"USERGID",
"EMAIL",
"SALESTYPE1",
"SALESTYPE2",
"SALESTERRITORY",
"SALESBRANCH",
"SALESOFFICE",
"SALESDEPARTMENT",
"SALESDISTRICT",
"SPOREFNO",
"SPRNO",
"ASSIGNVALID",
"ECODE",
"TOVALUE",
"OOHVALUE",
"VBEZFOCUSBRANCH",
"ASSIGNTYPE",
"ASSIGNSOURCECNOC"
FROM "CV_OI_SOLISTDETAILPY";
NoConcatenate
PY_2:
LOAD *,
if("ORVALUE">=0,'Y','N') as Label
resident PY_1;