Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
saivina2920
Creator
Creator

How to add more conditions in the IF statement expression

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')

Labels (1)
15 Replies
saivina2920
Creator
Creator
Author

confirmed. pls. find the both attachment.

Count based on today-03JAN2021-1.qvw ==> One part is working perfect. the other part after enter user input count not coming.

Count based on today-03JAN2021-1_v0.1.qvw ==> both count is wrong and displaying future date's and zero  value rows.
 
below screenshot is correct count if user input is blank.
Error - 03JAN2021-1.PNG
 
below screenshot is correct count if user input is 5.
Error - 03JAN2021-2.PNG

 

Anil_Babu_Samineni

I see that there is similar which @tresesco help. Let's see if he can continue..

https://community.qlik.com/t5/New-to-QlikView/How-to-calculate-from-date-if-i-enter-user-input-as-nu... 

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
saivina2920
Creator
Creator
Author

i didn't get any response. can you pls. update...?

saivina2920
Creator
Creator
Author

Any update pls...

saivina2920
Creator
Creator
Author

Any update would be appreciated...

saivina2920
Creator
Creator
Author

kindly look this issue. without solving this issue, i can't do anything in this requirement.

kindly help.