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: 
soniasweety
Master
Master

current day logic

Hi all,

Antonio Mancini

I have a scenario like below  attached with sample data and with example.

and how can set the day of the week  ?  how to this in scripting?  and in  front end how to approach?

Thanks

Sonica

28 Replies
d_prashanthredd
Creator III
Creator III

If so, use one more condition like len(trim(assignedto))=0 along with days condition or you can use...

if(len(trim(assignedto))=0, 'Expression i.e. the one which used for days')

antoniotiman
Master III
Master III

If(IsNull(Assignedto),YourExpression)

or If(Len(Trim(AssignedTo))=0,YourExpression)

However, can You provide new Input Data ? (modified Excel File)

d_prashanthredd
Creator III
Creator III

More Info on Now and Today.. I hope it will help you, so that you can decide what to use.

now( [ timer_mode] )  ---- timer_mode: 0, 1, 2, default

Returns a timestamp of the current time from the system clock. The timer_mode may have the following values:

0 Time at script run
1 Time at function call
2 Time when the document was opened

Default timer_mode is 1. The timer_mode = 1 should be used with caution, since it polls the operating system every second and hence could slow down the system.

today( [timer_mode] ) ---- timer_mode: 0, 1, 2, default

Returns the current date from the system clock. The timer_mode may have the following values:

0 Date at script run
1 Date at function call
2 Date when the document was opened

Default timer_mode is 2. The timer_mode = 1 should be used with caution, since it polls the operating system every second and hence could slow down the system.

So now(), now(1) and today(1) all refresh every second, and should be used with caution.

soniasweety
Master
Master
Author

yes exactly

soniasweety
Master
Master
Author

Hi Sir,

attached updated excel with new column assigned to --- display above criteria where assignedto value is null only/

antoniotiman
Master III
Master III

See Attachment

soniasweety
Master
Master
Author

Hi Sir,

Could you check is this logic will work for my requirement?   or will I do any changes?

antoniotiman
Master III
Master III

This is different logic.

It seems same result.

I don't see IsNull(assignedto)

soniasweety
Master
Master
Author

Hi,

Now check the app with correct result . which is working fine.     [forgt null I worked in real app null is also working]

for your testing just change in inline

load * Inline [

currentday,limit

1,5

2,5

3,5

4,3

5,5   ----- this

6,4

7,5

];