topic Re: Clicking a particular chart value in QlikView

Clicking a particular chart value

Mon, 05 Oct 2015 20:19:12 GMT

I have a line chart by year and head count based on hire and attrition.when I click on the particular year and hire line it should transfer those values into a next sheet...what I have now it does transfer the year but the hire number based...wrote a script to trigger the sheet...

sub NxtSht
set val=ActiveDocument.Fields("Years").GetPossibleValues
Set var = ActiveDocument.GetVariable("vList")
if val.Count = 1 then
for i=0 to val.Count-1
var.SetContent val.Item(i).Text, True
ActiveDocument.ActivateSheetByID "SH08"
next
end if

End sub

the current chart is attached...if I click on 2011 and 1447 (term) then it should transfer the year and term(it is a calculated value) to the next sheet..

It has become a challenge...any help would be appreciated...

Re: Clicking a particular chart value

Mon, 05 Oct 2015 22:07:08 GMT

Updated the chart to get it better...still not able to transmit particular values... !

Re: Clicking a particular chart value

Tue, 06 Oct 2015 13:18:42 GMT

I need to capture legend values and transfer that into a another chart....

Re: Clicking a particular chart value

Tue, 13 Oct 2015 22:49:18 GMT

hid a textobject and transparency to 100%..it works