Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

A difficult nut to crack!

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

21 Replies
sunny_talwar

There is no planned date supplied to C

Capture.PNG

In other words, where is Date2 for C where Date is not available? Just like the rows I highlighted the rows for A and B?

Looking at the other part issue now

sunny_talwar

I think the order of Planned date is fine

Capture.PNG

Since 23/06/2016 is a bigger month then 24/02/2016, it is getting a later date in Planned Date 1. Is this not what you want in your logic?

Capture.PNG

I think the sorting was a little off which might have throw you off... Attaching the correctly sorted version.