topic Re: Print Sheet Button with Selections on bottom in QlikView

Print Sheet Button with Selections on bottom

Anonymous — Wed, 18 Nov 2015 15:13:44 GMT

Hi All

I am trying to create a print option for the user to print the sheet with the selections listed on the bottom. The print option in individual charts lists the selections under the chart. I can set a button to Print Sheet which will print the whole sheet. I would like to combine those features so that when they print the sheet the selections will show.

Thanks!

Re: Print Sheet Button with Selections on bottom

Wed, 18 Nov 2015 15:59:36 GMT

Hi Pavan,

Sorry, I may be over-simplifying, but would including a Current Selections box on the sheet resolve this?

Regards,

Jason.

Re: Print Sheet Button with Selections on bottom

Anonymous — Wed, 18 Nov 2015 16:07:31 GMT

I didnt want to have a current selections box on the sheet. Maybe if i could have a conditional option to show the current selections box when printing only, i would not mind that, but i dont know how to set the conditional to display when printing only (if this is even possible).

Re: Print Sheet Button with Selections on bottom

marcus_sommer — Wed, 18 Nov 2015 16:15:15 GMT

You could try it with getcurrentselections() within a textbox.

- Marcus

Re: Print Sheet Button with Selections on bottom

Anonymous — Wed, 18 Nov 2015 16:17:23 GMT

Is there a way to put a conditional for a textbox to only show when printing? i created a button which does Print Sheet. Is there a way to set a conditional to show when a user clicks that button and hide once its printed?

Re: Print Sheet Button with Selections on bottom

Wed, 18 Nov 2015 16:31:55 GMT

Thanks,

Afraid I am not certain on that one, however...instead of the button printing the screen could the button print a PDF report from Report Editor…you could then include things on this that were not necessarily on screen (i.e. from hidden tabs)? Suspect this might be getting unnecessarily complicated though?

Regards,

Jason.

Re: Print Sheet Button with Selections on bottom

Mark_Little — Wed, 18 Nov 2015 16:49:41 GMT

You would have to test it, but you could you not just have a variable vShowOnPrint, this holds a flag 1 or 0.

On the current Selection box or Text box, in the layout tab in condition vShowOnPrint = 1

Then on you print button

Add action to set variable to 1

'Other actions'

....

Add action to set variable to 0

You would need to test this works, or simply have a toggle button to turn on the Current selections then print?

Mark

Re: Print Sheet Button with Selections on bottom

Anonymous — Wed, 18 Nov 2015 16:53:50 GMT

I think this works! I tested it out quickly and it seems to do what i want. Thank you everyone for your help.