topic Re: Displaying dates vertically in QlikView

Displaying dates vertically

Wed, 19 Dec 2012 18:59:14 GMT

Hi Friends:

I have 3 dates in my Parent table.

For a Task, the values coming are

Disv_Date Int_Date LiveDate

01/02/2012 02/02/2012 03/02/2012

but my requirement is to display them as

Disv_date 01/02/2012

Int_Date 02/02/2012

Livedate 03/02/2012

How can i do this.

Using Inline Load, i can make date column like

Load * Inline

[Make_Date

Disv

Int

Live];

This will give me dates/text vertically. I can resident load my main table to get the above 3 dates

but how to a make them such that the format looks like below

Disv_date 01/02/2012

Int_Date 02/02/2012

Livedate 03/02/2012

Thanks in advance for your help.

Re: Displaying dates vertically

MayilVahanan — Wed, 19 Dec 2012 21:41:23 GMT

Try like this

CrossTable(Dimension,Date,1)

lOAD RowNo() as Row, * Inline

[

Disv_Date,Int_Date,LiveDate

01/02/2012,02/02/2012,03/02/2012

];

Re: Displaying dates vertically

CELAMBARASAN — Wed, 19 Dec 2012 21:43:35 GMT

Try with this

MainTable:

LOAD * Inline [

Disv_Date,Int_Date,LiveDate

01/02/2012,02/02/2012,03/02/2012

];

ResultTable:

LOAD 'Disv_Date' AS Key, Disv_Date AS Value

Resident

MainTable;

LOAD 'Int_Date' AS Key, Int_Date AS Value

Resident

MainTable;

LOAD 'LiveDate' AS Key, LiveDate AS Value

Resident

MainTable;

Re: Displaying dates vertically

nagaiank — Thu, 20 Dec 2012 00:01:21 GMT

If your requirement is just to display the three dates vertically, you may create a straight table chart with no dimensions and the following dates as three expresions with 'No Totals' selected.

Disv_Date

Int_Date

LiveDate

An example is attached.

Re: Displaying dates vertically

Thu, 20 Dec 2012 00:12:17 GMT

Mayil:

This worked.

Thanks a lot.

Re: Displaying dates vertically

Thu, 20 Dec 2012 00:12:52 GMT

Celambarasan:

This also worked.

Thanks you guys so much.

Re: Displaying dates vertically

Thu, 20 Dec 2012 00:22:02 GMT

Krishnamoorthy:

Thanks for your response.

This is what i need. I did exactly like you did

except that yours is Inline load and mine is coming from the table but still i don't get the format like yours.