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

Using varying reference lines with different levels of a drill down

I have a drill down which goes year-month-week-day-hour for call logging on duration and count for list of users, and I want to know if its possible to put on reference lines with different values based the level of drill down and the number of staff selected.

So, for example -

with one user selected when viewing by day the duration reference line should be set to 120 mins and the count reference line should be 25

with five users selected in (working) week view the respective values should be multiplied by 25 (i.e. 5 users x 5 days)

I am anticipating that an expression is required but have no idea where to start!

Thanks, Steve

1 Reply
maxgro
MVP
MVP

to get the dimension of the drill dow group

GetCurrentField([drill group name])

to get the number of users

GetSelectedCount(userfield)

or GetPossibleCount(userfield)

it should be (post your doc for more detail), a lot of if/and

if(GetCurrentField([.....])='....' and GetSelectedCount(.....)=1, ........,

if..........