topic Re: ad-hoc reports in QlikView

ad-hoc reports

Fri, 06 Sep 2013 07:46:56 GMT

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

Re: ad-hoc reports

Fri, 06 Sep 2013 07:57:23 GMT

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

Re: ad-hoc reports

Andrea_Ghirardello — Fri, 06 Sep 2013 08:06:25 GMT

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.

Re: ad-hoc reports

Fri, 06 Sep 2013 08:07:08 GMT

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.

Re: ad-hoc reports

Fri, 06 Sep 2013 08:08:32 GMT

Find attached "Whats New in Qv 11" file.

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

It may help you.

Karthik

Re: ad-hoc reports

Fri, 06 Sep 2013 08:13:42 GMT

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

this is really helpful!

Thanks for the help.