3 Replies Latest reply: Oct 20, 2014 2:52 AM by Diwakar Nahata RSS

    How to get a column based on another derived column

    Diwakar Nahata

      Hi,

       

      Please refer the below image where i have created a sequence number (Sno) for WeekID.

      I have a straight table (below) where i have dynamically created a dimension which buckets the selected weeks into group of 4 using the sequence number of the Week. Now i have the sequence number in the column (based on the WeekIDs selected). How do i show the WeekID or WeekDesc corresponding to it.

      For e.g. in the below straight table example, I want to show the WeekID (or WeekDesc) corresponding to the Sno 8,12,16 displayed.

      QlikView_Expression.jpg

       

      Thanks,

      Diwakar