Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
cbaqir
Valued Contributor

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 & Luminary
MVP & Luminary

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.

View solution in original post

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

cbaqir
Valued Contributor

Re: Portrait View

I'm not sure I understand your comment.

ecolomer
Honored Contributor II

Re: Portrait View

Your solution is a normal solution

cbaqir
Valued Contributor

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

MVP & Luminary
MVP & Luminary

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 & Luminary
MVP & Luminary

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.

View solution in original post