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