2 Replies Latest reply: Aug 13, 2013 1:56 AM by Mohit Sharma RSS

    Chart Properties Expression

    Chee Hang Lim
      b_LoginIDb_FullNameb_JobNob_Codeb_SinceWhenb_LunchTimeDirectb_LunchTimeIndirect
      1530XXX117766.1.60S - 00
      1530XXX117766.1.60S - 00
      1530XXX117768.1.78S -01:41pm00

       

      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