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

[awhitfield]

Hi Kula,

I'm glad it's sorted, please remember to mark an answer as CORRECT if you are happy!

Andy