Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

tabisen1
New Contributor

Find the date and price change with in the Week.

Dear All,

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

Correct Table.PNG

But table Appearing like this

change in Price date.PNG

5 Replies

Re: Find the date and price change with in the Week.

Try attached

tabisen1
New Contributor

Re: Find the date and price change with in the Week.

Dear Sunny,

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

tabisen1
New Contributor

Re: Find the date and price change with in the Week.

change in Price date.PNG

Re: Find the date and price change with in the Week.

If it did change 3-4 times, what do you intend to see? All of them in different rows? Avg of all the changes?

Highlighted
tabisen1
New Contributor

Re: Find the date and price change with in the Week.

Dear Sunny,

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.