4 Replies Latest reply: Feb 22, 2016 4:37 AM by Hans de Vries RSS

    Remove double entries in a table, based on value

    Hans de Vries

      Although I still regard myself to be a newbie to QlikView, I thought this solution to a problem I had (and oh boy, did I wrestle with it..) is worthwhile posting.

       

      Let's suppose you have a table, in which you have many entries for one Id. Sometimes, it's handy to "clean-up" that table and lose all records, except those with the highest value in a certain field (other than Id). This could be a date, an amount of $, anything.

      I have done some experimenting with peek() function. Maybe this might come in handy for some of you.

       

      Of course, you gurus out there who have a far more simple solution: I'm eager to learn about it!

       

      I have attached the simple qvw file.

       

      Best regards,

      Hans