Solved: Re: How to remove those - Qlik Community

kulasekhar · ‎2015-04-17

Hi All,

Load the following data into qlikview:

LOAD * INLINE [
F1
0570035
0530065
0550099
0560016
0510015
0570010
0520040
0580002
];

Need to filter the data where the values contain the third digit ‘7’ marked in data above.

So output should be :

F1

---------------
0530065
0550099
0560016
0510015
0520040
0580002

Thanks,

sekhar

Marcellino_Groothof · ‎2015-04-17

Hi,

Try this:

temp:

Load * INLINE

[F1,
0570035,
0530065,
0550099,
0560016,
0510015,
0570010,
0520040,
0580002
];

Tabel:
LOAD * where Mid(dummy, 3, 1) <> '7';
LOAD F1 as dummy
Resident temp;

DROP Tables temp;

Greetings,

Marcellino

View solution in original post

jonathandienst · ‎2015-04-17

In a LOAD:

LOAD ...

WHERE (Substr(F1, 3, 1) <> '7'

Or as an If expression:

SUM(If(Substr(F1, 3, 1) <> '7', F1))

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

MK_QSL · ‎2015-04-17

LOAD

*

Where Index(F1,'7',1) <> 3;

LOAD TEXT(F1) as F1 INLINE

[

F1

0570035

0530065

0550099

0560016

0510015

0570010

0520040

0580002

];

kulasekhar · ‎2015-04-17

Thanks

Manish

awhitfield · ‎2015-04-17

HI Kula,

try this please:

160553:
Load * Inline
[
F1
0570035
0530065
0550099
0560016
0510015
0570010
0520040
0580002
];

Results:
NoConcatenate Load
F1

Resident 160553
Where
Mid(F1,3,1)<>'7'
;

Drop table 160553;

Regards

Andy

nagarjuna_kotha · ‎2015-04-17

Hi ,

Kind find below attached file .let me know its working to u or not ?

Regards,

Nagarjuna

kulasekhar · ‎2015-04-17

F1

1234567

1234576

1234756

1237456

1273456

1723456

7123456

How to remove All "7"

awhitfield · ‎2015-04-17

160553:
Load * Inline
[
F1

1234567
1234576
1234756
1237456
1273456
1723456
7123456
];

Result:
NoConcatenate LOAD

PurgeChar(F1,7) as F1

Resident 160553;

kulasekhar · ‎2015-04-17

doesn't work

first row 7 only remove

kulasekhar · ‎2015-04-17

thanks but i don't have trial variation