topic Re: Chart Layout in QlikView

Chart Layout

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

I am working with 3 fields, ID, DATE and A COUNT DIMENSION.

ID and Date are both dimensions as IDs have multiple dates.

The Dimension is a count of another field.

Is there anyway to set the table up on QLIK so it would look like below? (Similar to how you can work with a pivot table on excel

With X being the returned Count Expression values.

Currently the chart looks like this:

I've tried the horizontal function on the presentation tab but this is not the answer.

krishnacbe — Thu, 08 Sep 2016 16:44:31 GMT

Hi,

Create a Pivot Table and move the Date column to Horizontal Tab heading.

sunny_talwar — Thu, 08 Sep 2016 16:46:13 GMT

May be use Pivot table here and pivot the Date dimension:

krishnacbe — Thu, 08 Sep 2016 16:48:33 GMT

Please refer the attached qvw.

Anonymous — Thu, 08 Sep 2016 16:55:49 GMT

Hi Tim,

Select pivot table under charts

then click and drag the column name to the side until you see the arrow as below

Hope it helps,

Fernando

Anonymous — Fri, 09 Sep 2016 08:50:09 GMT

Perfect - Thank you