Qlikview distinct count

[kishorj1982]

Hi all,

PFA.

I am using pivot table.I need to show distinct values for customers I am using count(distinct custno).

In first tab Summation for total as per column is matching but summation for total as per row is not matching.Can you please suggest how shall i proceed.

I need to show distinct custno in other chart in second rab that should also match.

I have shown both charts in separate tab.

Please suggest.

Thanks

[RonaldDoes]

Unfortunately, I can't open the QVW.

[qlikview979]

Yes,I am also not able to open your document.

[Anil_Babu_Samineni]

Try to re attach the qvw, Doe to fail while open the APp

[kishorj1982]

PFA.

It should be open now.

Thanks

[vinieme12]

it's because there are there are multiple Custno that have more than one PaymentTermDesc

See attached i've added a table to show these Custno's

Dimension

Custno

PaymentTermDesc

Expression

Count({<CustNo = {"=Count(DISTINCT PaymentTermDesc)>1"}>}DISTINCT PaymentTermDesc)

[kishorj1982]

Hi ,

thanks for the response.

Second tab is for detail level if in first tab total count is 2 then in detail level deials of  only 2 cust shoulds display.

Can you please suggest what shall i do in second chart.

Thanks

[vinieme12]

sorry what do you want exactly?

Your actual distinct count is 1220

[kishorj1982]

when we can go in detail,level selection for only these customers should display instead of showing whole customers.

When ever i can select counrt count of summary level chart and detail level chart should match

Thanks

[vinieme12]

the counts will match if you make a selection on PaymentTermDesc

if one customerno is repeated in multiple PaymentTermDesc then how can you expect unique count?

Can you show by example what you want?