Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

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

View solution in original post

2 Replies
rachel_delany
Creator II
Creator II

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.

Anonymous
Not applicable
Author

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