topic Re: QV Merge Two rows in one Row in QlikView

QV Merge Two rows in one Row

vijayit43 — Thu, 07 Aug 2014 08:28:31 GMT

In My QV One Order agains Multiple Item We want to create pivot where dimension field in customerid,msalesorderno,date,DO No,DO Date and Expression Field Sum(Actual Qty) and Sum(Do QTY),, We wand to Show Those Of Records show in one Row But it break in 2 rows at Do No because one Item are DO order Not Created where show blank how to solve this issue for refrence Attach QV

Re: QV Merge Two rows in one Row

mdmukramali — Thu, 07 Aug 2014 08:38:10 GMT

Dear,

Vijay you want to hide the null rows?

can you please elaborate what you are looking for?

Thanks,

Mukram

Re: QV Merge Two rows in one Row

vijayit43 — Thu, 07 Aug 2014 08:40:32 GMT

Yes I want to hide null row but null rows quantity is sum to another rows quantity

Re: QV Merge Two rows in one Row

mdmukramali — Thu, 07 Aug 2014 08:45:11 GMT

Dear,

then what you want to display in that null columns.

Re: QV Merge Two rows in one Row

vijayit43 — Thu, 07 Aug 2014 09:19:57 GMT

No, but that Row quantity sum in bellow line Quantity

Re: Re: QV Merge Two rows in one Row

Thu, 07 Aug 2014 20:19:38 GMT

Please see attached. I suppressed null values on Dono field:

Then added an aggr around the expressions so that values summed over all customer records.

Hope that helps.

Matt