topic Re: Portrait View in QlikView

Portrait View

cbaqir — Mon, 10 Aug 2015 20:17:31 GMT

I have a need to display details at a very granular level (Project) in a portrait orientation similar to the following image. Other than manually creating text fields for labels and then the data, is there any other way to achieve this type of view?

Re: Portrait View

ecolomer — Tue, 11 Aug 2015 02:53:18 GMT

This is the normal form.

You can also write text in a excel file to read later

Re: Portrait View

cbaqir — Tue, 11 Aug 2015 14:39:48 GMT

I'm not sure I understand your comment.

Re: Portrait View

ecolomer — Tue, 11 Aug 2015 14:43:37 GMT

Your solution is a normal solution

Re: Portrait View

cbaqir — Tue, 11 Aug 2015 15:14:26 GMT

I'm asking for a solution. I need to replicate a view like in the image and I am asking how to do it other than using a bunch of text boxes?

Re: Portrait View

ecolomer — Tue, 11 Aug 2015 15:17:00 GMT

You can write the text on a excel and read later them. Ther isn't any other form at least I know

Re: Portrait View

marcus_sommer — Tue, 11 Aug 2015 15:17:56 GMT

Maybe in this way that you load your content quite similar to your screenshot as table with spaces for empty rows and an additional column to differentiate text and expressions (which are part of the table). And then you could use a chart with one dimension (your left column) and an expression like: if(type = 'text', Text, $(=Text)) as your right column.

It's not easy and you will need some attempts but it should work.

- Marcus

Re: Portrait View

jagan — Tue, 11 Aug 2015 15:38:45 GMT

Hi,

Try like this

Chart : Pivot Table

Expression 1 Caption: Project Name

Expression 1: Only(ProjectName)

Expression 2 Caption: Project Description

Expression 2: Only(ProjectDescription)

Now finally drag the Expressions as rows.

Hope this helps you.

Regards,

Jagan.