Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

anjeepvr
Not applicable

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

Tags (2)
1 Solution

Accepted Solutions
elena888
Not applicable

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

Hello!

You can find an attachment with a solution.

Hope it can be usefull,

KR

Elena

4 Replies
diego_almeida
Not applicable

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

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

elena888
Not applicable

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

Hello!

You can find an attachment with a solution.

Hope it can be usefull,

KR

Elena

Not applicable

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

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

anjeepvr
Not applicable

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

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