Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an issue with drill through that I can't figure out, well not even sure if its possible!
I have a drill though combo graph by month with a monthly target. When I drill through to see each day within the month I want to remove / disable the target - is this possible?
Thanks in advance
Gillian
Please can you post an example? I can try it!
Hi,
Example attached.
Thanks
Gillian
Couldn't hide the line but hope the attached one will server the purpose.
Thanks
Hi
You can try this
=SUM(If(Measure='New Attenders'and count(distinct total (Period)) > 1,Target ,0))
Hope it´s help
Anders
Thats great, thanks!
Hi,
I have had to add in another 'And' statement to you suggested statement because of changes to my target look up table, this is what i have now
=SUM(If(Measure='New Attenders'And GradeOfStaff='All' and count(distinct total (Period)) > 1,Target ,0))
but it removes the line from the graph - can you help?
Thanks
Hi,
You can follow the file attached with this post.
Hi,
I follow the example, but still the target line is not on the graph - and even if I go back to what i had originally the line isn't there....very confusing! (if you hadn't gathered, i'm new to Qlikview)