Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Straight table hide/show dimensions and expressions

Hello,

I have a straight table where I have around 5 columns as dimensions (Mainly used for grouping) and then remaining 10 columns as expressions. The reason why I have added those 10 columns as expressions is to workaround the problem of displaying a horizontal scrollbar when the number of dimensions are more (But this is not a concern here now).

My question is, how can I hide/show a dimension or an expression in a straight table that the user does not want to see for the time being but might need to see anytime later he wants. Something like we have in an infragistics datagrid control?

PS: I use QlikView 10

Tags (1)
1 Solution

Accepted Solutions
alexpanjhc
Valued Contributor

Re: Straight table hide/show dimensions and expressions

this is called dynamic reporting. you can check the attached file for reference. check out the reports tab

18 Replies
Not applicable

Re: Straight table hide/show dimensions and expressions

Pardon me.

I'm not using a straight table but a Pivot table (Which enables me to do grouping)

Cheers

giakoum
Honored Contributor II

Re: Straight table hide/show dimensions and expressions

Hi.

you can use conditional show in both dimensions and expressions.

So you can load inline a field with values Show all, Show limited for example, show that field in a list box for the user to select, and use it in the conditional show to control whether to show or not a specific dimesnion or expression.2012-09-20_1130.png

Not applicable

Re: Straight table hide/show dimensions and expressions

I do not find such an option. Please see image.

Also, I do no quite understand what exactly you tried to explain. Im a newbie. Appreiciate if you can be a bit detailed?

PS: I use qlikview v10

giakoum
Honored Contributor II

Re: Straight table hide/show dimensions and expressions

Most likely you ar not using QlikView 11.

In that case you need to add an if statement within the dimesnion / expression which is too much work with so many dimensions and expressions you are having.

I have included a small example on how this can be done, but it will be a pain for you to combine all dimensions and expressions in show conditions. Better upgrade to QlikView 11.

Not applicable

Re: Straight table hide/show dimensions and expressions

Hi,

I have upgraded now to QlikView 11. Can you now please post an example of how to do this please?

krishnacbe
Valued Contributor III

Re: Straight table hide/show dimensions and expressions

Hi

Please find the Attached image to hide a Column in straight table in Qlikivew 11.

Sample.png

Hopes this helps you.

Regards

Krishna

Not applicable

Re: Straight table hide/show dimensions and expressions

Hi Krishna,

This will permanently hide the columns right? What I want is to let users show/hide columns as he wishes.

Cheers

MVP
MVP

Re: Straight table hide/show dimensions and expressions

Hi,

For this you can select the 'Conditional' option below the 'Hide Column'and You can give expression to show/hide Column based on the condition.

Hope this helps you.

Regards,

Jagan.

Not applicable

Re: Straight table hide/show dimensions and expressions

Hi Jagan,

I'm very clear about using the condition option. It would be really helpful as to what comes under the condition if I need to show/hide columns based on user selection of fields from a list box. An example please?

Cheers.

Community Browser