Solved: Print Sheet Button with Selections on bottom - Qlik Community

Anonymous · ‎2015-11-18

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!

Mark_Little · ‎2015-11-18

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

View solution in original post

Report Inappropriate Content · ‎2015-11-18

Hi Pavan,

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

Regards,

Jason.

Anonymous · ‎2015-11-18

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).

marcus_sommer · ‎2015-11-18

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

- Marcus

Anonymous · ‎2015-11-18

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?

Report Inappropriate Content · ‎2015-11-18

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?