Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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
Hi,
Try
Replace(F1,7,'')
Regards,
Greeshma
Hi Sekhar, you can use Purgechar():
LOAD PurgeChar(F1, '7') as F1;
LOAD * INLINE [
F1
1234567
1234576
1234756
1237456
1273456
1723456
7123456
];
Hi Ruben,
result display only one row.like 123456
Thanks
sekhar
Hi Sekhar, there are many records with the same value, in a list box will show as only one value, if you add some another distinct field like "RowNo() as Number", and create a table box with those two fields, you'll see all records separated.
ok
THanks
Ruben