Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
My table is created as:
LOAD
"Year",
"Month",
"id",
,"quantity"
FROM [lib://Folder For QS_DATA_RU/data.QVD]
(qvd)
where Match([Year],$(vYear)) and Match([Month],$(vMonth)) and Match([id],$(v_id))
;
(vYear),(vMonth),(v_id) are variables that user enters in variable input in Sheet
It works correctly if all fields are filled in, but I face with a problem when one of fields is empty.
If it is empty, it means table must include all (*) values by field but it doesn't filter with clause where.
Any ideas?
Thank you
can u try something like...
if(len($vyear)<0 or len($vmonth)<0 then
LOAD
"Year",
"Month",
"id",
,"quantity"
FROM [lib://Folder For QS_DATA_RU/data.QVD]
(qvd);
else
LOAD
"Year",
"Month",
"id",
,"quantity"
FROM [lib://Folder For QS_DATA_RU/data.QVD]
(qvd)
where Match([Year],$(vYear)) and Match([Month],$(vMonth)) and Match([id],$(v_id))
;
Instead of using multiple conditionally controlled load-statements you may also use queries within the where-clause, like:
where wildmatch([Year],$(vYear), '*') and ....;
Depending on if the values are numbers or strings and if the users could apply single-values or multiple ones and which char might be used as the delimiter and/or if they could enter any invalid stuff you may need some more and advanced logic to catch each possible scenario.
I don't know which variable-features are currently supported in Sense but in View you could restrict the possible values only to valid ones, for example by providing pre-calculated values from which the user choose per scroll or per drop-down. Often is this pre-defining much easier as handling all possible cases afterwards.
- Marcus