topic Filter values from INLINE starting with certain numbers in QlikView

Filter values from INLINE starting with certain numbers

microwin88x — Fri, 27 Mar 2015 15:00:47 GMT

Hello,

I have my Script with an INLINE table for field ID with values:

000

005

020

035

Then I have my Fact Table with the ID and other fields.

The thing is that I need to get the IDs STARTING with the values from INLINE.

For example, IDs: 000835, 005358, etcetera.

Is there any way to do this in the WHERE clause from the Fact Table?

(If I make a Where Exists(ID) in the Fact Table, I'd only get values 000, 005, 020 and 035)

Thank you!

MK_QSL — Fri, 27 Mar 2015 15:07:02 GMT

Temp:

Load Num#(ID,'000') as ID INLINE

[

000

005

020

035

];

Sales:

Load

CustomerID,

Sales

Where Exists (ID, ID1);

Load

Num#(CustomerID,'000000') as CustomerID,

Num#(Left(Num#(CustomerID,'000000'),3),'000') as ID1,

Sales

Inline

[

CustomerID, Sales

000835, 100

000122, 120

005140, 200

001256, 100

];