Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

stuhico09
Contributor

How to visualize chart last 12 month backwards (exclude current month)

Dear Team,

How to exclude 2018 Apr? I already try to minus 20 days from today's date, but it didn't works.

Please help. Thanks.

xa.PNG

xxx.PNG

1 Solution

Accepted Solutions
stuhico09
Contributor

Re: How to visualize chart last 12 month backwards (exclude current month)

Hi Rachel,

I get your points. i modify it to be like this. its working now. Thanks.

=Num(Count({$<Status={'Completed'}>*$<[PSR No]-={"''"}> *$<Temp={'Task_W'}>

*$<[Modified Date]={">=$(=AddMonths(MonthStart(Today()),-12))"}>

*$<[Modified Date]={"<$(=MonthStart(Today()))"}>

} ([PSR No])),'##.0')



xxx.PNG

2 Replies
rachel_delany
Contributor

Re: How to visualize chart last 12 month backwards (exclude current month)

Try something like this:

<[Modified Date]={">=$(=AddMonths(MonthStart(Today()),-11))"}, [Modified Date]={"<=$(=MonthStart(Today()))"}>}


Essentially it is adding another conditioning saying that the date should be less than the start day of the current month.

stuhico09
Contributor

Re: How to visualize chart last 12 month backwards (exclude current month)

Hi Rachel,

I get your points. i modify it to be like this. its working now. Thanks.

=Num(Count({$<Status={'Completed'}>*$<[PSR No]-={"''"}> *$<Temp={'Task_W'}>

*$<[Modified Date]={">=$(=AddMonths(MonthStart(Today()),-12))"}>

*$<[Modified Date]={"<$(=MonthStart(Today()))"}>

} ([PSR No])),'##.0')



xxx.PNG

Community Browser