Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
any update pls.
You could try this
Dayname(Alt (EMP_RELIEVE_DATE, EMP_RESIGN_DATE + $(vUserInput)))
to calculate your date.
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.
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.
Any update pls..
Can anyone help me to proceed further..
Pls.let me know if need anymore information..
Any update regarding the subject..
any update pls.
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