Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody,
I have a table as below and i would like to get the price of next date in every records but i don't want to use the inter-records function due to it may not work in some scenarios.
Would you please help? please refer to the attached QVW,thanks.
Source table:
ID | Txn_Date | Price |
1 | 1/1/2014 | 1000 |
1 | 1/2/2014 | 2000 |
1 | 1/3/2014 | 3000 |
2 | 1/1/2014 | 4000 |
2 | 1/2/2014 | 5000 |
2 | 1/3/2014 | 6000 |
3 | 1/1/2014 | 7000 |
3 | 1/2/2014 | 8000 |
I want to show:
ID | Txn_Date | Price | Price of Next Date |
1 | 1/1/2014 | 1000 | 2000 |
1 | 1/2/2014 | 2000 | 3000 |
1 | 1/3/2014 | 3000 | |
2 | 1/1/2014 | 4000 | 5000 |
2 | 1/2/2014 | 5000 | 6000 |
2 | 1/3/2014 | 6000 | |
3 | 1/1/2014 | 7000 | 8000 |
3 | 1/2/2014 | 8000 |
What are the scenarios you suspect will not work with the inter-records function ?
[Looks like your qvw did not attach]
Dear,
You can use
=Below(Price) or Below(Sum(Price))
Thanks,
Mukram
Check this
yes, it will not work if i filter ID or Date.
The correct answer:
http://community.qlik.com/message/685171?et=watches.email.thread#685171