Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2015-09-02 02:14 PM

Dynamic Reference Lines -- Gauge Extension

I'm having trouble with creating a dynamic reference line when changing filters.

What' i'm looking for is a reference line for last year's data.  Which will change during a presentation when selecting regions and sub offices.  We have mutliple years of data, but i'd like to compare it against 2014's ROI data for the company as a whole as well as regional and local office specific.

The Camp Yr is a column header where the data is YYYY value, one of which is 2014.

Below is what i concocted in the reference line expression.

(sum( {$<[Camp Yr] ={“2014”}>}([Gross Sales (Campaign)]) )

-

(sum( {$<[Camp Yr] ={“2014”}>}([Campaign Costs])))

/

(sum( {$<[Camp Yr]={“2014”}>}([Campaign Costs]))))

whereas the rest of the guage would look at the filtered data.

841 Views
0 Likes
0 Replies