Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
saivina2920
Creator
Creator

How to calculate blank field along with user Input data

I have calculated data with <10, 10 to 30 and >30 days.

In that, I have some blank field in EMP_RELIEVE_DATE column.

I have no problem if date value exists and it should calculate as it is. But, if i found any blank cells in EMP_RELIEVE_DATE then i am in a position to calculate the below.

When the user enter Input like say 10, then it should add with EMP_RESIGN_DATE and then consider it is EMP_RELIEVE_DATE. if EMP_RELIEVE_DATE Is blank only then consider User Input data + EMP_RESIGN_DATE.

How to perform this action.

I have enclosed sample data and qlik file

Labels (1)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

Take a look at my attached application. Notice that I needed to add a key that identifies the row (or at least each possible combination of the two dates)

Vegar_0-1608497877062.png

 

View solution in original post

16 Replies
saivina2920
Creator
Creator
Author

any update pls.

Vegar
MVP
MVP

You could try this

Dayname(Alt (EMP_RELIEVE_DATE, EMP_RESIGN_DATE + $(vUserInput))) 

to calculate your date. 

saivina2920
Creator
Creator
Author

without affecting the existing calculation, How do i process the below

Dayname(Alt (EMP_RELIEVE_DATE, EMP_RESIGN_DATE + $(vUserInput)))

My condition should be below in the expression or SQL query

If EMP_RELIEVE_DATE is blank then ==> I want count here if it is blank (Dayname(Alt (EMP_RELIEVE_DATE, EMP_RESIGN_DATE + $(vUserInput))) )

//without affecting the existing calculation, How do i process the below
/*=Count({<EMP_RELIEVE_DATE={">=$(=vCalDate10)<=$(=vToday)"}>}EMP_RELIEVE_DATE)*/
Dayname(Alt (EMP_RELIEVE_DATE, EMP_RESIGN_DATE + $(vUserInput)))

If EMP_RELIEVE_DATE is NOT blank then (<10 Days) ==> This is OK

=Count({<EMP_RELIEVE_DATE={">=$(=vCalDate10)<=$(=vToday)"}>}EMP_RELIEVE_DATE)

pls. give some output in the attached qvw file.

saivina2920
Creator
Creator
Author

I worked out some sample data's with attachment.

It will calculate "User Input + EMP_RESIGN_DATE" ==> EMP_RELIEVE_DATE-NEW (List boxes).

But, I want only blank check blank cells EMP_RELIEVE_DATE and calculate corresponding "User Input + EMP_RESIGN_DATE"

When user enter in the input fields, then system automatically calculate EMP_RELIEVE_DATE is blank and process the existing calculation.

saivina2920
Creator
Creator
Author

Any update pls..

saivina2920
Creator
Creator
Author

Can anyone help me to proceed further..

Pls.let me know if need anymore information..

saivina2920
Creator
Creator
Author

Any update regarding the subject..

saivina2920
Creator
Creator
Author

any update pls.

Vegar
MVP
MVP

I have noticed you asking for help. I hope someone will respond soon, if not then I could probably have a look at this tonight or tomorrow when the weekend has finished.

Vegar