Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Table 1:
Transaction reference number | Report status |
'18818136SELL | N |
'18818136SELL | U |
I have a table with number of columns, two of which are 'transaction ref.no.' and 'report status'. There are a number of duplicate trans.ref.no. with stauts U and N but I only want to keep those with status N in the table.
How can I do this? I am new to qlik so don't have much idea.
Regards
Hi Swuel,
Yes , i am referring to your code and it works as expected by the @abhi_kash .(who started the tread).Thankyou.
@abhi_kash ,Please mark as correct Answer if its works for you.