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

    Set Analysis Questions :) Qlik Sense

    Tony 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...