topic Re: hurry help in QlikView

hurry help

Tue, 22 Apr 2014 07:10:37 GMT

i have 2 dates in my dimension like

1 20/04/2014

1 21/04/2014

2 20/04/2014

2 21/04/2014

i want display each date in different dimension like

Tue, 22 Apr 2014 07:13:33 GMT

U can try the below script:

T1:

Load date as Date1

from table_name

where date=20/04/2014;

T2:

Load date as Date2

from table_name

where date=21/04/2014;

Tue, 22 Apr 2014 07:15:29 GMT

Can you please provide some more details.......

MK_QSL — Tue, 22 Apr 2014 07:15:42 GMT

Temp:

Load RowNo() as NO, Date Inline

[

Date

21/04/2014

22/04/2014

];

NoConcatenate

Final:

Load NO Resident Temp;

Join

Load Date Resident Temp;

Drop Table Temp;

Tue, 22 Apr 2014 07:20:05 GMT

Hi,

Like this?

Table:

Load

DateField

If(DateField='20/04/2014',DateField) as DateField1,

If(DateField='21/04/2014',DateField) as DateField2

From YourSource;

Hope this helps ..!