21 Replies Latest reply: Mar 3, 2017 7:41 AM by Sunny Talwar RSS

    A difficult nut to crack!

    Waqas Saeed

      Hi Experts,

       

      I'm trying to present data in a straight table in a certain way. Below is the table I have.

       

      Tab1.PNG

       

      The Table has Name, Appearance Order, Date and Sale value. I want to present this in a straight table using the Appearance order. For example, the Appearance order is 3 for A, so I should be able to see only last 3 Sale and date values for Name A. I want to present this data in like this in a straight table:

       

      Tab2.PNG

       

      Is there anyway we can do this? Either at the script level or within Qlik at expression level?

       

      Thanks