topic Re: Pivot Table with selection buttons in QlikView

Pivot Table with selection buttons

helen_pip — Tue, 12 Mar 2013 13:28:52 GMT

Hello

I have a pivot table which has a list box called Data Source which will allow the user to choose between Inpatients and Outpatients

However, what I want is 3 buttons across the top so the user can click on a button called -Total(Shows all)

-Inpatients (Shows just inpatients)

-Outpatients (Shows just Outpatients)

Can anyone help me achieve this

Kind Regards

Helen

Re: Pivot Table with selection buttons

udit_kumar_sana — Tue, 12 Mar 2013 14:00:46 GMT

Hi,

Please find here the attached file for your issue

Re: Pivot Table with selection buttons

helen_pip — Wed, 13 Mar 2013 08:48:14 GMT

Hello

Thank you for your reply.....I have copied your technique in a new document by creating 3 buttons, with an action of Apply Bookmark and have added 3 document bookmarks in the menu and assigned these bookmarks to the buttons

I do not know whether I am missing a step, as the buttons in my new document do not seem to be working

So apart from Adding Bookmarks, creating buttons and assigning these bookmarks to the buttons.....Have I missed anything out?

Thanks

Helen

Re: Pivot Table with selection buttons

udit_kumar_sana — Wed, 13 Mar 2013 09:19:09 GMT

Hi,

Please share the new document you have created.

Apart from this you can assign buttons with clear action also ,so that when you click next button the previous selections get cleared.

Regards,

Udit