topic Re: Pivot Chart layout in QlikView

Pivot Chart layout

Thu, 22 Jan 2015 16:38:17 GMT

I am working to create a pivot chart. I do not currently have data in the "Remediation" columns, but I would like to always display them. How can i change this to not use dummy data and not show the "0"s at the bottom?

Re: Pivot Chart layout

Anonymous — Thu, 22 Jan 2015 16:43:00 GMT

Daniel,

Just check "Show all values" in dimensions tab, and uncheck "Supress zero values" in presentation tab.

Hope it helps.

Marc.

Re: Pivot Chart layout

Thu, 22 Jan 2015 16:46:12 GMT

When I do this (since I don't have data under "Remediation"), only the Interim and RF/Annual columns appear. I"m currently adding extra rows in my source data to tell Qlik that i want this "remediation" column to appear.

Re: Pivot Chart layout

rajkumarb — Thu, 22 Jan 2015 16:46:26 GMT

Suppress when Value is null From Dimensions Tab

Suppress Zero Values in Presentation Tab

Re: Pivot Chart layout

Anonymous — Thu, 22 Jan 2015 16:48:57 GMT

Also uncheck "Supress when value is null" in dimensions tab.

Marc

Re: Pivot Chart layout

Thu, 22 Jan 2015 16:53:44 GMT

Here is my source data (1 row):

Under timing, I do not have any rows with "remediation". How can I always have pivot fields when they are not included in the source data?

Re: Pivot Chart layout

Anonymous — Thu, 22 Jan 2015 16:59:56 GMT

Just add it to your data table when load script.

Concatenate (datatablename)

LOAD * INLINE [

Timing

Remediation

];

Re: Pivot Chart layout

Thu, 22 Jan 2015 17:05:23 GMT

How can I add that to my current load script?

LOAD Entity,

Process,

[Control ID],

Timing,

Auditor,

Status,

[Control Description]

FROM

(ooxml, embedded labels, table is Sheet1);

Re: Pivot Chart layout

Anonymous — Thu, 22 Jan 2015 17:08:38 GMT

MyTable:

LOAD Entity,

Process,

[Control ID],

Timing,

Auditor,

Status,

[Control Description]

FROM

(ooxml, embedded labels, table is Sheet1);

Concatenate (MyTable)

LOAD * INLINE [

Timing

Remediation

];

Re: Pivot Chart layout

Thu, 22 Jan 2015 17:13:03 GMT

Very helpful!

Now, how can I include the 'Status' of Not Initiated, In Progress, and Finished under the 'Remediation' timing?

Re: Pivot Chart layout

Thu, 22 Jan 2015 17:18:05 GMT

Here's my end goal, to be able to show all timings and status with no data.