How to remove those

[kulasekhar]

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

[kulasekhar]

sorry i have trial variation

[awhitfield]

Works fine on mine, post what you have actually got in your script please

Andy

[jagan]

Hi,

Try like this

To filter in script

LOAD

*

FROM DataSource

WHERE Mid(ID,3,1) <> '7';

If you want to handle in front end try like this

Sum(Aggr(If(Mid(ID,3,1) <> '7', 1, 0), ID))

Check this link below for similar one

Exclude values from count with set analysis

Regards,

Jagan.

[kulasekhar]

Hi Andrew,

Load the following data into qlikview:

LOAD * INLINE[
F1

1234567

1234576

1234756

1237456

1273456

1723456

7123456

];

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

(remove 7 in that)

So output should be :

     F1

---------------

123456

123456

123456

123456

123456

123456

123456

Thanks,

sekhar

[awhitfield]

This is the table view result of the above script I sent:

                                               Andrew Whitfield      17-Apr-2015 05:20    (in response to kula sekhar)    

160553:
Load * Inline
[
F1

1234567
1234576
1234756
1237456
1273456
1723456
7123456
];

Result:
NoConcatenate LOAD

PurgeChar(F1,7) as F1

Resident 160553;

[Marcellino_Groothof · Accepted solution]

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

[vinod2086]

Hi Shekar,

Try this

Where not(WildMatch(F1,'057*'));

[kulasekhar]

thanks

Andrew

[Peter_Cammaert]

It may be a detail, but try to change the PurgeChar call in Andrews code into this:

PurgeChar(F1,'7') as F1

and even safer would be a call like htis:

PurgeChar(text(F1),'7') as F1

[kulasekhar]

Thanks ever one