need help in QlikView

[#1]

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 ?

[#2]

Guys, thankyou for your help, the prblem is solved.

i was just making it to omplicated where as the solution was very easy, thank you again

[#3]

Thank you Quwok, i was obviously making a very simple task into a complicated one.

but ur soluton made me think in the right direction, thank you