Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

All dates from Dimension in Chart

Hello,


In my Data Mart I’ve:

  • A Dim_Calendar which have all the dates of the year with the following attributes:
    •                Day
    •                Month
    •                Year
  • A fact Table to store the goals of a football team;

Both have the Foot_Date to connection.

In Qlikview when a create my star schema I “loose” all dates which are not common between these tables. That’s logic.

So when I create a Chart with Dimension Day from Dim_ I only will get the dates which are present in Table Facts.  The expression used is a fact from the Fact Table:

               = SUM({<id_player={P}, Foot_Date>} Nmr_Goals)


Imagine you just got in the fact table the day 15 of December forward, how do I show a chart where I appear every day of the month even if the value of the Days until 15th are 0.

That’s is possible?

Thanks

1 Solution

Accepted Solutions

Re: All dates from Dimension in Chart

Check out the attached application and see if this helps you grab what I am trying to say:

8 Replies

Re: All dates from Dimension in Chart

Have you tried unchecking 'Suppress Zero-Values' on the Presentation tab of the chart properties?

Not applicable

Re: All dates from Dimension in Chart

The problem is that I don't have that dates on Fact Tables. Basically, In that dates did not happen goals so that dates were not loaded to Fact_Tables.

But, In my opinion the chart need to have all the dates and the Qlikview needs to have the capacity to get all the days of a month (from Dim_Calendar)  and not only the dates that have a fact to calculate.

Re: All dates from Dimension in Chart

if you are using Dim_Calendar as dimension, I think you should be able to get all dates.

Highlighted
Not applicable

Re: All dates from Dimension in Chart

Do you have any ideia why I only get the days present in Fact_Table?

In Script I do "NoConcatenate" to load fact tables because I've multiple fact tables and loose data if I concatenate all of them. Can the problem be there?

Re: All dates from Dimension in Chart

Check out the attached application and see if this helps you grab what I am trying to say:

Not applicable

Re: All dates from Dimension in Chart

Thank you Sunny T I think it will help me to achieve my goal

Re: All dates from Dimension in Chart

Awesome

Not applicable

Re: All dates from Dimension in Chart

I already have all the dates in my charts However, in some others charts I'm not getting all the dates, specially in charts that I'm using set analysis with columns from Fact Tables. Do you have any logic explanation  for this?

Thanks