How to associate datas from two differents selections table into one

[#1]

Hello everybody,

I'm new on QlikView and that explains this stupid question.. But I'm looking for the answer everywhere and I'm sure you ll be the fastest way to solve my problem.

So I get from my database a complete time table.

- I made a first selection table "Year" where there are 2014 and 2015 for example.

- I made a second selection table "Week" where are my weeks "1, 2, 3 ....".

Now I want a new selection table where I can have " Year - Week" as "2015 - 14" for example.

So the question looks simple: How can I join my two tables into one?

Thank you for helping. I really don't find the answer on tutorials..

Tristan

[robert_mika]

In your load statement try:

load

Year& Week as Year&'-'&Week,

...

[awhitfield · Accepted solution]

Hi Tristan,

you can combine the two to create a single field in your load script, e.g.:

Year(Date)&'-' & Week(Date) AS YearWeek

HTH

Andy

[Gysbert_Wassenaar]

Add a list box object with an expression as field: =Year & ' - ' & Week

[#5]

Thank you for answering as fast!