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

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
Master
Master
Author

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

antoniotiman
Master III
Master III

See Attachment

antoniotiman
Master III
Master III

New Attachment

soniasweety
Master
Master
Author

Hi,

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

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

antoniotiman
Master III
Master III

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

soniasweety
Master
Master
Author

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
Master III
Master III

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

soniasweety
Master
Master
Author

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
Creator III
Creator III

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