topic Re: Horizontal Expressions in QlikView

Horizontal Expressions

Anonymous — Fri, 11 May 2018 08:17:49 GMT

Hello,

Since we updated Qlikview 11.20 to Qlikview 12 our Expressions are shown vertically instead of horizontally.

See the screenshot below:

The Actual volumes and Actual Sales should be presented in columns. Dragging is not working.

(Dimensions could also not be dragged above the actuval volumes and actual sales)

It is a pivot table and the expressions for Actual Volume is: =SubStringCount(Concat([*metricsNo], '|'), 'a') .

The presentation settings are presented in the screenshot below:

I have tried almost everything, so any help is appreciated!

Thank you in advance.

Richie

Re: Horizontal Expressions

sunny_talwar — Fri, 11 May 2018 15:30:34 GMT

I think all you need to do is to drag the expression column to the top-right corner so that it becomes horizontal...

Re: Horizontal Expressions

Anonymous — Mon, 14 May 2018 06:27:06 GMT

Thank you for the quick reply.

Unfortunately we tried that a lot of times and is not working.

The dragging funtion (blue arrow) is not working for expressions and neither for dimensions.

Re: Horizontal Expressions

Anonymous — Wed, 16 May 2018 10:52:18 GMT

Hello Richie,

I had the same problem and could not pivot the dimensions. The reason was that there were obsolete dimensions in the Used Dimensions box in the chart properties window.

When I removed these I was able to pivot the table again.

Hope this helps.

Best regards,

Marco

Re: Horizontal Expressions

Anonymous — Fri, 18 May 2018 06:05:59 GMT

Hello Marco,

Thank you for the reply, it also worked for me!