Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I am relatively new to Qlikview and have only been experimenting this for the past month. I am trying to create an application such that the objective is to observe the Orders received and Revenue received for a selected month/months. The challenge here is that I have 2 different columns of dates, one for the order date and one for the revenue date. Is it possible that the month selected can be applicable to both section and sieve out both data. I have looked through various resources online but am unable to find similar answer to my problem.
I have attached my data for easy reference.
Thank so much for the help
Cheers
Adam
Hi,
use Concatenate to concat both the table.
or try with outer join also
Regards
Hi,
Try like
load Order_id,
Order_Date as Date,
Sales_amt
From table1;
join
load Order_id,
Revenue_date as Date,
Revenue_Received
From table1;
Regards
There are a few methods you can try but largely it depends on your reporting requirements. If you are not looking to report on these in a single view, you could create two calendars, one for each and use a link table to join them.
Or you can create a calendar for each and an additional master calendar and use set analysis or triggers to create an 'artificial' link.
Or you can do as attached, please note I haven't removed the synthetic key as its just a quick go.
Hi Max,
Thanks for the help. The solution is short and sweet.
This is indeed a very good platform for me to start learning about Qlikview.
Cheers
Hi Christopher,
Thanks for the help and time to do up the example. Highly appreciated.
One more question, to remove the synthetic key, do I create a composite key with profit center and date?
How should I load it since the date is a changed field?
Thanks
Hi
See this excellent article on how to handle date scenarios like yours:
HTH
Jonathan
This is one way.