Chart Properties Expression

Tue, 13 Aug 2013 01:21:51 GMT

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

Re: Chart Properties Expression

tresB — Tue, 13 Aug 2013 04:58:17 GMT

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

er_mohit — Tue, 13 Aug 2013 05:56:22 GMT

try in calculated condition dimension IN DIMENSION TAB

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