How will show/Get only next month data in Pivot table

[sagarpawar]

Hi All,

Please help me on below scenario to achieve expected result.

I need to show only next month data and Month & Year(Ex: sep_19) of next month in Label.

Please find below scenario with example.

EX-1:

Current Result:

A	B	C	D
DEPOT1	DIFF	dec_19	3927
DEPOT1	DIFF	oct_19	1837
DEPOT1	DIFF	sep_19	1053

Expected Result(In pivot table):

A	B	sep_19
DEPOT1	DIFF	1053

EX-2:

A	B	C	D
DEPOT2	DIFF	dec_19	2475
DEPOT2	DIFF	oct_19	5496

Expected result:

A	B	oct_19
DEPOT2	DIFF	5496

Thanks & Regards,

SGP

[rubenmarin · Accepted solution]

Hi, please check attachment.

In summary: you can create a conditonal dimension that filters the month, like:

=Aggr(If(Date=Min(TOTAL <A,B> {<Date={">=$(=Num(Date(Today())))"}>} Date), C), A, B, C)

The italic part only is needed if there can be data of past/current months

[sagarpawar]

HI,

Thanks for help.

I tried using below expression but as I'm new in QlikView not able to implement it properly.

Below I'm providing you my actual column name. Can you please explore the same using real column.

A=DIM_NOMOFF

B=SOURCE

C= MONTH &'_'& Right(YEAR,2)

D=Sum(CA)

Thanks & Regards,

SGP