topic Re: View duplicates in pivot table in QlikView

View duplicates in pivot table

Anonymous — Thu, 05 Sep 2013 12:22:42 GMT

Hello,

in the attached qvw file I'd like to show all the records (as you see now) or only those one which have two places for the same code (only the two records for the B code).

Can someone help me, please?

Thank you

Re: View duplicates in pivot table

swuehl — Thu, 05 Sep 2013 12:27:56 GMT

Maybe like attached?

Re: View duplicates in pivot table

Anonymous — Thu, 05 Sep 2013 12:37:19 GMT

Nope.

I'd like to show the entire table (when the "All" button is set) or only the two records og the B code

Code Place Qty

B 1 15

2 20

When the "Duplicates" button is set.

Hope it's clear now.

Thank you.

Re: View duplicates in pivot table

swuehl — Thu, 05 Sep 2013 12:44:27 GMT

Hm, unclear why you don't see what I see:

and

Is this what you expect to see?

On what QV version are you? If not specified, I always assume a recent version.

Re: Re: View duplicates in pivot table

Anonymous — Thu, 05 Sep 2013 13:25:10 GMT

Well, I expected to see what you see but it isn't what I see

I'm sorry I haven't written my QV version 10.00.9731.9 SR6.

Thank you again.

Re: Re: Re: View duplicates in pivot table

swuehl — Thu, 05 Sep 2013 13:31:30 GMT

I replaced the conditional expression (which probably causes the issue using QV10) with a show condition in layout tab.

Re: Re: Re: View duplicates in pivot table

Anonymous — Thu, 05 Sep 2013 14:14:28 GMT

Very Good! Now it works properly. I thought that applying a condition on the Show box of the layout tag makes all the table visible or not...how it works only for specified rows?

Re: Re: Re: View duplicates in pivot table

swuehl — Thu, 05 Sep 2013 14:19:09 GMT

There are two tables now...

But right, it should be easier to include the check into the expression:

=if(ViewDuplicates,Sum({<Code = {"=count(distinct Place)>1"}>}Qty), Sum(Qty))

Re: Re: Re: View duplicates in pivot table

Anonymous — Thu, 05 Sep 2013 14:29:00 GMT

This is the cleanest solution

Thank you for the help.