Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This would be a calculated dimension(under 'Dimesions' tab)
try in calculated condition dimension IN DIMENSION TAB
aggr(only({<b_SinceWhen-={'-'},b_Coe={'S -'}>}b_JobNo),b_JobNo)