topic Re: Qlikview distinct count in QlikView

Qlikview distinct count

kishorj1982 — Mon, 29 May 2017 08:32:53 GMT

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

Re: Qlikview distinct count

RonaldDoes — Mon, 29 May 2017 08:36:45 GMT

Unfortunately, I can't open the QVW.

Re: Qlikview distinct count

qlikview979 — Mon, 29 May 2017 08:52:14 GMT

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

Re: Qlikview distinct count

Anil_Babu_Samineni — Mon, 29 May 2017 08:57:42 GMT

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

Re: Qlikview distinct count

kishorj1982 — Mon, 29 May 2017 09:03:14 GMT

PFA.

It should be open now.

Thanks

Re: Qlikview distinct count

vinieme12 — Mon, 29 May 2017 09:11:42 GMT

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)

Re: Qlikview distinct count

kishorj1982 — Mon, 29 May 2017 09:28:31 GMT

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

Re: Qlikview distinct count

vinieme12 — Mon, 29 May 2017 09:35:58 GMT

sorry what do you want exactly?

Your actual distinct count is 1220

Re: Qlikview distinct count

kishorj1982 — Mon, 29 May 2017 09:39:26 GMT

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

Re: Qlikview distinct count

vinieme12 — Mon, 29 May 2017 09:43:35 GMT

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?