Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mahitham
Contributor

if logic help in front end

Hi Experts,

Can any one please help me on below requirement.

I have to create one new field  from below mentioned 4 fields (Entity, Feedback, Start date and end date ) named [T/N Product] with 2 records i.e., Trending Product and Non Trending Product records

based on existing fields condition using if match expression.

Conditions:

if  Entity  = Sales then Trending Product

if  Entity  = Manager then Non Trending Product but only if Feedback = Yes else Trending Product

If  Entity  = Products  then Non Trending Product but only if Feedback =No  and (End date -start date)<=3years

if  Entity  = Rating then Trending Product

if any new field added at Entity it has to be treated as Trending Product

Entity            Feedback          Start date            end date

Sales                Yes                  01/02/2015          05/01/2018

Manger            No                    01/02/2017          05/01/2018

Products                                    01/02/2017          05/01/2018

Rating

Please help me on this.

Thanks in advance.

1 Reply
MVP
MVP

Re: if logic help in front end