Pivot Chart layout

[#1]

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?

[Anonymous]

Daniel,

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

Hope it helps.

Marc.

[#3]

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.

[rajkumarb]

HI

Suppress when Value is null From Dimensions Tab

Suppress Zero Values in Presentation Tab

[Anonymous]

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

Marc

[#6]

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?

[Anonymous]

Just add it to your data table when load script.

Concatenate (datatablename)

LOAD * INLINE [

    Timing

    Remediation

];

[#8]

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);

[Anonymous]

MyTable:

LOAD Entity,

    Process,

    [Control ID],

    Timing,

    Auditor,

    Status,

    [Control Description]

FROM

(ooxml, embedded labels, table is Sheet1);

Concatenate (MyTable)

LOAD * INLINE [

    Timing

    Remediation

];

[#10]

Very helpful!

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