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

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

sagarpawar — Sat, 16 Nov 2024 02:37:01 GMT

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:

Expected Result(In pivot table):

A	B	sep_19
DEPOT1	DIFF	1053

EX-2:

Expected result:

A	B	oct_19
DEPOT2	DIFF	5496

Thanks & Regards,

SGP

rubenmarin — Wed, 28 Aug 2019 11:50:14 GMT

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 — Wed, 28 Aug 2019 12:46:16 GMT

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