Current Month To 6 Month

[inam]

Hello Community,

I had a column
"First check in"
14-10-2023
02-01-2024
02-12-2023
23-12-2023
18-11-2023
04-11-2023
08-12-2023
24-11-2023
17-11-2023
03-11-2023
01-12-2023
ETC

so i convert this
Monthname([First check in]) AS MONTH1,

so i have column MONTH1 in this
"MONTH1"
Aug 2023
Sep 2023
Oct 2023
Nov 2023
Dec 2023
Jan 2024
Feb 2024

HERE i want only current month to 6 month
if current month is Oct 2023 so i want
Oct-2023
Nov-2023
Dec-2023
Jan-2024
Feb-2024
Mar-2024(If present in MONTH1 COLUMN Here March data is not available)

And I am Taking "MONTH1" Column in Pivot table dimensions

[AfeefaTk]

Hi @inam 

In this forum we would be able to help you with questions related to the product Qlik Application Automation.
This question seems to be related to Qlik Sense, if so, could you please post your question in that forum (https://community.qlik.com/t5/Qlik-Sense/ct-p/qlik-sense)?

Thanks

[anat]

you can use the calculated dim to display 6 months 

vCurrentMonthYear=max(Month)

vNext6MonthYear=addmonths(max(Month),+6)

=Aggr(Only({<Month = {'>=$(=vCurrentMonthYear)<=$(=vNext6MonthYear)'}>}Month),Month)

Note:you may need to adjust date/month formats as per your data

[PrashantSangle]

I moved it to "New to Qlik Sense" Forum.

@inam , where you want this data reduction?? only in that chart or in all dashboard?

if you want data reduction in chart then use set analysis to achieve the same. For eg.

Sum({<Month={">=$(=Monthstart(Today))<=(=MonthEnd(Today(),6))"}>}Sales)

if you want for all dashboard then use where clause on that qvd. for eg.

Load * from tableName where Month>=Monthstart(Today()) and Month<=MonthStart(Today,6)

Regards,

Prashant Sangle

[Ahidhar]

try this

tab:
load monthname("First check in") as Month1;
load * where "First check in">=makedate(2023,10,01) and "First check in"<=addmonths(makedate(2023,10,01),6);
load date#("First check in",'DD-MM-YYYY') as "First check in" Inline
[
"First check in"
14-10-2023
02-01-2024
02-12-2023
23-12-2023
18-11-2023
04-11-2023
08-12-2023
24-11-2023
17-11-2023
03-11-2023
01-12-2023
01-09-2023
01-08-2023
];

NoConcatenate
tab1:
load
Distinct Month1
resident tab order by Month1;drop table tab;