topic Re: Clicking On Single Line in Line Graph & New Chart (Graph or Pivot Table) in QlikView

Clicking On Single Line in Line Graph & New Chart (Graph or Pivot Table)

Tue, 22 Jan 2013 22:39:09 GMT

All

I have a graph ( see example) where I have the OT% by Payperiod by VP. I am trying to see if I can click on one single VP line within the graph and it will automatically launch a new line chart or pivot table that I have created within the sheet/tab. I am aware of the use of " auto minimize" , but boss wants it as easy as he can for the VP sort drilling down - ie click down one leven - ie click again and down even deeper.

An assistance would be greatly appreciated.

Ps Does anyone know how to change the color of the title line of a object ie chart or list box?

Thanks again

Tim

Re: Clicking On Single Line in Line Graph & New Chart (Graph or Pivot Table)

MayilVahanan — Tue, 22 Jan 2013 22:49:33 GMT

As per my understanding, you can do like this

1. For select the line in chart for a Vp, you want to display the another chart? if so,

create a line chart/pivot table and its properties->layout->Conditional

= if(GetSelectedCount(VP)>0,1,0)

2. Color for title

Properties->caption-> text color in either active/inactive caption

Additional info, for font style/size - caption->font

hope it helps

Re: Clicking On Single Line in Line Graph & New Chart (Graph or Pivot Table)

Wed, 23 Jan 2013 21:20:16 GMT

Thanks so much, I really appreciate it.

Re: Clicking On Single Line in Line Graph & New Chart (Graph or Pivot Table)

Thu, 24 Jan 2013 16:09:39 GMT

Mayil

When you use this condition, the initial line graph is blank as the count is 0 and so you are really unable to select a graph.

Thanks

Tim