Exclude current/latest fiscal month year

[sifatnabil]

Hi all,

I have a graph like below, but since the month of July hasn't ended, I would like to exclude it.

I have 2 dimensions on this chart: FMonth (with values like Apr, May, Jun), and FYear (with values like 2014/2015, 2015/2016). Any ideas?

[settu_periasamy]

Hi,

i think you need to change the Previous Year (2014 - 2015) set expression. It shows the full Financial year value.

if possible, post the sample.

[robert_mika]

LIke this:

=if(month='Jul',0,sum(Sales))

[robert_mika]

or more dynamic:

=if(month=Month(Today()),0,sum(Sales))

Feeling Qlikngry?

How To /Missing Manual(18 articles)

[senpradip007]

Try like this in expressions:

=if( MonthEnd(Today()) <> today(), 0, sum(Sales))

[sifatnabil]

Hi Robert_Mika‌, settu_periasamy‌, senpradip007‌, these won't work because my chart has 2 dimensions: FMonth (with values like Apr, May, Jun), and FYear (with values like 2014/2015, 2015/2016).

So I have to apply some logic on both these.

[jagan]

Hi,

Exclude it using set analysis

=Sum({<FMonth=, FYear=, DateFieldName={'>=$(=YearStart(Max(DateFieldName), -1, 4))<=$(=MonthEnd(max(DateFieldName), -1))'}>} Sales)

Replace DateFieldName with your actual date field name.

Hope this helps you.

Regards,

Jagan.