Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

d_prashanthredd
Contributor III

Re: current day logic

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
Honored Contributor III

Re: current day logic

If(IsNull(Assignedto),YourExpression)

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

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

d_prashanthredd
Contributor III

Re: current day logic

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
Valued Contributor III

Re: current day logic

yes exactly

soniasweety
Valued Contributor III

Re: current day logic

Hi Sir,

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

antoniotiman
Honored Contributor III

Re: current day logic

See Attachment

soniasweety
Valued Contributor III

Re: current day logic

Hi Sir,

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

antoniotiman
Honored Contributor III

Re: current day logic

This is different logic.

It seems same result.

I don't see IsNull(assignedto)

soniasweety
Valued Contributor III

Re: current day logic

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

];