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

missing value as 0

Hi,

As you can see above, there are missing values. but I would like to present all the dates in there so that I can observe time based progression.

There are no missing date values in the table and even though the count is Null the date is taking up one row since I used this code in script.

QuartersMap: 

MAPPING LOAD  

rowno() as Month, 

'Q' & Ceil (rowno()/3) as Quarter 

AUTOGENERATE (12); 

     

Temp: 

Load 

min([Complete Date]) as minDate, 

max([Complete Date]) as maxDate 

Resident Tasks; 

     

Let varMinDate = Num(peek('minDate', 0, 'Temp')); 

Let varMaxDate = Num(peek('maxDate', 0, 'Temp')); 

DROP Table Temp; 

     

TempCalendar: 

LOAD 

$(varMinDate) + Iterno()-1 As Num, 

Date($(varMinDate) + IterNo() - 1) as TempDate 

AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate); 

 

MasterCalendar: 

Load 

  TempDate AS [Complete Date], 

  week(TempDate) As Week, 

  Year(TempDate) As Year, 

  Month(TempDate) As Month, 

  Day(TempDate) As Day,

//Hour(TempDate) As Hour,

// Minute(TempDate) As Minute,

// Second(TempDate) As Second,

  ApplyMap('QuartersMap', month(TempDate), Null()) as Quarter, 

  Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear, 

  WeekDay(TempDate) as WeekDay 

Resident TempCalendar 

Order By TempDate ASC; 

Drop Table TempCalendar; 

--------------------------------------------------------------------------------------------------------------------------

I have used the same data for both table and chart. and in table I see all the dates.

as you can see, even though values are missing it is still taking up a row for every date.

I want the same with my chart.

Please help!! Thank you!!

1 Solution

Accepted Solutions
sunny_talwar

Have you unchecked 'Suppress Zero-Values' and 'Suppress Missing' on the presentation tab?

View solution in original post

4 Replies
sunny_talwar

Have you unchecked 'Suppress Zero-Values' and 'Suppress Missing' on the presentation tab?

Not applicable
Author

Thank you Sunny!

you are amazing....

vishsaggi
Champion III
Champion III

Capture.PNGCan you send us a sample qvw file for a quick look if possible ?

Did you uncheck (highlighted in Yellow in the bottom) this and tried ?

Not applicable
Author

vishsaggi‌ thank you! this is exactly the way sunny answered it and it worked!