topic Re: Minimized Object in QlikView

Minimized Object

nihhalmca — Tue, 28 Jan 2014 10:51:31 GMT

Hi All,

I want to minimize chart object even though if user double click on object it will not maximize. I tried through properties--> Caption--> unchecked 'Allow maximized' option. But not working this way, please share if you know.

Thanks in Advance,

Nihhal.

Re: Minimized Object

stevedark — Tue, 28 Jan 2014 11:09:40 GMT

What reason do you wan to keep the chart minmized for for?

If it is so the chart can be used in a report or something I would add a new tab for this chart, and any other objects for reports, and then set the show condition on that tab to false (or have a variable so you can toggle the show of this).

If it is so you can view the text in the caption of the chart, just use a text box instead.

Hope that helps,

Steve

Re: Minimized Object

arulsettu — Tue, 28 Jan 2014 11:25:26 GMT

check if auto minimize is enabled? i think...

Re: Minimized Object

nihhalmca — Tue, 28 Jan 2014 11:28:41 GMT

Hi Steve, Thanks for your reply

Actually my requirement is, i want to make a chart for just send to excel data (not Macro) will not show object in sheet.

Re: Minimized Object

nihhalmca — Tue, 28 Jan 2014 11:29:39 GMT

HI Arul,

No I checked.

Re: Minimized Object

Tue, 28 Jan 2014 11:32:59 GMT

Hi Nihal,

Unfortunatelly its not possible, instead you try to use condition to show or hide the object.

thanks,
Selva

Re: Minimized Object

Tue, 28 Jan 2014 11:34:52 GMT

Then You try serverside export using macro..

sub Export

set ch=ActiveDocument.GetSheetObject("CH706")

ch.ServerSideExportEx "C:\ChartExport.xls",";",5

end Sub

Add the Macro trigger action in a text box or Button..

Note: exported Excel will be available only in the server machine..may be you can create the shared folder in the server machine and distribute it accordingly...

Thanks,

Selva

Re: Minimized Object

stevedark — Tue, 28 Jan 2014 11:42:07 GMT

In that case, what you should do is create a new tab and move the chart to that tab. You can then set the show condition on that tab to False (1=0), but still refer to it in your export code.

If you are presently getting the user to right click on the minimised icon, you will need to replace this with a button (or text box) with an Action to do the export.

To make it so that you can get to the hidden sheet to make changes either use Ctrl+Shift+S or use a variable (I use vShowDev) and set that to either 1 or 0 and set the show condition to:

=vShowDev = 1

Hope that helps,

Steve

Re: Minimized Object

Tue, 28 Jan 2014 11:42:52 GMT

Hi,

U can try changing X-pos, Y-pos , height ,width so that the object size reduces to the size of minimized object.

This does not maximize object even after double click.

HTH

-Shruti

Re: Minimized Object

Tue, 28 Jan 2014 11:55:38 GMT

Hi Nihhal,

Please check if this meets your requirement

Thank you

Vardhan

Re: Minimized Object

nihhalmca — Tue, 28 Jan 2014 13:13:41 GMT

Hi Steve,

I think you talking about Export action, i tried but we can not export data in xls(to excel) format.

Re: Minimized Object

nihhalmca — Tue, 28 Jan 2014 13:18:24 GMT

Hi Vardhan, Thanks for reply

My Chart contains many fields so it is not possible more ever in Straight/Pivot charts can not do like your example (In your attached you have taken table box).

Thanks,

Nihhal.

Re: Minimized Object

nihhalmca — Tue, 28 Jan 2014 13:20:26 GMT

Hi Shruti, Thanks for your reply

My Chart contains many fields so it is not possible (can not make small as i expected)

Thanks,

Nihhal.

Re: Minimized Object

stevedark — Tue, 28 Jan 2014 13:25:57 GMT

I think you may well be limited to using a Macro then - so that you can attach this to an Action on a Text Box or Button.

Is there a reason why you can not show the user the information they are about to export? You can then have the XL icon in the caption too - which is more intuitive that the right click menu with Send To Excel half way down the list.

- Steve

Re: Minimized Object

MayilVahanan — Tue, 28 Jan 2014 20:04:29 GMT

Hide the object n export the excel using button via macro. But note that, macro not work in web without ajax client. In macro, u can set format as u like.