Relationship problem

[piekepotloed]

Hello,

I'm trying to create a data model to get this end result:

Stage	# Students
noStage	1
Stage2	1
Stage3	2

Table one contains Student data

StudentID
1
2
3
4

Table two contains for each student zero, one or more trajecten

StudentID	TrajectId
1	1
4	2
2	3
3	4

Table three contains for each traject the last action, if an action is available

TrajectId	LastActionId
1	13
2	15
4	18

Table for contains all the action records

TrajectId	ActionId	Stage
1	11	Stage1
1	12	Stage2
1	13	Stage3
2	14	Stage1
2	15	Stage2
3	16	Stage1
3	17	Stage2
3	18	Stage3

[Anonymous]

Does the Straight Table Chart in the attached qvw amended from your's suffice ?

[awhitfield]

Hi Peter,

Straight table, Stage as dimension, expression = Count(StudentID) set Presentation 'Null Symbol' = No Stage'

HTH

Andy

[piekepotloed]

Hi Bill,

It solves the problem in the chart...but I was also looking for a way to get a listbox where I can select the Stage. So I expect data like this:

StudentId  TrajectId Stage

  1                   1      Stage3

  2                   3      Stage3

  3                   4      NoStage

  4                   2      Stage2

[jagan]

Hi,

Try like this

Straight Table :

Dimension : Stage

Expression: Count(Distinct StudentID)

Now in Properties -> Presentation -> Null Symbol-> Give NoStage

Hope this helps you.

Regards,

Jagan.

[Anonymous · Accepted solution]

Maybe sort it in the script like this ?

[sunilkumarqv]

@Hi Peter

Create Dimensions  StudentId and Trajectid

suppress null value

expression

If(IsNull(Stage),'NoStage',Stage)

[sunilkumarqv]

=if(IsNull(Stage),'noStage',Stage)

same express ion use can use in list box