topic Re: Filtering of Data through Set Analysis. in QlikView

Filtering of Data through Set Analysis.

Thu, 09 Apr 2015 15:29:35 GMT

Hello Everyone,

Header 1	Header 2	Header 3
resourcetype	empid	silo
ss	100	silo1
ss	200	silo1
ss	300	silo1
tm	400	silo1
tm	500	silo1
dm	600	silo1
dm	700	silo1
dm	800	silo1
dm	900	silo1
ym	1000	silo1
ym	1100	silo1

I have to show Number of employees by Silo only for the Resource_Types 'ss' and 'tm'.
and i should have a filter to filter only by 'SS' and 'tm'.
and By default it should show me 5 Employees whichc are related to Resource_Type ss and tm only.

Than if i select SS ,it should show me 3 as count and if tm ,then count should be 2.

Regards,

Pratik

Re: Filtering of Data through Set Analysis.

sunny_talwar — Thu, 09 Apr 2015 15:43:14 GMT

Maybe this will work:

If(GetSelectedCount(resourcetype) = 0, Count({<resourcetype = {'ss', 'tm'}>} empid), Count(empid)

this will show count if you select ym or dm, is that going to be a problem?

Best,

Sunny

Re: Filtering of Data through Set Analysis.

awhitfield — Thu, 09 Apr 2015 15:57:42 GMT

Hi Pratik,

please see the attached example, hope it helps

andy

Re: Filtering of Data through Set Analysis.

sunny_talwar — Thu, 09 Apr 2015 16:13:49 GMT

Much more elegant way to do it.