Solved: Straight table hide/show dimensions and expression... - Qlik Community

Report Inappropriate Content · ‎2012-09-20

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

alexpanjhc · ‎2012-09-21

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

View solution in original post

Report Inappropriate Content · ‎2012-09-20

Pardon me.

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

Cheers

giakoum · ‎2012-09-20

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.

Report Inappropriate Content · ‎2012-09-20

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 · ‎2012-09-20

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.

Report Inappropriate Content · ‎2012-09-20

Hi,

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

krishnacbe · ‎2012-09-21

Hi

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

Hopes this helps you.

Regards

Krishna

Report Inappropriate Content · ‎2012-09-21

Hi Krishna,

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

Cheers

jagan · ‎2012-09-21

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.

Report Inappropriate Content · ‎2012-09-21

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.

Straight table hide/show dimensions and expressions