Pivot Help

arusanah — Tue, 05 Jul 2016 17:25:43 GMT

Test1:
LOAD

[Person ID],
MONTH,
YEAR,
Date(MonthStart(Date#(MONTH & '-' & YEAR, 'MMM-YYYY')), 'MMM-YYYY') as MonthYear,
[Plan GRP],
//[Plan GRP] as [prev Plan Grp],
[New Enrollment],
Enrollment,
Disenrollment

FROM
[..\Desktop\Test1.xlsx]
(ooxml, embedded labels, table is Sheet3);

FinalTest:

LOAD *,

If([Person ID] = Previous([Person ID]), Previous([Plan GRP])) as [prev Plan Grp]

Resident Test1

Order By [Person ID], MonthYear;

DROP Table Test1;

Pivot Report Expression = =count({$<[Plan GRP]={'A','B','C','D'}>} ([Person ID]))

It does give me output as long as im comparing it with just previous month, but my users want open date selection option.

topic Pivot Help in QlikView

Pivot Help