Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to display month in straight table even for columns that don't have data?

Hi, I have a monthyear field in a straight table that displays the monthyear only when there is data in the other columns. How do I display the monthyear even though there is no data in the other columns? This is for completeness of the table to show all months. Thanks.

current:

monthyear

name

Site

01/2012

A

Z

02/2012

B

U

04/2012

C

L

I want it to be:

monthyear

name

Site

01/2012

A

Z

02/2012

B

U

03/2012

-

-

04/2012

C

L

5 Replies

Re: How to display month in straight table even for columns that don't have data?

you need to create a monthyear field in master calendar....

Now after creating your above table, untick suppress when value is null in dimension table,,, also tick show all values

Under presentation tab, untick suppress zero values

ravic906
Contributor III

Re: How to display month in straight table even for columns that don't have data?

Hi

check this

HTH

Regards,
Ravi N.

vardhancse
Valued Contributor II

Re: How to display month in straight table even for columns that don't have data?

Hi,

Other than the date fields in the table, we can create one master calendar  based on the requirement.

In master calendar we can maintain fiscal as well as calendar.

So weather data is there or not, all the dates will display

Not applicable

Re: How to display month in straight table even for columns that don't have data?

Hi, do you know why my first table (in bold and italics) for creating master calendar cannot be found? Thanks.

Temp: 

Load 

               min([Print Date]) as minDate, 

               max([Print Date]) as maxDate 

Resident A;

.

.

.  (the rest of the master calendar codes)

.

.

.

A:

LOAD

     .

     .

     .

     .

     .

     date(floor(timestamp#(Replace([PRINTDATE],' ',' '), 'DD.MM.YYYY hh:ss:mm'))) as [Print Date]   

FROM

<filename>

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Not applicable

Re: How to display month in straight table even for columns that don't have data?

Hi, do you know why my first table (in bold and italics) for creating master calendar cannot be found? Thanks.

Temp:

Load

               min([Print Date]) as minDate,

               max([Print Date]) as maxDate

Resident A;

.

.

.  (the rest of the master calendar codes)

.

.

.

A:

LOAD

     .

     .

     .

     .

     .

     date(floor(timestamp#(Replace([PRINTDATE],' ',' '), 'DD.MM.YYYY hh:ss:mm'))) as [Print Date]  

FROM

<filename>

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Community Browser