Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to create a column which can then be used as an expression in a table. Below is what I would like but I am not sure how this is written.
Data Load Editor
LOAD
orderid,
type,
IF(type= Match(type,'ZBC','XQC','XQH'),1,0) as TypeFlag
FROM [lib://L1-Tracking.qvd]
(qvd);
Table
Sum({<TypeFlag= {1}>}TypeFlag)
This will then filter my table for only the above-listed types.
Thank you in advance.
Hi Raman,
Try this:
Data Load Editor
LOAD
orderid,
type,
IF(Match(type,'ZBC','XQC','XQH')>0,1,0) as TypeFlag
FROM [lib://L1-Tracking.qvd]
(qvd);
G.
Hello Raman,
Your syntax for Match() in the data load editor is not appropriate.
US/qlikview/November2017/Subsystems/Client/Content/Scripting/ConditionalFunctions/match.htm
Try
IF( Match(type,'ZBC','XQC','XQH'),1,0) as TypeFlag
Hi Vamsee,
Thank this identifies the type correctly.
How would the expression in the table look? I tried Sum({<type= {1}>}type) but this does not work.
thanks
Hi Vamsee,
I tried this but does not exclude rows that do not equal 1, it just sets them with a '-'.
If want to flag it with chart editor then use the expression you would use in load editor:
IF(Match(type,'ZBC','XQC','XQH')>0,1,0)