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

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

veeranj — Tue, 06 Jan 2015 11:23:29 GMT

HI All,

I have the data as BELOW :

EmpName	CoreTraining	Individual training status	trn_code
EMP1	CORE	COMPLIANT	T1
EMP1		DELINQUENT	T2
EMP1	CORE	INPROGRESS	T3
EMP2	CORE	COMPLIANT	T4
EMP2	CORE	DELINQUENT	T5
EMP2		DELINQUENT	T6
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

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

diego_almeida — Tue, 06 Jan 2015 14:27:32 GMT

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

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

Anonymous — Tue, 06 Jan 2015 16:56:11 GMT

Hello!

You can find an attachment with a solution.

Hope it can be usefull,

Elena

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

Tue, 06 Jan 2015 18:24:01 GMT

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

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

veeranj — Fri, 30 Jan 2015 13:52:04 GMT

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