1 Reply Latest reply: Mar 23, 2017 2:14 PM by Felip Drechsler RSS

    Joining two tables and plot a Combo Graph "Need Help"

    Ankit Gupta

      ****I am doing things in Qlik Sense"

       

      I have an excel  file with two tabs :

       

      Tab 1 Name: Forecast

      Tab 2 Name : Forecast Lookup

       

      "Forecast Lookup" have all the projected 2017 expenses by Program/Project Name

      "Forecast" file have Program/Project Names where we already started spending against projects. (You can say it contains sub-set of total data from from tab Forecast Lookup)

       

      Now when I am loading this excel file with two tables , I am joining based on Program Name.

      Project Name I am keeping from Forecast table, and Commented the one in Forecast lookup to avoid Synthetic key.

       

      Post all this, I am putting a Combo Chart that shows Total AOP (Total Forecast for 2017), Total Spend , Forecast against each Program/Project.... where Dimension is Program, Project Name and Measure is Total AOP, Spend and Forecast $.

       

      Problem I am facing: Chart only showing those programs and projects against which PO's are already opened and not showing the ones which dont have PO's or spend or forecast in sheet "Forecast"

       

      When I drill from Program to Project, functionality works as expected but Total AOP Bars are not changing as per the actual value of Total AOP for a projects , its showing sum of the Total AOP (all Program/Projects Sum)

       

      I have attached the script and excel file for reference. if someone please help me in resolving it will be great help.

       

       

      Thx

      Ankit