topic Re: Sheet and Document Layout in QlikView

Sheet and Document Layout

alec1982 — Tue, 12 Jun 2012 13:13:26 GMT

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

Re: Sheet and Document Layout

Anonymous — Tue, 12 Jun 2012 13:22:18 GMT

Use visual cues like the size, shape, position, color, etc. along with consistency of your sheet objects to define what will look like 3 sections (Columns). Its not quite the same as doing, say Web Design where you create 'place holders' as positions, so you have to do a semi slide of hand to make it appear with as though it is in effect.

Hope that helps.

Re: Sheet and Document Layout

alec1982 — Tue, 12 Jun 2012 13:25:11 GMT

Thxs,

May you please explain how to use it.

Re: Sheet and Document Layout

alec1982 — Tue, 12 Jun 2012 13:27:29 GMT

And also how can I change the dimenssion of a qlikview document?

Thxs

Re: Sheet and Document Layout

Anonymous — Tue, 12 Jun 2012 14:01:08 GMT

I put a qvw file that is a crude demonstration of how to set up place holders for visual cues by manipulating sheet properties and objects. You just need to basically adjust the 'General' and 'Layout' tabs in the properties of the sheet and/or object to achieve what you are trying to do. If you don't know how to manipulate all the different aspects of those settings, I'd suggest either looking at the tutorial/training videos that Qlikview has made public and/or just look at the relevant areas in the Reference Manual - also, the 'Help' button is a great resource if you don't recognize something.

You will have to expand on the "dimension of a qlikview document" because I'm not clear as to what you are referring.

Hope that helps.

Re: Sheet and Document Layout

Tue, 12 Jun 2012 15:03:12 GMT

Hey autopilot,

I have exactly the same requirement. I want a template wich should be divided into three parts : left side for filters, center for charts and objects and top for tabs. I am unable to open your qvw file as I am using a personal edition. Is there any other way I can see the file other than the repair option. Or can you provide me a source where I can read stuff abou this.

thanks.

Re: Sheet and Document Layout

alec1982 — Tue, 12 Jun 2012 15:28:33 GMT

The sample looks great.

How can I determine if my dashboard will fit into I pad?

What are the dimenssions I should have and where could I set them.

Thanks for your help

Re: Sheet and Document Layout

alec1982 — Tue, 12 Jun 2012 15:41:46 GMT

I just found some image samples that can be used to split the layout

C:\Program Files\QlikView\Examples\Developer Toolkit\backgrounds\with panels

I guess that would help.

Re: Sheet and Document Layout

Anonymous — Tue, 12 Jun 2012 15:48:44 GMT

In regards to setting the dimensions on the development for the ipad, I'd use the same approach.

Meaning, I'd do trial and error with the layout of the 'frames' (or look up something comparable) until you know at what point the ipad will cut off the field of view.

By doing that, you can then size your 'frames' accordingly so that you know in development with your objects, etc. not to exceed that line/color which you setup as a visual cue of your maximum limit i.e. dimension.

Re: Sheet and Document Layout

Anonymous — Tue, 12 Jun 2012 15:53:03 GMT

udayshankark,

while i know that there are a lot of resources out there generally, i don't know off hand which best to point you.

But, I can take a screen shot of the images of the two sheets in the qvw file and post them if you think that would help. There is no script so you wouldn't be missing anything there, but the only place that would suffer slightly is the simple ability to explore the properties settings of the objects. I summarized them in screen shots on the second sheet of the two, so if you are okay with that then I'd be glad to post them.

Re: Sheet and Document Layout

Tue, 12 Jun 2012 15:54:42 GMT

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!

Re: Sheet and Document Layout

Tue, 12 Jun 2012 15:56:53 GMT

Autopilot,

Yeah,please do share the screen shots.

Re: Sheet and Document Layout

MayilVahanan — Tue, 12 Jun 2012 16:05:24 GMT

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

Re: Sheet and Document Layout

Anonymous — Tue, 12 Jun 2012 16:14:26 GMT

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.

Re: Sheet and Document Layout

Anonymous — Tue, 12 Jun 2012 16:16:26 GMT

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

Re: Sheet and Document Layout

Anonymous — Tue, 12 Jun 2012 16:20:18 GMT

Here are the screenshots.

Re: Sheet and Document Layout

Anonymous — Tue, 12 Jun 2012 16:21:24 GMT

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

Re: Sheet and Document Layout

Anonymous — Tue, 12 Jun 2012 16:21:59 GMT

Last one.

Re: Sheet and Document Layout

Tue, 12 Jun 2012 16:56:32 GMT

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!

Re: Sheet and Document Layout

Anonymous — Tue, 12 Jun 2012 16:59:31 GMT

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.