topic Re: Problem with Duplicate Row in QlikView

Problem with Duplicate Row

Anonymous — Fri, 09 Oct 2015 10:00:01 GMT

Hi,

I have a question about showing duplicate Row.

I have a Data like this:

Col1 Col2 Qty Col4

A B 10 D

A B 10 E

The problem is when I create a pivot table with 2 dimension(Col1 and Col2) with the expression Sum(Qty)

There is only one row shown, the result i expect is both row is shown in my pivot table ?

Do you know how to solve this problem ?

Thanks

nagaiank — Fri, 09 Oct 2015 10:06:34 GMT

You may add Col4 also as a dimension

Fri, 09 Oct 2015 10:17:21 GMT

use aggr(sum(Qty),Col4) in expression

Fri, 09 Oct 2015 10:18:06 GMT

Refer attached QVW

SreeniJD — Fri, 09 Oct 2015 10:23:05 GMT

That is obvious behavior... because values will be suppressed!.. If you want to display both then use Aggr by the 3rd dimension.

HTH

Sreeni

Anonymous — Fri, 09 Oct 2015 10:40:06 GMT

use straight table without aggregate function..

Kushal_Chawda — Fri, 09 Oct 2015 10:48:46 GMT

Use Table box

santhosh_k_n — Fri, 09 Oct 2015 11:05:30 GMT

Hi,

I could say unless you present the col4 you will get single row, try using the Col4 in the pivot table and hide the cloum.