How to add more conditions in the IF statement expression

[saivina2920]

I have to add more conditions in the if statement. How to add this. 

 More conditions :  [FROM]={'*MARIAM*'},[EMPSTATUS]={'Current'},[TO]="$(vPlaces)"

below is my expression

Exp1 ("Relieving Date"):

=If(vUserInput, if(IsNull(EMP_RELIEVE_DATE), Date(EMP_RESIGN_DATE+vUserInput)), if(not IsNull(EMP_RELIEVE_DATE), EMP_RELIEVE_DATE))

Exp 2 : (1-10days)

If([Relieving Date]>=vCalDate10 And [Relieving Date]<=vToday, 1,0)        // 'Relieving Date' is label to previous exp.

vToday ==> =date(Today(),'DD/MM/YYYY')

vCalcDate10 ==> =Date(vToday-10,'DD/MM/YYYY')

[Anil_Babu_Samineni]

Try this way whereever it is with "EMP_RELIEVE_DATE"

Only({<[FROM]={'*MARIAM*'},[EMPSTATUS]={'Current'},[TO]={"$(vPlaces)"}>} EMP_RELIEVE_DATE)

[saivina2920]

below highlighted is ok...?

=If(vUserInput, if(IsNull(EMP_RELIEVE_DATE), Date(EMP_RESIGN_DATE+vUserInput)), if(not IsNull(EMP_RELIEVE_DATE), Only({<[FROM]={'*MARIAM*'},[EMPSTATUS]={'Current'},[TO]={"$(vPlaces)"}>} EMP_RELIEVE_DATE)))

[Anil_Babu_Samineni]

Instead, Can i ask sample application to work it out as per needs?

[saivina2920]

pls. find the test qlikview file attachment.

enter some input or let it be blank in user input.

then check the TABLE-1...(want to exclude future date or all zero value in the row  (1-10.10-30,>30)

[Anil_Babu_Samineni]

Perhaps this?

[saivina2920]

Yeah. one part is correct. the other part "enter number" in input, then nothing will come.

When i enter input (say 5 days, nothing will come). ?????

[Anil_Babu_Samineni]

PFA Updated

[saivina2920]

count is not coming perfect in both cases. also future date is coming along with zero again....?

pls. check your last attachment.(Count based on today-03JAN2021-1_v0.1.qvw).

[Anil_Babu_Samineni]

Check the latest one and confirm? If still not, Kindly share more information?