| 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
