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: