Discussion Board for collaboration on QlikView Scripting.
I have the data as BELOW :
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.
Go to Solution.
You can find an attachment with a solution.
Hope it can be usefull,
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
Please post the what is expected output from the above data ?
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.