topic Re: How to associate datas from two differents selections table into one in QlikView

How to associate datas from two differents selections table into one

Wed, 06 May 2015 12:38:56 GMT

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

Re: How to associate datas from two differents selections table into one

robert_mika — Wed, 06 May 2015 13:05:06 GMT

In your load statement try:

load

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

...

Re: How to associate datas from two differents selections table into one

awhitfield — Wed, 06 May 2015 13:05:34 GMT

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

Re: How to associate datas from two differents selections table into one

Gysbert_Wassenaar — Wed, 06 May 2015 13:08:04 GMT

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

Re: How to associate datas from two differents selections table into one

Wed, 06 May 2015 13:21:10 GMT

Thank you for answering as fast!