topic Re: Join Rowns in QlikView

Join Rowns

Fri, 03 Aug 2012 13:56:06 GMT

Hi,

I have a question about joining rows and the scenaio is this:

I´ve got the table below:

ID | DESCRIPTION

1 | AAAAA

2 | BBBBB

3 | CCCCC

4 | DDDDD

5 | EEEEE

6 | FFFFFF

6 | GGGGG

7 | HHHHH

I am trying to have the rows from ID 3 to 7 showing as one row= 8 | ZZZZZZ, so when I click on 8 or ZZZZZ I have the equivalent to rows from 3 to 7.

Can someone assist me on this.

Kind regards,

Jorge

Re: Join Rowns

jonathandienst — Fri, 03 Aug 2012 14:07:04 GMT

You could do something like this (assuming that you want to keep all the rows in the model and can select 3-7:


LOAD ID, 
          DESCRIPTION, 
          If(ID >= 3 And ID <= 7, 8, ID) As ID1,
          If(ID >= 3 And ID <= 7, 'ZZZZZ', DESCRIPTION) As DESCRIPTION1
Inline
[
ID , DESCRIPTION
1  , AAAAA
2  , BBBBB
3  , CCCCC
4  , DDDDD
5  , EEEEE
6  , FFFFFF
6  , GGGGG
7  , HHHHH
];

Now you can create a list box for field ID1. Clicking 8 here will select ID 3-7. You may want to also have a list box for ID. Rename ID1 and DESCRIPTION1 in a way that makes sense in your application.

Hope that helps

Jonathan

Re: Join Rowns

Fri, 03 Aug 2012 15:07:29 GMT

Thanks a lot for your time and help, Jonathan, this is it!

Best regards,

Jorge