topic Re: Container or Grouping for Multiple Selection Tabs in QlikView

Container or Grouping for Multiple Selection Tabs

Mon, 27 Apr 2015 16:14:57 GMT

Hello,

I am new to Qlikview and I have been going through some tutorials so far. I am trying to figure out:

How to create a table in QlikView that the user can select which dimensions are included in the table.

For example:

If we have a list like:
- Customer Number
- Month
- Year
I want to be able to select which dimensions to include in the table
- Maybe just Customer Number
- Maybe Customer Number and Month
- Maybe all three or any combination

So far I could only find grouping and container as closest solution but it only allows to show one at a time (container's grid option doesn't give option to de-select tables that I dont want -it just includes all tables )

Below in the single object example for container - i can only select at one time. If i want to see year and month at the same time (but i dont want to see division and customer number) there is no way

I also tried grouping (cycle) and it also just gives me to select only 1 tab at a time.

Is there any way ?

Thanks

Arman

Re: Container or Grouping for Multiple Selection Tabs

buzzy996 — Mon, 27 Apr 2015 16:53:41 GMT

i think u have to go with adhoc reports,PFA.

Adhoc reporting in Qlikview

Re: Container or Grouping for Multiple Selection Tabs

maxgro — Mon, 27 Apr 2015 17:38:32 GMT

there is no need of container, if you want to choose dimensions and metrics:

Customizable Straight Table

Re: Container or Grouping for Multiple Selection Tabs

richbyard — Mon, 27 Apr 2015 17:50:15 GMT

The adhoc report is probably the nicest solution from a development perspective as you can change the measures that are presented.

However, if you want to keep it simple you also have the option of a pivot table with multiple cycle groups as dimensions. If all of your possible dimension fields are included in each of the (for example) 3 cycle groups then you can pick and choose how many are presented by collapsing the 3rd and 2nd group as required. This is a reasonably quick and easy way for users to have a chart (with fixed measure fields) that they can adapt easily.

Very basic example attached for you to see how it's set up... super simple to build and to use.