topic Re: Re: How to hide populated missing data in QlikView

How to hide populated missing data

Anonymous — Mon, 05 May 2014 21:13:09 GMT

My data set contains incidents opened by a service desk over the last 3 full months w/ month to date. When I first created the dashboard, I did not populate missing data and when certain selections were made, dates would disappear. In the new version I have populated missing data but when a date filter is applied (lets say the last 30 days) the dates go back the full 3 months. Do I need to use a calculated dimension to hide this data?

Re: How to hide populated missing data

SergeyMak — Tue, 06 May 2014 01:03:37 GMT

Hi Nick,

Please share a sample

Re: How to hide populated missing data

kangaroomac — Tue, 06 May 2014 02:16:23 GMT

Hiya,

Are you using a Master Calendar at all? It should help with your "missing data" when date ranges are selected.

It also creates a good base for time selections (year, month, etc.) and point-in-time reporting (using set analysis for say ytd, mtd, same month last year, etc.).

Re: How to hide populated missing data

Anonymous — Tue, 20 May 2014 23:14:22 GMT

I am using a Master Calendar. My Master Calendar generates the dates for Incident_Created_Date and that field name is the same in the Master Calendar generation as it is in my data query. This is working great because I can select a product with no incidents opened on 5/19/2014 and a zero will appear on that date (dimension set to show all values) where previously (before populating missing data) the 5/19/2014 data point would disappear all together.

Now my issue is this, I'm populating missing data for the last 3 full months with month to date. I have buttons to apply a selection to the Incident_Created_Date to only show incidents in the last 7 days, 30 days, 60 days, 90 days, week to date, month to date, etc. After populating missing data the chart appears like the below (selection is week to date). The dates outside my selection (week to date) still appear and I want to hide them based on the selection.

Re: How to hide populated missing data

SergeyMak — Wed, 21 May 2014 00:37:44 GMT

Hi Nick,

Please share an example

Re: How to hide populated missing data

Anonymous — Wed, 21 May 2014 00:40:43 GMT

I'll work on switching the QVW to a sample dataset in the morning. Thanks!

Re: Re: How to hide populated missing data

Anonymous — Wed, 21 May 2014 14:01:38 GMT

See attached sample. I want my users to change the time frame using the available buttons (Last 7/14/30/90 Days) but the chart does not hide the dates outside the selection. If I disable "Show All Values" on the dimension they hide but then I lose the dates inside the time frame where there is no data.

Re: How to hide populated missing data

Anonymous — Thu, 22 May 2014 18:52:06 GMT

anyone have ideas? this is my last hurdle before rolling out this dashboard.

Re: How to hide populated missing data

SergeyMak — Fri, 23 May 2014 00:44:06 GMT

So. If I uncheck Show all values for the dimension, it works

But as I understand you want to see messing values within selected dates?

Re: Re: How to hide populated missing data

SergeyMak — Fri, 23 May 2014 00:57:05 GMT

With unchecked Show all values for the dimension and unchecked Presentation\Supress Zero-Values and Supress Missing everything works.

PFA an example - I deleted several values

Re: Re: How to hide populated missing data

Anonymous — Fri, 23 May 2014 12:36:33 GMT

The data has changed too much for me to figure out how to apply it to my current dashboard. In my attached sample, if you uncheck show all values, suppress zero values, and suppress missing, the dates presented changes based on the timeframes but if you select a CC_SDBU value and that CC_SDBU has no data for a specific date, that date disappears from the chart.

I see what you are doing in your attachment with the count by day but that would be tricky to accomplish in my dashboard.

Re: How to hide populated missing data

SergeyMak — Mon, 26 May 2014 01:08:29 GMT

Hi Nick,

Please share your source document \\Msad\root\NA\NY\users\listerma\Downloads\community sample delete.xls

Regards,

Sergey

Re: Re: How to hide populated missing data

Anonymous — Tue, 27 May 2014 13:37:25 GMT

Here you go

Re: How to hide populated missing data

Tue, 27 May 2014 13:44:29 GMT

This is a quick solution but doesnt show you all the dates only dates which you have a value for

Re: Re: How to hide populated missing data

Anonymous — Tue, 27 May 2014 14:09:49 GMT

Thanks everyone. I would really like to show the dates with no values. I think I'll have to query in a count for these charts.

Re: Re: Re: How to hide populated missing data

SergeyMak — Wed, 28 May 2014 09:24:59 GMT

Hi, Nick

I think I've got the result

I just add additional expression like Only({$<CC_SDBU>}Visit_Date) and deselected Bar in options

PFA

Re: Re: How to hide populated missing data

Anonymous — Wed, 28 May 2014 13:21:54 GMT

This looks like it should work. Going to try this out today. Thanks, Sergey!

I have never used ONLY so what exactly is this doing? If I later add more than CC_SDBU, do you think that single expression will continue to work or should I add additional expressions w/ bar disabled for the other fields?

Re: Re: How to hide populated missing data

Anonymous — Wed, 28 May 2014 14:48:10 GMT

I added some drill down groups and additional fields to my data, comma separated all the fields in the ONLY expression you gave me, and everything appears to be working as I would like it to. Thanks again, Sergey!

Re: How to hide populated missing data

SergeyMak — Thu, 29 May 2014 00:50:33 GMT

Hi Nick,

Only - is aggregation function like sum or count, but display the value of the field.

It looks like dimension, but it's not, because if you have in the chart several different values of your Only expression for your dimensions you will have null as a result, but you have ability to use set analysis.

In your case you have Visit_Date as dimension and use Visit_Date in Only expression. It means that you have no possibility to have Null as result of your expression.