Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
MVP
MVP

Re: Using varying reference lines with different levels of a drill down

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..........