Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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
i think u have to go with adhoc reports,PFA.
there is no need of container, if you want to choose dimensions and metrics:
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.