topic Re: I want to see missing or 0 dates in Qlik Sense in App Development

I want to see missing or 0 dates in Qlik Sense

fredericvillemi — Tue, 07 Jun 2016 13:58:35 GMT

Hello,

I know this is one of the most important and difficult thing to do in Qlikview but now I would like to do it in Qlik Sense.

I have a table with a date, a country and a value.

Of course, when i select a Country, some dates are not available anymore.

I want my bar chart to make these dates appear instead of suppressing them.

With Qlikview I can Show All Values, and uncheck Suppress Zeros and uncheck Supress Missing and work with a Master Calendar and that's fine.

With Qlik Sense I don't find these settings and I did not manage to do it ..

How can i Do it ? I'm sure we can

Thanks

Re: I want to see missing or 0 dates in Qlik Sense

Gysbert_Wassenaar — Tue, 07 Jun 2016 15:14:51 GMT

Try adding sum({1}0) to your measure: sum(Value) + sum({1}0). And make sure to enable the Show zero values option.

Re: I want to see missing or 0 dates in Qlik Sense

fredericvillemi — Tue, 07 Jun 2016 15:16:03 GMT

Brilliant !

Thanks

Re: I want to see missing or 0 dates in Qlik Sense

fredericvillemi — Mon, 04 Jul 2016 15:13:33 GMT

Hmmm in fact I was very happy because it worked when I had only one month of data.

But now, I have loaded 6 months and when I just select one month, the graph shows all 6 months with only values for the month selected. Quite strange .. So I still can't work with that solution ..

Do you have an example qvf where it works flawlessly ?

Thanks

Re: I want to see missing or 0 dates in Qlik Sense

Gysbert_Wassenaar — Mon, 04 Jul 2016 17:18:41 GMT

What's the behavior you expect?

Re: I want to see missing or 0 dates in Qlik Sense

fredericvillemi — Fri, 08 Jul 2016 09:43:25 GMT

Sorry for the late answer.

Here is what I want :

I have a list of connections on a web site, with a date, unique id of visitor, and country

I have a link of this file with a generated calendar with all days.

I have made a bar chart with Days and number of visitors (having Show null values checked).

When I do a standard bar chart, and don't select anything, it works and your bar chart with sum({1} 0) is fine too

When I select one month, it works as expected with the standard bar chart but your chart with sum({1} 0) shows all days without filtering on the month. That's ok but i prefer the first behaviour

But if I select something outside the date area, the browser for example, your chart still works the same but the standard only shows the day where the browser is available.

How can I do to show only the days from the calendar period selected (with null values) when another filter is selected ?

What I would like to show here is the days of february only with the 2/02 at 1 and the other days at 0

If I can send you a qvf tell me

Thanks