Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
deepika_gohil
Not applicable

in Qliksense chart independant from filter

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.

11 Replies
agigliotti
Not applicable

Re: in Qliksense chart independant from filter

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

Re: in Qliksense chart independant from filter

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

Re: in Qliksense chart independant from filter

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

Re: in Qliksense chart independant from filter

Hi Andrea,

Thanks for your reply.

Not working..

Monthyear is in mmmyy format.

deepika_gohil
Not applicable

Re: in Qliksense chart independant from filter

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

agigliotti
Not applicable

Re: in Qliksense chart independant from filter

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

arulsettu
Not applicable

Re: in Qliksense chart independant from filter

Try Maxstring(Monthyear)

deepika_gohil
Not applicable

Re: in Qliksense chart independant from filter

Its not working..

arulsettu
Not applicable

Re: in Qliksense chart independant from filter

can you share some sample and expected output