Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filtering of Data through Set Analysis.

Hello Everyone,

Header 1Header 2Header 3
resourcetypeempidsilo
ss100silo1
ss200silo1
ss300silo1
tm400silo1
tm500silo1
dm600silo1
dm700silo1
dm800silo1
dm900silo1
ym1000silo1
ym1100silo1

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

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

3 Replies
sunny_talwar

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

awhitfield
Partner - Champion
Partner - Champion

Hi Pratik,

please see the attached example, hope it helps

andy

sunny_talwar

Much more elegant way to do it.