topic Range Filter in Multibox in QlikView

Range Filter in Multibox

Anonymous — Fri, 08 Dec 2017 07:52:53 GMT

Hi Team,

I have a multibox which is showing range value like Dec16-Nov17.

I want to convert it into a single filter as 2017 for Dec16-Nov 17 and 2018 for Dec17-Nov18 and so on.

How can I achieve this.

Please help me on this.

Thanks.

Anil_Babu_Samineni — Fri, 08 Dec 2017 08:53:10 GMT

Are you looking for Fiscal Year

Anonymous — Fri, 08 Dec 2017 09:41:32 GMT

Hi Anil,

This scripting is done on the extraction side on the link you have attached.

I have already a long script on extraction part and i want to achieve this on set-analysis.

I am already getting the value as Dec16-Nov17 from a field u can call RangeYear.

How can I achieve the year only 2017 by using that field on Set Analysis.

Could you please help on it.

Thanks.

Anil_Babu_Samineni — Fri, 08 Dec 2017 09:44:11 GMT

Thus, Sum({<RangeYear = {'$(=Max(RangeYear))'}>}Sales) not returning for you?

Anonymous — Fri, 08 Dec 2017 09:56:41 GMT

It is not working for me.

I am using a multibox in which I have used a field called TDimMonth.RangeYear which is returning value Dec16-Nov17, Dec15-Nov16 and so on.

Instead of this value I want to get Year - 2017 only.

Please help.