Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

agrimroquette
Contributor II

Conditional Categorization.

Hi All,

Attached is my data file, and following are conditions that i want to apply on data,

please correct if i am wrong with my made conditions, my formulas are-


eg.

        if(Actual_Finish='NA', if( Actual_Start='NA',if( "% Complete"='100%' , '2' , '3')))

        if(month(Baseline_Start)=month(Today()), if( Project_Manager=' ',if(Project_Manager= '?',if( "% Complete"='0%' , '2' , '3'))))

for Name "%_Completion"= '100%'

if "%_Completion" =100%  and   "Actual_Start" or "Actual_Finish" is null or 'NA'---category "2"

else---category"3"

for Name "%_Completion"= '0%'

if "%_Completion" ="0%"  and   "Project_Manager" or "Baseline_Start" is null or 'NA' or '?'---category "2"

if "%_Completion" ="0%" and "Baseline_Start" month< Current_Month---category"1"

if "%_Completion" ="0%" and "Baseline_Start" month>= Current_Month---category"3"

for Name "%_Completion"= '1%-99%'

if "%_Completion" ="1%-99%"  and   "Actual_Start" or "Project_Manager" is null or 'NA' or '?' ---category "2"

if "%_Completion" ="1%-99%"  and   "Finish_Date" < "Current_Month"---category "1"

if "%_Completion" ="1%-99%"  and   "Finish_Date" >= "Current_Month"---category "3"

if "%_Completion" ="1%-99%"  and   "Actual_Start" > "Current_Month"---category "2"

5 Replies
agrimroquette
Contributor II

Re: Conditional Categorization.

is this for all three conditions?

prma7799
Honored Contributor III

Re: Conditional Categorization.

Can you please share your expected output. 

agrimroquette
Contributor II

Re: Conditional Categorization.

Hi,

thanks for reply, but its not showing any results

Thanks

agrimroquette
Contributor II

Re: Conditional Categorization.

Please see category field for expected results         

NameF_PIn_MP?In_DIGICDIGIC_.Project_ManagerBaseline_StartBaseline_FinishStart_DateFinish_DateActual_StartActual_Finish% CompleteCategory
aPNo?1-Jul-201730-Nov-201713-Oct-200913-Oct-2009NANA0%2
bFNo?1-May-201730-Jun-201712-Oct-200912-Oct-2009NANA0%2
cFYes20-Mar-201720-Apr-201720-Mar-20171-Apr-201720-Mar-20171-Apr-2017100%3
dPYesNo1-Apr-201730-Jun-20171-Apr-20173-Jun-20171-Apr-20173-Jun-2017100%3
ePaa1-Feb-20161-Jun-201714-Mar-201631-Jan-201714-Mar-201631-Jan-2017100%3
fPYesNobb1-Jan-201731-Mar-20171-Jan-201731-Mar-20171-Jan-201731-Mar-2017100%3
gFYesccNANA27-Jun-201613-Feb-201727-Jun-201613-Feb-2017100%3
hPYesdd1-Nov-20161-Dec-20167-Nov-201731-Mar-20197-Nov-2017NA1%2
iFNoee9-Oct-201631-Dec-201617-Oct-201627-Jan-201717-Oct-201627-Jan-2017100%3
jFff1-Apr-201730-Jun-20171-Apr-201730-Jun-2017NANA0%1
kPYesNogg20-Mar-201729-Sep-201721-Mar-20172-Oct-2017NANA0%1
agrimroquette
Contributor II

Re: Conditional Categorization.

Hi, PM

Did you found anything that can help me,

Thanks & Regards