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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Quentinn
Contributor III
Contributor III

Above function reference problem in line chart

Hi everyone,

Is there a solution for the following? I'd like to represent the growth rate in a line chart, with 2 dimensions:

one being "year" and one being "campus.name". In the syntax below, the above function is referencing the dimension "campus.name" instead of year, and I can't change the sorting.  You can see it in the graph: there's only 3 campus names, because it uses one for reference, but this isn't right

 

(count({<Doctor={Y},[ExaminationType.Abbrev]={B}>} SubsampleID)/Above(count(total <[Subsample.CreatedDateTime.autoCalendar.Year], [Campus.Name]> {<Doctor={Y},[ExaminationType.Abbrev]={B}>} SubsampleID)) - 1) * 100

 

Quentinn_0-1652459043269.png

 

 

Labels (1)
1 Reply
Quentinn
Contributor III
Contributor III
Author

does anyone have a solution/answer?

I noticed in a bar chart this is possible