topic Re: Add Listbox to Excel sheet in Qlik NPrinting

Add Listbox to Excel sheet

QFanatic — Tue, 17 Mar 2020 20:40:38 GMT

hi guys

how do I "recreate" a listbox on Nprinting - i.e. I want the user to be able to select a year, and the rest of the Object refreshes to that year?

Note that the year contains multiple values, that come from my model (e.g. 2018,2019) etc. I originally included year as one of my fields in the pivot, and then make that field a filter, but it;s not behaving like I expect it to.

Thanx

Re: Add Listbox to Excel sheet

Ruggero_Piccoli — Wed, 11 Dec 2019 11:19:45 GMT

Hi,

You need to use native Excel features. For example, you can create an Excel template with a native Excel Table or Pivot Table and the recipient will be able to use Excel filtering features.

Best Regards,

Ruggero

Re: Add Listbox to Excel sheet

Lech_Miszkiewicz — Fri, 13 Dec 2019 01:31:53 GMT

Totaly agree with @Ruggero_Piccoli

On top what he said you can create slicers, lists - but this is all MsExcel functionality.