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: 
santho_ak
Partner - Creator III
Partner - Creator III

Help needed in writing function ?

I need a help in writing a function. For example, this is my table which I took from SQL database.

Candidate StatusCandidate id
Selected05
Rejected03
Rejected07
Rejected02

I want to show a chart which should say number of candidates rejected & number of employees selected. Help me out.Thanks. Can someone explain with chart. Thanks

1 Reply
felipedl
Partner - Specialist III
Partner - Specialist III

Hi Santosh,

After you load the data, you can use set analysis to check the both measures you want, something like.

// For the selected candidates

count({<[Candidate Status]={'Selected'}>}[Candidate id])

// For the selected candidates

count({<[Candidate Status]={'Rejected'}>}[Candidate id])

The bolded part is the set analysis and will segment your data as stated on the equality.

Felipe.