I have months in column and data is on part number level, I want to create a stacked bar chart and for that I have to plot each month against part num

[Shreya_11]

Please suggest how can I dot it.

Change the data set from :

Part Name   Dec Plan    Dec Actual   Jan Plan   Jan Actual

X                        True               False              False           False

To this:

Part Name    Month   Status

X                        Dec Plan    True

X                         Dec Actual False

X                       Jan Plan     True

X                       Jan Actual  False

[Steven35 · Accepted solution]

Hey,

You must use the "Crosstable" function : https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/...

Data:
CrossTable(Month, Status, 1)
LOAD * Inline [
Part Name, Dec Plan, Dec Actual, Jan Plan, Jan Actual
X, True, False, False, False
];

(Maybe I misunderstood because in your case a False is transformed into True)

Best regards,

Steven

[Shreya_11 · Accepted solution]

Thanks Steven, this worked for me.