topic Layout Design in QlikView

Layout Design

santharubban — Tue, 04 Mar 2014 16:49:09 GMT

Hi All,

Can anyone help me in attached layout design.

how to design the table as same as in image?

Re: Layout Design

chiru_thota — Tue, 04 Mar 2014 17:21:10 GMT

It is not possible to get entire report using one chart as you have different metrics.

you need to use two charts side by side.

one pivot table for Total Services and second report for the remaining.

Bottom part can be done using text objects.

Re: Layout Design

Tue, 04 Mar 2014 17:34:32 GMT

you can try something like the example attached

regards

Re: Layout Design

jaimeaguilar — Tue, 04 Mar 2014 17:38:30 GMT

Hi,

Just by seeing the image, it may be possible to get that design, but you'll need to use some tricks (like pick(match()) and use a pivot table. However is hard to tell you the steps to follow without seeing a sample of your data. Could you upload a sample of your qvw please?

regards

Re: Re: Layout Design

Tue, 04 Mar 2014 17:42:55 GMT

also to color cell you can do this

Re: Layout Design

santharubban — Tue, 04 Mar 2014 17:52:11 GMT

Thanks all.

Jaime Aguilar,

Just now i got requirement yet to build the QWV. If you have time can please help in the steps to design the same.

Re: Layout Design

Tue, 04 Mar 2014 17:58:52 GMT

Can you attach a sample app. I believe pivot table will be a best fit for it.

Re: Layout Design

jaimeaguilar — Tue, 04 Mar 2014 18:49:19 GMT

Hi,

maybe something like the attached example. However depending on your datasources, I think it will be necessary to make some modifications,

regards

Re: Layout Design

santharubban — Fri, 07 Mar 2014 16:50:54 GMT

Hi Jaime,

Thanks for give a idea.

But it didn't help me, In total service ve have 5 columns and other ve have 3 columns and bottom its a separete expression.

can any one help me in this design.