topic Re: Counts with multiple filters in QlikView

Counts with multiple filters

paulsparrow — Wed, 25 Nov 2020 16:16:04 GMT

Trying to create a bar chart that will give me counts based on filters chosen for dimensions. Fields include

CSRep

Year

Month

Team Lead

Survey Type

ResponseId (distinct for each line of data)

My bar chart has CSRep and counts of Survey Types. I'm looking for those counts to reflect the Year and Month chosen. COUNT(DISTINCT [Response ID]) returns total count of rep for all months with the same amount for all Survey Types. No reflection of filters chosen. Looking for ideas.

Thanks

Re: Counts with multiple filters

trdandamudi — Tue, 09 May 2017 20:05:05 GMT

Can you please share a small sample...

Re: Counts with multiple filters

paulsparrow — Tue, 09 May 2017 20:54:13 GMT

So here I've used COUNT(DISTINCT(ResponseId))

However the filter non Month_Survey is not taking into consideration as the counts represented are for 3 months total data (Jan-Mar)

Re: Counts with multiple filters

Digvijay_Singh — Tue, 09 May 2017 21:10:34 GMT

If filters are not getting response means there could be some problem in data association. Can you share data model or you can check if month is not connected with other desired fields.