11 Replies Latest reply: Jun 4, 2010 9:42 AM by AtifAhmad RSS

    need help in QlikView

    AtifAhmad

      Can some one help please ?

       

      I have a table

       

      Id

      Char

      No

      1

      A

      4

      2

      B

      3

      3

      C

       

      4

      C

       

      5

      C

      2

      6

      D

       

      7

      D

      1

       

       

      Requirement:

       

      Char C has No 2 in one of the rows.

      I want to fill the rest of the Cs with the same value.

       

      Same with D it has 1 so the rest of the occurrences of D must have No as 1 also

       

      (the Nos can be different so I cannot do update no='2' where Char=C )

       

      How can I fill the columns ?