Urgent please help

[Apeksha]

I have attached  two tables one is input table and another is output table and I want whatever product is innovated beyond currentyear-4years range (ex- current year is 2021,  2021-4=2017 so , products innovated in 2016 or before should fall under non-innovation)  should be falling iñ non-innovation category in output table. How to do this in Qliksense.

[Taoufiq_Zarra]

@Apeksha 

for this input for example :

A,2016
B,2015
C,2016
F,2017

you can use this in load :

load Product,if(Year(today())-[Year of Innovation]<=4,[Year of Innovation],'Non-Innovation') as [Year of Innovation];
load * inline [
Product,Year of Innovation
A,2016
B,2015
C,2016
F,2017
];

the output:

[Apeksha]

Thank you for your help Taoufiq_zarra but inline load is not possible because no. of products falling in non-innovation category will be very large. If you know some other way Please help me.

[Taoufiq_Zarra · Accepted solution]

@Apeksha  inline just indication or example

you can use

load Product,if(Year(today())-[Year of Innovation]<=4,[Year of Innovation],'Non-Innovation') as [Year of Innovation];
load * from ... your database

or in your interface

you can add dimension Product

and in measure if(Year(today())-[Year of Innovation]<=4,[Year of Innovation],'Non-Innovation')

[Apeksha]

Thank you so much