2 Replies Latest reply: Apr 14, 2016 10:20 AM by Anthony Finelli RSS

    Set Analysis Questions :) Qlik Sense

    Anthony Finelli

      I am new to Qlik and having a challenge I would appreciate any assistance with.

       

      My goal is to show a value in a gauge irrespective of what has been selected on the filter pane.

       

      For example, I have a chart reflecting % complete for 5 projects on 03/31/2017.  Adjacent to the chart I have a gauge reflecting for % complete at the end of the prior year for just 1 of the 5 projects.  However, I cannot find the proper formula to achieve the gauge data.

       

      Here is the formula I am trying to use for the gauge:

       

      max({1<[Report Date]={2015-12-31}, [Project Name] = {"Funding"}>"Percentage Complete")

       

      Any assistance would be greatly appreciated...