topic Re: Repeating Values in a Pivot Chart in QlikView

Repeating Values in a Pivot Chart

ZoeM — Wed, 13 Apr 2022 17:15:16 GMT

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.

Re: Repeating Values in a Pivot Chart

Blalock69 — Fri, 15 Apr 2022 04:54:43 GMT

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

Re: Repeating Values in a Pivot Chart

vinieme12 — Tue, 19 Apr 2022 11:08:37 GMT

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

Re: Repeating Values in a Pivot Chart

ZoeM — Wed, 20 Apr 2022 15:23:12 GMT

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.

Re: Repeating Values in a Pivot Chart

vinieme12 — Thu, 21 Apr 2022 00:48:39 GMT

There is no front end only solution for this