Discussion board where members can get started with QlikView.
A new question following my previous one : Handling dates and cross table
Now that I have my table set up properly, I'd like to go a little further.
I'd like to associate data from the table tmpData2 with its respective market, at a given date. Thus, I would like to build a table that would look like :
(Let's call this table TOTO)
For one market there are 4 and exactly 4 (always the same) possible BUs.
Some data like the data contained in tmpData (so CS_R+B) is related to a Market in general, some is related to a subdivision Market_BU.
I get the couples Market_BU from an excel file that I set up manually.
But I'd like to "multiply" it with the Dates I got from my previous table tmpData so that I can create unique entries Market_BU_Dates to be associated with the relevant value for CS_R+B.
I tried to write it this way but obviously it does not work the way it should :
(ooxml, embedded labels, table is tab1);
Date(Num#(MonthNumb),'DD-MM-YYYY') as Dates,
(ooxml, embedded labels, table is Mkt_BU_corr);
LOAD * FROM Mkt;
INNER JOIN(Mkt) LOAD Dates FROM tmpData2;
The problem occurs during the TOTO table building, so I guess my syntax is not correct.
The idea is afterwards to turn tmpData2 into a table that would look like
so that I can have the match.
Sorry for the quite fastidious explanation and thousands of thanks in advance for your help,
Do not hesitate to ask questions if my case is not clear.
Can you provide around 10 lines sample data in excel file? Also provide the resultant table you required !
Thanks for your answer.
The table 'Mkt' is the following :
And I would like to "add" a column with any of the possible dates that I got from the crosstable (basically any month from Jan 2010 or 2011 to Dec 2015), to create a key "Mkt_BU_Date".
For instance :
Is it any clearer or should I reformulate ?
Thanks a lot for your understanding, and your patience.
Not enough.... ! The data you provide is not having any date or month and you want to include date in final requirements.
Please provide in excel file.
Ok, the dates come from the file I was referring to in my previous post Handling dates and cross table
I gathered it all in one excel file so that the 4 files I am trying to connect are the 4 tabs of the attached excel file
Hope it helps (by the way I couldn't find a way to attach a file directly to my answer, is it normal ? I could attach only pictures...) and it makes it more clear.