Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
andrewc
Contributor II
Contributor II

Master Items Total <Dimension>

Hi all,
 
I am trying to create master items which calculates percentages of a total without having to define the total < dimension > of the chart in which it is being used. I would like to be able to drop the master item onto any chart and have the percentage calculate base on the dimension(s) in specific chart.
 
 
For instance:
If I had a chart showing % against a dimension of 'month / year' then I would normally do this:
Count(SessionKey) / count( total < MonthYear > SessionKey)
 
And if I were doing something similar but over 'day of week' then Qlik would need me to do this:
Count(SessionKey) / count( total < DayOfWeek > SessionKey)
 
This means I would need to create two different Master Items. I would much prefer to define this one, something like:
Count(SessionKey) / count( total < GetDimension > SessionKey)
 
Thanks
A

 

 

Labels (1)
0 Replies