topic Re: Exclude current month from chart in QlikView

Exclude current month from chart

Mon, 01 Oct 2012 17:57:07 GMT

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

Re: Exclude current month from chart

Mon, 01 Oct 2012 18:07:11 GMT

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.