Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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