topic Hide Target Based on Drill Though in QlikView

Hide Target Based on Drill Though

Fri, 04 Mar 2011 11:48:35 GMT

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

Hide Target Based on Drill Though

IAMDV — Fri, 04 Mar 2011 11:50:36 GMT

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

Hide Target Based on Drill Though

Fri, 04 Mar 2011 12:23:21 GMT

Hi,

Example attached.

Thanks

Gillian

Hide Target Based on Drill Though

amars — Fri, 04 Mar 2011 12:39:51 GMT

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

Thanks

Hide Target Based on Drill Though

Fri, 04 Mar 2011 12:51:33 GMT

You can try this

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

Hope it´s help

Anders

Hide Target Based on Drill Though

Fri, 04 Mar 2011 13:00:32 GMT

Thats great, thanks!

Hide Target Based on Drill Though

Tue, 08 Mar 2011 10:36:48 GMT

Hi,

Hide Target Based on Drill Though

Tue, 08 Mar 2011 10:42:31 GMT

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

Hide Target Based on Drill Though

Tue, 08 Mar 2011 11:00:32 GMT

Hi,

You can follow the file attached with this post.

Hide Target Based on Drill Though

Tue, 08 Mar 2011 11:12:07 GMT

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)

Hide Target Based on Drill Though

Tue, 08 Mar 2011 11:22:33 GMT

The field GradeOfStaff is not in the example you posted before.

Can you post a new example?

Regards

Anders

Hide Target Based on Drill Though

Tue, 08 Mar 2011 12:29:21 GMT

Hi Guys,

I have solved the problem, it was with my underlying data and the way Qlikview was linking the fields together.

Both of these work

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

=if(getcurrentfield(Drill)='Period', SUM(If(Measure='New Attenders' and GradeOfStaff ='All',Target,0)))

Thanks for all your help!

Gillian