Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Ranjit,
Please find attached file for solution. Hope it helps you.
Regards,
Jagan.
Perfect. Thanks much Jagan.
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
Hi
Please change the List box properties as in image.
Result will be as below
Hope this helps you
Regards
Krishna
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.
this is called dynamic reporting. you can check the attached file for reference. check out the reports tab
Great.. This worked.
Thanks
This doesn't appear to work real well with larger (ie 2 million records+) on a server deployment. Any suggestions?
This doesn't appear to work real well for large datasets (ie over 2M records) on a server deployment. Any suggestions? Thanks, Allan