Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

soniasweety
Valued Contributor III

Re: current day logic

and the expression if write like below its working but if I write total condition its not working'

count({<Task_DurationDays={'<=15'}>}number)

it is showing lesthan 15days numbers but full expression if I use nothing is displaying

soniasweety
Valued Contributor III

Re: current day logic

your expression is working but it is showing all more than 3days even though there is less than 3days duration values also.

antoniotiman
Honored Contributor III

Re: current day logic

See Attachment

antoniotiman
Honored Contributor III

Re: current day logic

New Attachment

soniasweety
Valued Contributor III

Re: current day logic

Hi,

LET vDay = Num(WeekDay(Today()))+1;

this variable displys today+1  y this?  why cant we use only today? any specific reason?

antoniotiman
Honored Contributor III

Re: current day logic

Because QV Logic is Mon -> 0 and Your Logic is Mon -> 1

soniasweety
Valued Contributor III

Re: current day logic

thanks  for clarification. how can I include this in below expression

Antonio Mancini                   

aggr(If(Match(vDay,1,2,3,7),Only({<Task_DurationDays={'>5'}>} Task_DurationDays
),
If(Match(vDay,4,5),Only({<Task_DurationDays={4,5}>} Task_DurationDays),
if(match(vDay,6),Only({<Task_DurationDays={'>=4'}>} Task_DurationDays)))),TaskName)


"  only(if(isnull(Assignedto), Number))"    this also part the of expression. 

I want the above criteria along with the field assignedto value is null.

antoniotiman
Honored Contributor III

Re: current day logic

I'm sorry, I don't understand. What is Your new logic ?

soniasweety
Valued Contributor III

Re: current day logic

the logic is the report is like to display the numbers where the filed assignedto is null along with the  day logic criteria

d_prashanthredd
Contributor III

Re: current day logic

You mean, that expression/calculation should execute if the assignedto value is null??