Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

cbaqirdhds
Contributor II

Portrait View

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?

8-10-2015 1-13-49 PM.gif

1 Solution

Accepted Solutions
MVP
MVP

Re: Portrait View

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.

7 Replies
ecolomer
Honored Contributor II

Re: Portrait View

This is the normal form.

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

cbaqirdhds
Contributor II

Re: Portrait View

I'm not sure I understand your comment.

ecolomer
Honored Contributor II

Re: Portrait View

Your solution is a normal solution

cbaqirdhds
Contributor II

Re: Portrait View

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?

ecolomer
Honored Contributor II

Re: Portrait View

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

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

MVP
MVP

Re: Portrait View

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.

Community Browser