Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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

View solution in original post

5 Replies
Highlighted
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

Highlighted

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.

Highlighted
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.

Highlighted
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

View solution in original post

Highlighted
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.