Hide Target Based on Drill Though

[#1]

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

[IAMDV]

Please can you post an example? I can try it!

[#3]

Hi,

Example attached.

Thanks

Gillian

[amars]

Couldn't hide the line but hope the attached one will server the purpose.

Thanks

[#5]

Hi

You can try this

=SUM(If(Measure='New Attenders'and count(distinct total (Period)) > 1,Target ,0))

Hope it´s help

Anders

[#6]

Thats great, thanks!

[#7]

Hi,

[#8]

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

[#9]

Hi,

You can follow the file attached with this post.

[#10]

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)