Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I'm starting in developing in Qlikview but I come across some trouble with a requirement. What I need to do basically is create a metric for previous years sale, in that sense I want to put the value of the previous year day sale on the current year day sale. Hope the table explain this better:
Want to put the values of 2016 sales on the Previous sale column of the current year. I hope there is a way to solve this requirement via script without loading the table again and do a left join.
Thanks in advance,
Rodrigo.
Hello!
You can use Below() function where the second parameter will be the rows you want to offset.
Hi,
You can also try something like this in the script:
LOAD
...
day
sales
...
JOIN
day+interval(1, 'year') as day
sales as previous_sales
Regards,
João Duarte