Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

18 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi Ranjit,

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

Regards,

Jagan.

Not applicable
Author

Perfect. Thanks much Jagan.

Not applicable
Author

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

          A

          B

          C

          D

]

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

krishnacbe
Partner - Specialist III
Partner - Specialist III

Hi

Please change the List box properties as in image.

test1.JPG

Result will be  as below

test2.JPG

Hope this helps you

Regards

Krishna

jagan
Luminary Alumni
Luminary Alumni

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.

alexpanjhc
Specialist
Specialist

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

Not applicable
Author

Great.. This worked.

Thanks

Not applicable
Author

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

Not applicable
Author

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