Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I'm trying to present data in a straight table in a certain way. Below is the table I have.
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:
Is there anyway we can do this? Either at the script level or within Qlik at expression level?
Thanks
There is no planned date supplied to C
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
I think the order of Planned date is fine
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?
I think the sorting was a little off which might have throw you off... Attaching the correctly sorted version.