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

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

Thu, 22 May 2014 05:33:49 GMT

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

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

MK_QSL — Thu, 22 May 2014 05:47:52 GMT

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

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

Anonymous — Thu, 22 May 2014 06:00:57 GMT

check this

HTH

Regards,
Ravi N.

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

vardhancse — Thu, 22 May 2014 06:03:10 GMT

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

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

Thu, 22 May 2014 06:45:45 GMT

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)

LOAD

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

FROM

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

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

Thu, 22 May 2014 06:49:56 GMT

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)

LOAD

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

FROM

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