Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
bvssudhakar
Creator III
Creator III

Set Analysis Expression in Qlik Sense

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

7 Replies
kkkumar82
Specialist III
Specialist III

Hi Sudhakar,

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

Community_8-20-2018.png

bvssudhakar
Creator III
Creator III
Author

Hi Kiran,

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

kkkumar82
Specialist III
Specialist III

Sure, I think the data is the problem

shivaji123
Contributor III
Contributor III

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
Creator III
Creator III
Author

Hi Kiran,

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

Scheduling Auto refresh in qliksense

jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
kkkumar82
Specialist III
Specialist III

Hi Sudhakar,

I am not that much experienced in QMC.