Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Qlikview - Not dependency values

Hello,

I’ve this Data Mart in Qlikview:

Data_Mart.JPG

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?

1 Solution

Accepted Solutions

Re: Qlikview - Not dependency values

Try this expression:

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

Capture.PNG

Here GOAL! is the Label for the expression

View solution in original post

5 Replies

Re: Qlikview - Not dependency values

Henric describes how to do this in the load script :

     Generating Missing Data In QlikView

Re: Qlikview - Not dependency values

Try this expression:

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

Capture.PNG

Here GOAL! is the Label for the expression

View solution in original post

MVP
MVP

Re: Qlikview - Not dependency values

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

2016-01-05 #2.PNG

Highlighted
Not applicable

Re: Qlikview - Not dependency values

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

Try this expression:

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

and use your expression for label and it should work