topic Re: Dimension Value Count against each of dimension value Qlikview in QlikView

Dimension Value Count against each of dimension value Qlikview

gopal5879 — Mon, 26 Jan 2026 18:19:17 GMT

Hello folks,

I need some help with set analysis question.

I have data sample as posted below . I am using expression
Aggr(NODISTINCT count( distinct pid ),tin,pid) to compute expression Provider count.

Now the business requirement changed., Have to show total number of providers as shown in field Provider count highlighted in yellow for each of the tin against each pid

Can someone suggest me how my set analysis expression should look like please?

Re: Dimension Value Count against each of dimension value Qlikview

MayilVahanan — Mon, 08 Feb 2021 01:25:19 GMT

Hi @gopal5879

Try like below

count(Total<tin> distinct pid )

Re: Dimension Value Count against each of dimension value Qlikview

gopal5879 — Tue, 09 Feb 2021 00:10:17 GMT

Hello Mayil,

It works, thanks a lot for your time. Appreciate your help

Re: Dimension Value Count against each of dimension value Qlikview

MayilVahanan — Tue, 09 Feb 2021 01:11:31 GMT

Hi @gopal5879

If your requirement is satisfied, Can you pls close this thread by marking correct answer