Sheet and Document Layout

[alec1982]

Hi,

I am trying to devide my QlikView Document into 3 sections(Columns) so I can use the left side for filtering and the other two sections to the right for showing charts and objects.

Not sure how to do that

I appreciate any help.

Thxs

[#2]

Autopilot and alec,

I have to create a page with filters on the left side and on the right side there should be a table kind of thing, the values in this table should change based on the selection in the filters.

Issue : If say I select a category item and it has 4 sub categories , the table on the right should show 4 rows and if the category has 3 items it should 3 rows. How do I dynamically create the table based on the selection in the filter?

Can you guys help in this?

Thanks!

[#3]

Autopilot,

Yeah,please do share the screen shots.

[MayilVahanan]

hi,

     Try this,

     Use table box, and give dimension as Category and Sub category. it automatically show the result based on selection in  filter.

Hope it helps

[Anonymous]

This should create two displays of the relating fields and their values, and the steps below should ensure a dynamic display of the presented data.

It is contingent on the valid assocation between the two tables or fields in your data model.

Create two list boxes.

In the first list box, use the field "Categories"

     - on the general tab, set to 'Always One Selected Value'

In the second list box, use the field "Subcategories"

     - on the general tab, set to 'Hide Excluded'

Hope that helps.

[Anonymous]

I just tested mayilvahanan's suggested approach and I much prefer the ease of setup / the look to my suggestion.

[Anonymous]

Here are the screenshots.

[Anonymous]

Sorry, first upload post of screenshots didn't take all the images.

[Anonymous]

Last one.

[#10]

Hi mayilvahan/autopilot,

can you please describe it a little more(step by step)?

I created a table box..but I did not understand where to add the dimension as category and subcategory....(attached is the scren shot where I am stuck)

sorry for asking basic questions, I just started using the tool and trying to get used to the tool ..

Thanks!

[Anonymous]

Based on the screen shot, you're done. Click 'Ok'.

In the list box object which should be using the field "category" (assuming that the data is associated at the script level), everytime that you  click a category it should adjust your table box appropriately.