Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
veeranj
Creator II
Creator II

Need Help in Showing the data which should satisfy two conditions.

HI All,

I have the data as BELOW :

EmpNameCoreTrainingIndividual training statustrn_code
EMP1CORECOMPLIANTT1
EMP1DELINQUENTT2
EMP1COREINPROGRESST3
EMP2CORECOMPLIANTT4
EMP2COREDELINQUENTT5
EMP2DELINQUENTT6
EMP3-ASSIGNMENT IN PROGRESS-
EMP4-ASSIGNMENT IN PROGRESS-

In the output i have to show the data only of those employees who are assigned Core Trainings and for whom no trainings are assigned at all.

Here the output should be   which are highlighted above in red color.

Can any one please help me.

Thanks,

Anjee

1 Solution

Accepted Solutions
Anonymous
Not applicable

Hello!

You can find an attachment with a solution.

Hope it can be usefull,

KR

Elena

View solution in original post

4 Replies
diego_almeida
Partner - Contributor
Partner - Contributor

Hi, Virann,

I think you have to work in sql script using null function or length function to identify it.

Some like this:

Length(CoreTraining) = 0, -1 as CoreTraining

Then you use set analysis to get only CoreTraining <> -1

I hope this will help you

Anonymous
Not applicable

Hello!

You can find an attachment with a solution.

Hope it can be usefull,

KR

Elena

Not applicable

Please post the what is expected output from the above data ?

veeranj
Creator II
Creator II
Author

Thanks for the Reply and it solved my issue .
i resolved in this way :
if(len([CoreTraining])=0 and len(TRAINING_CODE)>0,0,1) and i have filtered the data based on flag=1.
this resolved my issue.

Thanks,

Anjee