Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Displaying dates vertically

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.

1 Solution

Accepted Solutions
celambarasan
Not applicable

Re: Displaying dates vertically

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;

6 Replies
mayilvahanan
Not applicable

Re: Displaying dates vertically

HI

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

];

celambarasan
Not applicable

Re: Displaying dates vertically

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;

nagaiank
Not applicable

Re: Displaying dates vertically

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.

Not applicable

Re: Displaying dates vertically

Mayil:

This worked.

Thanks a lot.

Not applicable

Re: Displaying dates vertically

Celambarasan:

This also worked.

Thanks you guys so much.

Not applicable

Re: Displaying dates vertically

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.