in Qliksense chart independant from filter

[deepika_gohil]

I am using qliksense.

I have 1 filter called financial year (2016-17,2017-18,2018-19).

I want a bar chart which has dimension as financial year and measure will give sum of the sales for max month of the respective financial year i.e(Mar-17,Mar-18,May18)

I put expression as =sum({<MonthYear={'$(vMax_monthyear)'}>}Sales)

where vMax_monthyear=aggr(max(MonthYear),FinancialYear)

In this case I am getting value for measure only when I am selecting financial year from measure.If I am not selecting any financial year then chart is not showing any measure.I want to display the value for all the years without selecting financial year from filter.

I have negate the financial year like below also.but not working .

=sum({<MonthYear={'$(vMax_monthyear)'},Financialyear=>}Sales)

please assist.

[agigliotti]

let's try using the below expression instead:

sum( if( MonthYear = $(vMax_monthyear), Sales, 0) )

where

vMax_monthyear = Max(MonthYear);

I thought MonthYear field is numeric.

[aunahsan]

I would suggest you see what your variable is returning and see if it is the same format as MonthYear.

is there any reason for aggr in your variable?

[deepika_gohil]

Hi Aun,

Thanks for your reply..

Variable is returning correct value but only when I am selecting any values in filter of financial year.

[deepika_gohil]

Hi Andrea,

Thanks for your reply.

Not working..

Monthyear is in mmmyy format.

[deepika_gohil]

Aggr is applied in variable because For each year Max monthyear is different.

[agigliotti]

try to add a new measure with Max(Monthyear) and see what you get.

[arulsettu]

Try Maxstring(Monthyear)

[deepika_gohil]

Its not working..

[arulsettu]

can you share some sample and expected output