topic Re: condition in the field expression in QlikView

condition in the field expression

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

Hi guys,

I need your help once again

I have a table that contains a list of employee by entitee

NoConcatenate

modif:

[LOGIN CRM] as "Dern. modif par",

Entité,

NOM &' '& PRENOM as "fullname"

FROM

where Entité='Réclamation';

I have an other table to define secutity acess on a field

acess:

load if (match id(n,k,i,h,), mobile, fixe) as typeacces

.....

Entité='Réclamation' ,they have mobile as typeacces

i have a table as you can see below : i need to add a condition in the derner.modif par field something like if Entité='Réclamation' ,and typeacces=mobile display the derner.modif par field else display the other entity

anyone could help me to put this in my expression

thanks

Re: condition in the field expression

swuehl — Wed, 25 May 2016 22:06:46 GMT

How are your two tables linked to each other?

Re: condition in the field expression

master_student — Wed, 25 May 2016 22:20:36 GMT

the pb is not fixed yet. i will share my qvw tomorrow with the community

Re: condition in the field expression

master_student — Thu, 26 May 2016 08:01:42 GMT

I nee somthing like this with two conditions

=if([Type Acces] ='Mobile',if(Entité='BO B2C',[Dern. modif par],'No') ) and instead of no I need if([Type Acces] ='fixe',if(Entité='fixe',[Dern. modif par]

Any answer please.

Thanks for your help

Re: condition in the field expression

Thu, 26 May 2016 08:37:37 GMT

something like this u need

if( [Type Acces]= 'Mobile' and Entité='BO B2C',[Dern. modif par],

if [Type Acces] ='fixe' and Entité='fixe' as Dern. modif par]));

Not very sure

Re: condition in the field expression

master_student — Thu, 26 May 2016 09:16:35 GMT

Thanks but it does not work

Re: condition in the field expression

swuehl — Thu, 26 May 2016 09:20:07 GMT

Maybe

if( [Type Acces] = 'Mobile' and [Entité] = 'BO B2C',[Dern. modif par],

if ([Type Acces] ='fixe' and [Entité] = 'fixe', [Dern. modif par])

)

Re: condition in the field expression

master_student — Thu, 26 May 2016 10:18:09 GMT

Thanks swuehl‌