Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

ad-hoc reports

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

1 Solution

Accepted Solutions
Not applicable

Re: ad-hoc reports

Find attached "Whats New in Qv 11" file.

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

It may help you.

Karthik

5 Replies
Not applicable

Re: ad-hoc reports

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

Employee
Employee

Re: ad-hoc reports

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.

Not applicable

Re: ad-hoc reports

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.

Not applicable

Re: ad-hoc reports

Find attached "Whats New in Qv 11" file.

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

It may help you.

Karthik

Not applicable

Re: ad-hoc reports

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

this is really helpful!

Thanks for the help.

Community Browser