View duplicates in pivot table

[Anonymous]

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

[swuehl]

Maybe like attached?

[Anonymous]

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.

[swuehl]

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.

[Anonymous]

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.

[swuehl]

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

[Anonymous]

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?

[swuehl · Accepted solution]

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))

[Anonymous]

This is the cleanest solution

Thank you for the help.