Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner - Champion
Partner - Champion

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;

View solution in original post

6 Replies
MayilVahanan

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

];

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
CELAMBARASAN
Partner - Champion
Partner - Champion

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
Specialist III
Specialist III

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
Author

Mayil:

This worked.

Thanks a lot.

Not applicable
Author

Celambarasan:

This also worked.

Thanks you guys so much.

Not applicable
Author

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.