topic Re: Two fields as one filter in QlikView

Two fields as one filter

Fri, 01 Aug 2014 12:31:15 GMT

Hi Qlik community!

I got a data model defined, and I'm using two fields of dates:

- Date_1: 2010, 2011, 2012

- Date_2: 2012, 2013, 2014

I already tried to rename these two fields as one unique field through the script, but I created an circular reference (redundancy in the database).

How can I create, without modifying the script, one unique filter named Date_3 with the following values: 2010, 2011, 2012, 2013, 2014

Thanks a lot for your help!!

Regards,

Vincent

sujeetsingh — Fri, 01 Aug 2014 12:41:00 GMT

Vincet,

That is you need to analyse the data you are having man.

what if the values are different as

Date1=2010

Date2=2011

Else you can use join as

Table1:

Load

ID,

Date1 as Date_New

From----

Table2L:

P_ID

,Date2

from------

Join(Table1)

load

P_ID

,Date2 as Date_New

Drop Table Table2;

This will derieve a new column as Date_New as combination of two dates.