Discussion Board for collaboration on QlikView Scripting.
I'm trying to create a data model to get this end result:
Table one contains Student data
Table two contains for each student zero, one or more trajecten
Table three contains for each traject the last action, if an action is available
Table for contains all the action records
Go to Solution.
Maybe sort it in the script like this ?
Does the Straight Table Chart in the attached qvw amended from your's suffice ?
Straight table, Stage as dimension, expression = Count(StudentID) set Presentation 'Null Symbol' = No Stage'
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
Try like this
Straight Table :
Dimension : Stage
Expression: Count(Distinct StudentID)
Now in Properties -> Presentation -> Null Symbol-> Give NoStage
Hope this helps you.
Create Dimensions StudentId and Trajectid
suppress null value
same express ion use can use in list box