topic Re: Set Refrence by button click in QlikView

Set Refrence by button click

Mon, 10 Mar 2014 14:39:31 GMT

Hi All,

This question might be some how funny, but i am having some hopes there will be chance of doing it.

Without using the macro function, can we able to provide "Set Reference" to the bar chart by using BUTTON click ?

I hope my question reached to you all, please let me know if need more briefly .

Thanks in advance.

Re: Set Refrence by button click

Anonymous — Mon, 10 Mar 2014 14:55:42 GMT

Venkat,

I think if you must have a button for this, you have to use a macro.

Regards,

Michael

Re: Set Refrence by button click

Mon, 10 Mar 2014 14:59:14 GMT

Hi Michael,

Thanks for your response on this post.

Will that macro works on all web browser ?

Thanks in advance.

Re: Set Refrence by button click

ThornOfCrowns — Mon, 10 Mar 2014 15:01:22 GMT

Macros / VBA will not work in Webview.

Re: Set Refrence by button click

Anonymous — Mon, 10 Mar 2014 15:04:42 GMT

Don't know, just give it a try. It is a simple macro, no system access required, there are chances it works in IE plugin but not in AJAX.

Re: Set Refrence by button click

ThornOfCrowns — Mon, 10 Mar 2014 15:10:29 GMT

Sorry, Michael, I keep forgetting about the IE plugin! There is a chance it will work, but it's not a given.

Re: Set Refrence by button click

Anonymous — Mon, 10 Mar 2014 15:13:43 GMT

Yes James, I know... Trying to avoid macros, even the simple ones. I wish it was always possible

Worth trying anyway if it's really needed.

Re: Set Refrence by button click

ThornOfCrowns — Mon, 10 Mar 2014 15:15:59 GMT

I think the future QV path is to eradicate VB completely and to 'guide' developers to use QV Triggers etc.

Re: Set Refrence by button click

Tue, 11 Mar 2014 10:59:12 GMT

Hi Michael,

I tried testing through web browser by using the below macros, what i seen there is only by using IEPlugin the "Set Reference" is working fine, for "Full Browser" it is not working.

Sub SetRef

ActiveDocument.GetApplication

set Obj1= ActiveDocument.GetSheetObject("CH01")

Obj1.SetReference

End Sub

Sub ClearRef

ActiveDocument.GetApplication

set Obj1= ActiveDocument.GetSheetObject("CH01")

Obj1.ClearReference

End Sub

Can you please help me out, is there is a chance of getting this feature of "Set Reference" without using the "Set Refrence" property. i.e; like by using the "Alternate State" or some other approach .

Thanks in advance

Re: Set Refrence by button click

Tue, 11 Mar 2014 11:24:11 GMT

HI Venkat,

Right Click on BarChart, Select Set Reference .

Then you can select any analysis on chart, what ever the Selection is done it was Highlighted, others will remains same.

Remember 2 Things: 1) Even If you reload the application SET Reference will Disappear

2) Even If you Close the application SET Reference will Disappear

Regards,

Helen

Re: Set Refrence by button click

Anonymous — Tue, 11 Mar 2014 12:21:43 GMT

This is expected - works in IE plugin but not in AJAX ("full browser"). BTW, there is no "set reference" in AJAX even by the right-click, so helen betty's suggestion also works only in IE Plugin.

As for the other methods, I can't tell from the top of my head. Alternate States - take a look at the "What's new in QV 11".

Regards,

Michael

Re: Set Refrence by button click

Tue, 11 Mar 2014 12:47:47 GMT

Yes i too had noticed in AJAX there is no "Set Reference" by right-click.

I had done other approach to reach same like "Set Reference". Almost it is providing the similar look & feel but it makes some complicated work.

Once i will update the QVW file in this post after finishing.

Thanks

Venkat