topic Re: if match condition help in QlikView

if match condition help

mahitham — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: if match condition help

dapostolopoylos — Fri, 15 Jun 2018 08:14:32 GMT

There you are....

if(Match(Entity,'Sales','Rating'),

'Trending Product',

if((Entity='Manager' and Feedback='Yes') or (Entity='Products' and Feedback='No' and (Year(End Date)-Year(Start Date))<=3),

'Non Trending Product'),

'Trending Product'

)

Re: if match condition help

mahitham — Fri, 15 Jun 2018 09:54:14 GMT

Hi,

Could you please help me on this.

stalwar1

jyothish8807

Re: if match condition help

dapostolopoylos — Fri, 15 Jun 2018 10:25:56 GMT

There it is

if(Match(Entity,'Sales','Rating'),

'Trending Product',

if((Entity='Manager' and Feedback='Yes') or (Entity='Products' and Feedback='No' and (Year(End Date)-Year(Start Date))<=3 or Match(Entity,'Testing','Production')),

'Non Trending Product'),

'Trending Product'

)

Re: if match condition help

mahitham — Fri, 15 Jun 2018 10:46:34 GMT

Hi,

Thanks for your help. But I am getting error in expression.

Re: if match condition help

dapostolopoylos — Fri, 15 Jun 2018 10:50:56 GMT

Paste your expression here

Re: if match condition help

sunny_talwar — Fri, 15 Jun 2018 10:55:40 GMT

Corrected some parenthesis

If(Match(Entity, 'Sales', 'Rating'), 'Trending Product',

If(

(Entity = 'Manager' and Feedback = 'Yes') or (Entity = 'Products' and Feedback = 'No' and (Year(End Date)-Year(Start Date)) <=3) or (Match(Entity,'Testing','Production')),

'Non Trending Product',

'Trending Product'

)

Re: if match condition help

mahitham — Fri, 15 Jun 2018 11:02:27 GMT

HI Sunny,

Now the error removed but expression not working.

By filtering Entity='Testing' not getting 'Non Trending Product' in the new field.

Thanks in advacne

Re: if match condition help

sunny_talwar — Fri, 15 Jun 2018 11:05:11 GMT

Can you share an image of a table box where you add Entity, Feedback, EndDate, StartDate and this new expression as dimensions?

Re: if match condition help

dapostolopoylos — Fri, 15 Jun 2018 11:10:05 GMT

I suspect the Entity field values may contain extra spaces...

Try this version

If(Match(Trim(Entity), 'Sales', 'Rating'), 'Trending Product',

If(

(Trim(Entity) = 'Manager' and Feedback = 'Yes') or (Trim(Entity) = 'Products' and Feedback = 'No' and (Year(End Date)-Year(Start Date)) <=3) or (Match(Trim(Entity),'Testing','Production')),

'Non Trending Product',

'Trending Product'

)

Re: if match condition help

sunny_talwar — Fri, 15 Jun 2018 11:41:28 GMT

May be try creating a master dimension and see if that works... if that doesn't work... then I am not sure you will be able to do this without some manipulation in the script