Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Sudhakar,
I think the data itself is like that please check below table.
Hi Kiran,
Thank you for you help, I will verify the data once and check it
Sure, I think the data is the problem
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
Hi Kiran,
Can you help me for this because this is urgent requirement for me
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.
Hi Sudhakar,
I am not that much experienced in QMC.