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: 
alwayslearning
Creator
Creator

Data/Table Manipulation & Expression

Hi

I upload some data like the following:

Project ID     Checkpoint   Delivery Date

001               1                    01/04/2017

001               2                    01/06/2017

001               3                    01/10/2017

002               1                    01/05/2017

002               2                    01/06/2017

002               3                    01/07/2017


I also have a master calendar


I want to display a table like the below:

 

Project IDCheckpointJan-17Feb-17Mar-17Apr-17May-17Jun-17Jul-17Aug-17Sep-17Oct-17Nov-17
0011 01/04/2017
001201/06/2017
001301/10/2017
002101/05/2017
002201/06/2017
0023 01/07/2017
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

See Attached APP

255759.PNG

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

8 Replies
vinieme12
Champion III
Champion III

See Attached APP

255759.PNG

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

Just Drag the YearMonth field from your Master Calendar, over your Expression, you will see blue reference lines that denote the position where the column will be dropped

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
ahaahaaha
Partner - Master
Partner - Master

You can still remove the null values so that do not show the bottom line.

alwayslearning
Creator
Creator
Author

This work for me.

Thanks.

alwayslearning
Creator
Creator
Author

Just a follow up.

I want to highlight the values where the checkpoint date appears by colouring the cell.

vinieme12
Champion III
Champion III

in background expression try

=if(not isnull(DeliveryDate),rgb(0,176,252))

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

yes, i just created it for reference

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
alwayslearning
Creator
Creator
Author

Thanks again.

Just remembered to place that expression in the 'background colour' in the expression section. I was placing it across the whole table via custom format cell.