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: 
Not applicable

Exclude current month from chart

Hi all.

I wish to simply exclude the current month from a chart.

I have a simple line chart showing a ratio of one status versus another but the current months data is skewing the chart.

Here is my expression:

=Count(If(ReferralAction = 'Denied', ReferralActions.InternalID))

/

Count(If(ReferralAction = 'Sent', ReferralActions.InternalID))

Many thanks

John

1 Solution

Accepted Solutions
Not applicable
Author

Not knowing what field you have for dates, I'd try two things off the top of my head..

First, if you never want to see the current month, why not set a trigger on the page that sets the "Month" field to all but the current month? Something like "Month < Month(today())"

Second, if you might want to see the current month, why not put a listbox on the page, and again set a trigger as above, but now if the user does want to see the current month, he can simply select it.

View solution in original post

1 Reply
Not applicable
Author

Not knowing what field you have for dates, I'd try two things off the top of my head..

First, if you never want to see the current month, why not set a trigger on the page that sets the "Month" field to all but the current month? Something like "Month < Month(today())"

Second, if you might want to see the current month, why not put a listbox on the page, and again set a trigger as above, but now if the user does want to see the current month, he can simply select it.