Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a table of 100 hundred columns and I dont want to to display all of them all the time. I know there is a way of creating a table consisting of only the columns you select from a menu. How do I create this?
Go to Solution.
Find attached "Whats New in Qv 11" file.
There in "Report" sheet you can find same solution.
It may help you.
A table box is a simple way of showing a table.
You can easily hide or show columns.
A chart with a Straight Table type is also an option.
Maybe this answers your question.
You can use conditional dimensions/expressions.
You can learn more about "Conditional" feature (available since QlikView 11) in the "Whats New in QlikView11.qvw" sample document (see "Report" tab).
This feature allows you to show a chart containing only dimensions and expressions according with specific selections in a listbox.
Sorry maybe I didnt have enough of an explaination there.
If you have a look at the "whats new to qlikview 11 demo" online, in the reports tab there is an example of what i am trying to create.
There is a list of dimensions for the user to pick and a table (probably a chart) that gets generated when a dimension is picked.
cheers guys. I didnt realise there was a file to go with the online demo.
this is really helpful!
Thanks for the help.