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

display records not in a dimension



Hello All,

I have created a chart containing two(2) calculated dimensions and a count expression to display the aging of audit dates.

Month(Computer_List_All.LastAuditDate)
Year(Computer_List_All.LastAuditDate)

count(Computer_List_All.Asset_Tag)

error loading imageI have 15 records in the database which do not have an 'Audit Date'. I have a questions here, how to show the records with no 'Audit Date' in the chart?
Thanks, any help is welcome,

Matthias



This is the result:


8 Replies
Not applicable
Author

Have you try to tick the "Show All Values" option on the properties options of the Graph ??

Properties > Dimensions > Panel "Settings For Selected Dimension"

Hope this will help.

Not applicable
Author

Hi, Yes the "Show All Values" option is on. Thanks

bismart
Creator
Creator

On presentation Tab, ensure Suppress Zero-Values and Suppress Missing are not checked

Not applicable
Author

Thanks for your answer, it is not checked.

bismart
Creator
Creator

I loaded following sample data

Load Inline





Year Month Audit

2005 Jan 1

2005 Feb 1

2005 Mar 0 etc...

Audit = 1 when audit was performed, Audit=0 for No Audit

Dimensions in chart = Year, Month

Expression: Audit

Presentation tab : Ensured no suppression was taking place

Background colour of expression :

IF



(Audit = 1,green(),lightred())

My chart shows Months with Audit as green bubble and months with missing audit as red... sorry, don't know how to paste image



bismart
Creator
Creator

LOAD * INLINE [
Year, Month, Audit
2005, Jan, 1
2005, Feb, 1
2005, Mar, 1
2005, April, 1
2005, May, 0
2005, Jun, 0
2005, Jul, 1
2005, Aug, 1
2005, Sep, 0
2005, Oct, 1
2005, Nov, 1
2005, Dec, 1
2006, Jan, 0
2006, Feb, 1
2006, Mar, 1
2006, April, 1
2006, May, 1
2006, Jun, 1
2006, Jul, 0
2006, Aug, 1
2006, Sep, 1
2006, Oct, 1
2006, Nov, 0
2006, Dec, 1
];

Not applicable
Author

Hi Bismart,

sorry for being not clear in my original post I am not interested in the fact that an audit has happened, I am interested in how many computers have been auditedand in which month, like an aging. I am counting the computers to find out how the distribution of the audit dates is. E.g. I know that 699 computers have been audited in July 2009 and 143 in June 2009 and ..... The target for me is to audit all in one month.

Thanks for your help.





Not applicable
Author

Hi,

If i can not show the count with empty Year and Month, how to fill the empty year and month with a default date?

Thanks