Discussion Board for collaboration related to QlikView App Development.
Can any one help me out to resolve the issue of finding the date and price change in between last Monday to current Monday .
I want the Table as below
But table Appearing like this
Thanks for the prompt replay but my query is not to find the price of monday.
My query is find the price change it may be high or less. but FirstSortedValue is giving the highest or lost value in the week range.
if price change 3 or 4 time in a week then FirstSortedValue is giving the null value.
Help me out to solve this issue
If it did change 3-4 times, what do you intend to see? All of them in different rows? Avg of all the changes?
I want to find the first change in the price.
Exp. I want to pick the first price change between 25.01.2016 (mon) to 01.02.2016 (mon)
25.01.2016 price is 305 and if it change to 309 / 300 on 28.01.2016 and again it change on 29.01.2016 to another no. but i want to pick first change if it does not change it will give null else no.