topic Re: HEY in Qlik Automate

HEY

eladzbir — Sun, 29 Jan 2023 14:26:47 GMT

hey

i want to change this line:

vPreMonthQLIK= MonthStart(AddMonths(Today()-1,-2));

if your calander month is january pick december (with numbers), else current month minus 1

thank you

elad

Re: HEY

Vegar — Sun, 29 Jan 2023 17:40:56 GMT

Try this

Month(AddMonths(Today(),-1))

Or this if you want to present the number

Num(Month(AddMonths(Today(),-1)))

Re: HEY

eladzbir — Sun, 29 Jan 2023 20:53:31 GMT

Thank You

Re: HEY

sidhiq91 — Mon, 30 Jan 2023 03:11:29 GMT

@eladzbir Please see the code below:

NoConcatenate
Temp:
Load Date,
sales,
Month(Date) as Month;

load date(Date#(Date,'MM/DD/YYYY'),'MM/DD/YYYY') as Date,
sales
inline [
Date, sales
01/11/2023,10
04/14/2023,12
07/23/2023,13
08/22/2023,14
12/24/2022,15
];

Let VDec=Month(Yearend(Today(),-1));

Exit Script;

In the front end: for Dimension field use the below expression:

=Aggr(if(GetFieldSelections(Month)='Jan','$(VDec)',Max(Month)-2),Month)

Please let me know if this has resolved the issue.