ad-hoc reports

[#1]

hi,

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?

Thanks

[#2]

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.

Regards,

Gerrit

[Andrea_Ghirardello]

Sure.

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.

[#4]

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.

[#5 · Accepted solution]

Find attached "Whats New in Qv 11" file.

There in "Report" sheet you can find same solution.

It may help you.

Karthik

[#6]

cheers guys. I didnt realise there was a file to go with the online demo.

this is really helpful!

Thanks for the help.