Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
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

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