topic Re: Create a key for certain entries in QlikView

Create a key for certain entries

Tue, 24 Feb 2015 10:14:27 GMT

Hello,

how do I create an key for the orders that contains a line that ends with 300.

I would like to be able to show all order lines from the order number that

contains 300, see order file below.

Håkan

0364227481000100
0364227481000105
0364227481000110
0364227481000200
0364227481000205
0364227481000210
0364227481000300
0364655361000100
0364655361000105
0364655361000200
0364655361000205
0364655421000100
0364655421000105
0364655421000200
0364655421000205

Re: Create a key for certain entries

Tue, 24 Feb 2015 10:21:26 GMT

Hi,

Load * from Table where field='*300';

Regards,

Joshmi

Re: Create a key for certain entries

Tue, 24 Feb 2015 10:21:38 GMT

You can Use like below in the script:

if(WildMatch(Order,'*300'),Order) as Order300

P.S:

LOAD Order,if(WildMatch(Order,'*300'),Order) as Order300 INLINE [

Order

0364227481000100

0364227481000105

0364227481000110

0364227481000200

0364227481000205

0364227481000210

0364227481000300

0364655361000100

0364655361000105

0364655361000200

0364655361000205

0364655421000100

0364655421000105

0364655421000200

0364655421000205];

Thanks,

Singh

Re: Create a key for certain entries

awhitfield — Tue, 24 Feb 2015 10:39:24 GMT

Hi Hakan,

try something like this:

if(Right(OrderNo,3)='300',1,0) AS Order_Flag

Andy