Set Analysis Expression in Qlik Sense

[bvssudhakar]

Hello Experts,

I have created one combo chart in qlik view with below mentioned Dimension and Expressions

Dimension: Recruiter Name

Expression 1: =Sum({<[Job Status]={'Open'}>} [No. of CV Submitted])    ------(Bar)

Expression 2: =Sum({<[Job Status]={'Open'}>} [Total No. of Openings]-Placed)     -----------(Line)

Expression 3: =Sum({<[Job Status]={'Open'}>}Placed) --------------(Line)

It gave correct results, But

Now I tried in qlik sense with same expression it is giving wrong values and that too it is giving numbers for all bars and some other number to line values but same number

can you guys please suggest me how to write those expression in qlik sense

here i am attaching qvf also

[kkkumar82]

Hi Sudhakar,

I think the data itself is like that please check below table.

[bvssudhakar]

Hi Kiran,

Thank you for you help, I will verify the data once and check it

[kkkumar82]

Sure, I think the data is the problem

[Anonymous]

Hi

You can use below expression

Dimension: Recruiter Name

Expression 1: =   Sum({1-$<([Job Status]='Open')>} No. of CV Submitted)      [No. of CV Submitted])    ------(Bar)

Expression 2: =  Sum({1-$<([Job Status]='Open')>}Total No. of Openings)     [ Total No. of Openings]-Placed-------(Line)

Expression 3: =   Sum({1-$<([Job Status]='Open')>}Sales)    Placed) --------------(Line)

Sales filed -------------you can use any calculate filed

[bvssudhakar]

Hi Kiran,

Can you help me for this because this is urgent requirement for me

Scheduling Auto refresh in qliksense

[jonathandienst]

You might get better results if you post this as a new discussion rather than tacking onto this discussion which is about a separate issue.

[kkkumar82]

Hi Sudhakar,

I am not that much experienced in QMC.