0 Replies Latest reply: Jul 7, 2015 7:03 AM by aadil munshi RSS

    Combining Apps

      Hi i have just started using qliksense to create a weekly executive report showing sales performance for the last week, an average of the last 4 weeks and year to date. i am having an issue combining graphs of ytd sales and an average of last 4 weeks sales. OR combinng last weeks sales with YTD sales.

       

      The data in my excel file that i uploaded is like this:

      WkTotal 2015 SalesTotal 2015 BudgetTotal 2015 Budget Absolute VarianceTotal 2015 Budget % Variance
      5076,8070,0064,809.8%
      5182,3289,24-6,82-7.7%
      5257,42154,69-96,97-62.8%
      YTD9,15,46911,53,375-1,60,906-14.0%

       

      The only that i have found to show only week 52 sales in my combined chart is to use a week filter and then select '52'. This is fine but i have a another combined chart trying to show 'YTD' but the data here will show week 52 data because of the filter i selected. To show YTD data i have to select the YTD filter but then i will have both 52 and YTD in both graphs.

       

      ive attached images of the 2 graphs. i had to create the graphs in different apps to get them to appear. i wasn't even able to create them in separate sheets because of the week filter apparently applies to all sheets within an app.

       

      Any solution to this please?