topic Re: 2 dimensions mapping in one chart issue in QlikView

2 dimensions mapping in one chart issue

Fri, 07 Feb 2014 14:56:49 GMT

Attached is the qvw file with an issue i have.

There are two dimensions:

Date1 and Date 2.

I've built two charts Chart 1 and Chart 2 with the according dimensions displayed.

What i need is to put both dimensions into one chart ("Chart Result").

Can you please advise on how to solve this?

Thanks!

Re: 2 dimensions mapping in one chart issue

Fri, 07 Feb 2014 15:07:09 GMT

ISn't it better like this ?

Chris

Re: 2 dimensions mapping in one chart issue

Gysbert_Wassenaar — Fri, 07 Feb 2014 15:07:12 GMT

Concatenate the tables instead. See attached qvw.

Re: 2 dimensions mapping in one chart issue

Fri, 07 Feb 2014 15:40:01 GMT

I've used your solution but encountered another issue. If i name Date 1 and Date 2 as Date (see below) data loop appears in the table viewer for my qvw in production. The one that i attached is an example of the problem. I have a complex data tables structure in the production file. Do you think there is another way of putting these dimensions into one chart?

Re: 2 dimensions mapping in one chart issue

Gysbert_Wassenaar — Fri, 07 Feb 2014 15:48:07 GMT

Not with the result you're looking for. You will have to create a singe date dimension somehow and use that in your chart. Based on the document you posted I suggested concatenating your tables. Perhaps simply using another name as Date for the new field resolves the loop. No way of telling without knowing your data model.

You could also try creating a link table instead:

DateLink:

Load distinct Date1 as Date, Date1

resident Table1;

concatenate(DateLink)

Load distinct Date2 as Date, Date2

resident Table2;