topic Re: Buttons reflect sheet objects dynamically in QlikView

Buttons reflect sheet objects dynamically

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

We are having 3 fileds namely Supplier,Country and Customer and we have few charts in sheet.

The user needs 3 buttons namely Supplier,Country and Customer.

Here If the user clicks on supplier the whole data in the sheet should aggregate by supplier accordingly.

Thanks..

sasikanth — Fri, 19 Jan 2018 07:26:25 GMT

HI Naresh,

It always depends on the display of data i.e. granularity of your data.

please do elaborate your requirement.

shiveshsingh — Fri, 19 Jan 2018 07:45:43 GMT

If Supplier,Country and Customer are dimensions?

You can use adhoc reports concept to get your goal.

Ben_P — Fri, 19 Jan 2018 13:06:48 GMT

The easiest way to do this is to create a cyclic group for those dimensions, so that the user can switch between them at will.

Settings>Document Properties>Groups>New>Cyclic Group ... and add your dimensions to the group.

You can then use this cyclic group as the dimension in your charts and tables.