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?
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.