topic Re: Straight table hide/show dimensions and expressions in QlikView

Straight table hide/show dimensions and expressions

Thu, 20 Sep 2012 07:23:23 GMT

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

Re: Straight table hide/show dimensions and expressions

Thu, 20 Sep 2012 08:25:03 GMT

Pardon me.

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

Cheers

Re: Straight table hide/show dimensions and expressions

giakoum — Thu, 20 Sep 2012 08:33:00 GMT

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.

Re: Straight table hide/show dimensions and expressions

Thu, 20 Sep 2012 08:40:32 GMT

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

Re: Straight table hide/show dimensions and expressions

giakoum — Thu, 20 Sep 2012 08:42:56 GMT

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.

Re: Straight table hide/show dimensions and expressions

Fri, 21 Sep 2012 02:00:15 GMT

Hi,

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

Re: Straight table hide/show dimensions and expressions

krishnacbe — Fri, 21 Sep 2012 04:59:21 GMT

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

Hopes this helps you.

Regards

Krishna

Re: Straight table hide/show dimensions and expressions

Fri, 21 Sep 2012 05:20:29 GMT

Hi Krishna,

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

Cheers

Re: Straight table hide/show dimensions and expressions

jagan — Fri, 21 Sep 2012 06:11:21 GMT

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.

Re: Straight table hide/show dimensions and expressions

Fri, 21 Sep 2012 06:13:29 GMT

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.

Re: Straight table hide/show dimensions and expressions

jagan — Fri, 21 Sep 2012 07:18:40 GMT

Hi Ranjit,

Please find attached file for solution. Hope it helps you.

Regards,

Jagan.

Re: Straight table hide/show dimensions and expressions

Fri, 21 Sep 2012 07:57:19 GMT

Perfect. Thanks much Jagan.

Re: Straight table hide/show dimensions and expressions

Fri, 21 Sep 2012 10:04:24 GMT

Hi Jagan,

I just saw your example in more detail. Basically, what I want is slightly different. May be it requires a very small change which Im not familiar.

I load the values of all my fields in a list box using the following inline statement.

Load * inline [

Fields

]

Now, all I want is allow users to select the fields from the listbox and then based on that show/hide those columns in the straight table. I would like to use the conditional checkbox to add this behavior. Can you help with an example?

Cheers

Re: Straight table hide/show dimensions and expressions

krishnacbe — Fri, 21 Sep 2012 10:09:47 GMT

Please change the List box properties as in image.

Result will be as below

Hope this helps you

Regards

Krishna

Re: Straight table hide/show dimensions and expressions

jagan — Fri, 21 Sep 2012 10:14:48 GMT

Hi,

I am not clear what you are asking, Can you attach the sample file, so that it helps in understanding the requirement.

Regards,

Jagan.

Re: Straight table hide/show dimensions and expressions

alexpanjhc — Fri, 21 Sep 2012 13:16:41 GMT

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

Re: Straight table hide/show dimensions and expressions

Mon, 24 Sep 2012 03:54:06 GMT

Great.. This worked.

Thanks

Re: Straight table hide/show dimensions and expressions

Wed, 03 Oct 2012 16:02:35 GMT

This doesn't appear to work real well with larger (ie 2 million records+) on a server deployment. Any suggestions?

Re: Straight table hide/show dimensions and expressions

Wed, 03 Oct 2012 16:04:14 GMT

This doesn't appear to work real well for large datasets (ie over 2M records) on a server deployment. Any suggestions? Thanks, Allan