topic Re: Relationship problem in QlikView

Relationship problem

piekepotloed — Thu, 07 May 2015 09:51:55 GMT

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

Re: Relationship problem

Anonymous — Thu, 07 May 2015 09:56:43 GMT

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

Re: Relationship problem

awhitfield — Thu, 07 May 2015 10:00:48 GMT

Hi Peter,

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

HTH

Andy

Re: Relationship problem

piekepotloed — Thu, 07 May 2015 10:17:23 GMT

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

Re: Relationship problem

jagan — Thu, 07 May 2015 10:18:06 GMT

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.

Re: Relationship problem

Anonymous — Thu, 07 May 2015 10:49:10 GMT

Maybe sort it in the script like this ?

Re: Relationship problem

sunilkumarqv — Thu, 07 May 2015 10:58:37 GMT

@Hi Peter

Create Dimensions StudentId and Trajectid

suppress null value

expression

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

Re: Relationship problem

sunilkumarqv — Thu, 07 May 2015 11:00:21 GMT

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

same express ion use can use in list box