I am creating a gauge in my Qlikview dashboard to track how close we are to meeting our financial goal at the end of the year.
Our goal is to reach $8,000,000 by the end of December 2017. Each financial figure is kept track of monthly and continually is added to the previous month to track our financials. I would like to have the gauge correlate with the month fields that I have listed.
Right now, when I select for instance "Feb", the gauge only calculated the financials for Februrary, however I would like to track Jan-Feb when I select "Feb." Is there a formula that can be used so that the month selected can also track the previous months as well?
Here is the formula I have currently:
Here is an example of what I have currently: (when I select February it just shows the % for February, not January and February which I would like)
If this is not possible, the only workaround I have figured is to select both January and February.
DateField would be whatever date field you have in your data. Could be [Accounting Date], [Billed Date] or whatever. But it would have to be a date field. If you don't have one, you should probably create one in your script.
If your data is at the month level only, add a date field where the date is the first day of the month.
The set analysis is saying pull the data from the beginning of the calendar year through the end of the available month derived from your date field.