Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sashokku
Contributor

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

Tags (1)
1 Reply
felipedl
Valued Contributor III

Re: Help needed in writing function ?

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.