7 Replies Latest reply: Aug 20, 2018 7:41 AM by kiran ch RSS

    Set Analysis Expression in Qlik Sense

    Sudhakar Battula

      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