topic Re: Qlikview - Not dependency values in QlikView

Qlikview - Not dependency values

Tue, 05 Jan 2016 18:47:28 GMT

Hello,

I’ve this Data Mart in Qlikview:

The Dim_Calendar represents the Calendar of the Year

The Dim_Players represents the a team player statistics.

The fact table gives me the total goals of each player in a Team.

I want to have a bar chart to show us the evolution of goals of each player.

This part is easy and could already implement. Except that I'm not getting a point :

If you repair the Player 1 ( ID_PLayer = 1) did not score on 01/03/2015 , but he continues with three goals on league (scored on day 01/01/2015 ) , however the fact table only contains the dates where the player scored goals. So, the chart on Qlikview for the player 1 only returns the following dates:

01-01-2015
04-01-2015

But I want to create intelligent enough in chart to realize this goals: even though the player has not marked in that date he continues with the same previous goals. So with this data mart the chart should have for the player 1:

01-01-2015 - 3
02-01-2015 - 3
03-01-2015 - 3
04-01-2015 - 5

How can I achieve that?

Re: Qlikview - Not dependency values

Anonymous — Tue, 05 Jan 2016 19:14:50 GMT

Henric describes how to do this in the load script :

Generating Missing Data In QlikView

Re: Qlikview - Not dependency values

sunny_talwar — Tue, 05 Jan 2016 19:16:20 GMT

Try this expression:

=If(Sum(GOALS) > 0, Sum({<ID_PLAYER>}GOALS), Above([GOALS!])).

Here GOAL! is the Label for the expression

Re: Qlikview - Not dependency values

petter — Tue, 05 Jan 2016 20:00:24 GMT

Here comes a version that avoids If() and use Trellis to visualize goals over time for each player:

Re: Qlikview - Not dependency values

Thu, 07 Jan 2016 12:32:27 GMT

Perfect Sunny T

Only one more question:

I'm using external data to define labels for expression. Like that:

=only({<LABELID={'FIELD'}>}LABELTX)

How I insert that label in Above() function?

Re: Qlikview - Not dependency values

sunny_talwar — Thu, 07 Jan 2016 16:10:38 GMT

Try this expression:

=If(Sum(GOALS) > 0, Sum({<ID_PLAYER>}GOALS), Above(Column(1)))

and use your expression for label and it should work