Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III

condition in the field expression

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

xx

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

Capture.JPG

anyone could help me to put this in my expression

thanks

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe

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

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

)

View solution in original post

7 Replies
swuehl
MVP
MVP

How are your two tables linked to each other?

master_student
Creator III
Creator III
Author

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

master_student
Creator III
Creator III
Author

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

Not applicable

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

master_student
Creator III
Creator III
Author

Thanks but it does not work

swuehl
MVP
MVP

Maybe

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

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

)

View solution in original post

master_student
Creator III
Creator III
Author

Thanks swuehl