Chart Properties Expression

[#1]

b_LoginID	b_FullName	b_JobNo	b_Code	b_SinceWhen	b_LunchTimeDirect	b_LunchTimeIndirect
1530	XXX	117766.1.60	S -		0	0
1530	XXX	117766.1.60	S -		0	0
1530	XXX	117768.1.78	S -	01:41pm	0	0

Above is the sample data in source table and i am designing a straight table

The first column of the table will be name, each name only appear once if b_SinceWhen<>''

second column will be,

if b_SinceWhen<>''  and b_Coe='S -' then

display b_JobNo

How do i create these columns? Using expression? in the 'condition' or 'definition'

As i am very new in Qlikview. I would like to find out is it correct to use straight table to display this?

Thank you

[tresesco]

This would be a calculated dimension(under 'Dimesions' tab)

[er_mohit]

try in calculated condition dimension IN DIMENSION TAB

aggr(only({<b_SinceWhen-={'-'},b_Coe={'S -'}>}b_JobNo),b_JobNo)