Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
alwayslearning
Contributor

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
Esteemed Contributor II

Re: Data/Table Manipulation & Expression

8 Replies
vinieme12
Esteemed Contributor II

Re: Data/Table Manipulation & Expression

vinieme12
Esteemed Contributor II

Re: Data/Table Manipulation & Expression

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

ahaahaaha
Honored Contributor

Re: Data/Table Manipulation & Expression

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

alwayslearning
Contributor

Re: Data/Table Manipulation & Expression

This work for me.

Thanks.

alwayslearning
Contributor

Re: Data/Table Manipulation & Expression

Just a follow up.

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

vinieme12
Esteemed Contributor II

Re: Data/Table Manipulation & Expression

in background expression try

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

vinieme12
Esteemed Contributor II

Re: Data/Table Manipulation & Expression

yes, i just created it for reference

alwayslearning
Contributor

Re: Data/Table Manipulation & Expression

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.