Repeating Values in a Pivot Chart

[ZoeM]

Hello Qlik Users.

I am trying to repeat a value every month until it is closed. 

In the attached Sample Data, I want to track the stages of the different projects from the start till the Actual End. So if it starts in January and only ends (Actual End) in April, I want it marked in January, February, March and finally in April.

[Blalock69]

---

@ZoeM wrote: PrepaidGiftBalance

Hello Qlik Users.

I am trying to repeat a value every month until it is closed. 

In the attached Sample Data, I want to track the stages of the different projects from the start till the Actual End. So if it starts in January and only ends (Actual End) in April, I want it marked in January, February, March and finally in April.

---

Repeating item and field labels in a PivotTable visually groups rows or columns together to make the data easier to scan. For example, use repeating labels when subtotals are turned off or there are multiple fields for items. In the example shown below, the regions are repeated for each row and the product is repeated for each column.

[vinieme12]

raw:
LOAD
"Project Name",
Stage,
"Project Name" & Stage as keyfield,
"Start",
"Required End",
"Actual End",
alt("Actual End","Required End") as End
FROM [lib://AttachedFiles/Qlik Sample Data.xlsx]
(ooxml, embedded labels, table is Sheet1);

dates:
Load
"Project Name" & Stage as keyfield
,monthstart("Start",iterno()-1) as Months
Resident raw
While monthstart("Start",iterno()-1) <= monthstart(End)
;

Row = Project

Column = Months

MEasure = Concat(Stage,', ' )

Output

[ZoeM]

Thanks Vineeth.

I am looking for a solution that does not require editing the Load Script. All my dates are coming in through a date bridge created in Alteryx.

[vinieme12]

There is no front end only solution for this