topic Re: How to bring 5 rows to 2 rows in QlikView

How to bring 5 rows to 2 rows

Anonymous — Fri, 27 Jul 2012 15:17:53 GMT

Hi all,

Maybe a bit of a strange question, but I really need to have this

In QlikView I have the following data:

CUSTOMER	ORDERID
Customer X	15154
Customer X	21644
Customer X	22564
Customer X	22578
Customer X	54650

I need to make a straight table with the name | address | zip | city. In case that a customer has more then one ORDERID, I need to see the specific customer two times, or in other words two lines with the same data. The outcome of the example data above needs to be like this:

CUSTOMER	ADDRESS	ZIPCODE	CITY
Customer X	Address customer X	Zipcode customer X	City customer X
Customer X	Address customer X	Zipcode customer X	City customer X

It doesn´t matter where I solve this: it can be in the script as well as in an expression. I'am thinking about flagging and counting, but untill now I can't get it done. I hope some of you can help me out.

Cheers,

Henco

Re: How to bring 5 rows to 2 rows

Fri, 27 Jul 2012 15:42:42 GMT

Please take a look at the attached QVW.

Re: How to bring 5 rows to 2 rows

Anonymous — Fri, 27 Jul 2012 18:01:38 GMT

Thanks for your help. Now I need to translate this to my own situation, I think that is going to work. One thing I forgot to mention is that it needs to work per orderdate, but I think I can do that.

Thanks again.

Cheers,

Henco

Re: How to bring 5 rows to 2 rows

Anonymous — Mon, 30 Jul 2012 07:13:08 GMT

Hi,

I made it as you said, so far so good. Thanks again.

As I said, I forgot to mention that I need to deal with orderdates. So I need to see this per orderdate. Could you please explain to me how I need to do that?

So, the inline data will look like this:

[Orders]:

LOAD

CUSTOMER,

ORDERID,

Date

INLINE

[

CUSTOMER, ORDERID, Date

Customer X, 15154, 15-02-2012

Customer X, 21644, 15-02-2012

Customer X, 22564, 18-03-2012

Customer X, 22578, 18-03-2012

Customer X, 54650, 18-03-2012

Customer A, 12345, 12-03-2012

Customer A, 15648, 15-03-2012

Customer B, 99999, 15-08-2012

Customer B, 88888, 15-08-2012

];.

The result should be:

Customer X on two rows for 15-02-2012

Customer X on two rows for 18-03-2012

Customer A on one row for 12-03-2012

Customer A on one row for 15-03-2012

Cusomter B on two rows for 15-08-2012

Thanks in advance!

Cheers,
Henco

Re: How to bring 5 rows to 2 rows

Anonymous — Mon, 30 Jul 2012 18:44:16 GMT

There is no answer needed anymore. I fixed it by using Customer_Date as an ID.

Cheers,

Henco

Re: How to bring 5 rows to 2 rows

senpradip007 — Wed, 01 Aug 2012 12:03:04 GMT

Hi hencovanee,

Please take a look at the attached QVW.