Qlikview Intervals

[Karthik30]

Hi,

I have fields Year where the year consists of values 2015,2016,2017,2018,2019,2020, I have another field cycle no which has 100 values,I have cost Field.

I want to know the cycles Maintenance cost that consists of intervals

2015 - 2020(Cycles which are working from 2015 to 2020) this all should come in one group

and the format should be like

2015-2020    2015-cost,2016-cost,2017-cost,2018-cost,2019-cost,2020-cost in a pivot table

2016 -2020(Cycles which are starting from 2016 to 2020) this all should come in one group

2016-2020   2016-cost,2017-cost,2018-cost,2019-cost,2020-cost in a pivot table

2017 -2020(Cycles which are starting from 2017 to 2020) this all should come in one group.

if the cycle is starting from 2016.Then that cycle costs should come under 2016-2020 and it should not get duplicated costs in 2015-2020.

[jochem_zw]

You can use the intervalmatch function for this

https://help.qlik.com/en-US/sense/February2020/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPref...

[Brett_Bleess]

Here is a Design Blog post to go along with the Help link provided by the partner:

https://community.qlik.com/t5/Qlik-Design-Blog/IntervalMatch/ba-p/1464547

If this is what you needed, please close out the thread by using the Accept as Solution button on the post(s) that helped.  If you have further questions, please leave an update post.

Regards,
Brett