topic need help in QlikView in QlikView

need help in QlikView

Thu, 03 Jun 2010 15:15:23 GMT

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 ?

need help in QlikView

Thu, 03 Jun 2010 15:48:06 GMT

is it just happinstance that the no is given with the highest ID for a char?

If you can retrieve the data in different sequence you could "lookup" the previous value of No with peek()

Maybe you can do a reorder once loaded into QV based on your business rules for the No field?

Regards

Jürg

need help in QlikView

quwok — Thu, 03 Jun 2010 16:49:07 GMT

Assuming that every Char has a No and there is only one No for every Char

Load Id and Char into one table and Char and No into another, but exclude the empty No. you'll get something like:

TableA:

Id	Char
1	A
2	B
3	C
4	C
5	C
6	D
7	D

TableB:

Char	No
A	4
B	3
C	2
D	1

This should be it, but if you like you can join the two tables back together again

need help in QlikView

Thu, 03 Jun 2010 17:25:56 GMT

Hi thanks for the reply , but that is not the case it is not the highest value it can be any value

need help in QlikView

Thu, 03 Jun 2010 17:36:15 GMT

Hi Quwok,

Thanks fo the resoponse, but my requiremtent is to fill the values in the orignal table

need help in QlikView

quwok — Thu, 03 Jun 2010 17:41:55 GMT

If you left joined Table B to Table A, you'll get

Id	Char	No
1	A	4
2	B	3
3	C	2
4	C	2
5	C	2
6	D	1
7	D	1

or am i missing something here?

need help in QlikView

Fri, 04 Jun 2010 10:30:26 GMT

I think you need to show a more complete example. You say a Char can have different No values. What is the rule for assigning the values to the Char? Do you want the latest given No in order of the ID applied to the preceeding Chars?

Regards

Juerg

need help in QlikView

Fri, 04 Jun 2010 10:49:32 GMT

first u fetch the table than transform the table fill blank value with below figure

Regards

Ashish

need help in QlikView

Fri, 04 Jun 2010 10:55:02 GMT

qvw file

need help in QlikView

Fri, 04 Jun 2010 13:19:36 GMT

How do you left join a tab, that is in QlikView

i mean, i have one table as shown at the top, i can create the secnd table, using resident tables.

but thn how will i left join tab2 with tab1 ??

need help in QlikView

Fri, 04 Jun 2010 13:40:36 GMT

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

need help in QlikView

Fri, 04 Jun 2010 13:42:42 GMT

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