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

    Chart Properties Expression

    Chee Hang Lim
      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