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

Add to filter

Hi

Antonio Mancini

Can you look into this?   

6 Replies
antoniotiman
Master III
Master III

Hi,

I'm sorry,I am not authorized to access the Link.

Regards,

Antonio

antoniotiman
Master III
Master III

Why Rows 16 and 18 must have shown since duration is less than 5 ?

soniasweety
Master
Master
Author

yes ,that day logic shpuld apply to particular taskname =9day only  rest all show and it doesn't depends on day nd duration

antoniotiman
Master III
Master III

Try this for Dimension Name

=If(Name='9day',If(Match(Num(WeekDay(TimeStamp#(Opendate,'YYYY-MM-DD hh:mm:ss'))),1,2,3,7),Name),Name)

Uncheck Include Null Values

soniasweety
Master
Master
Author

Hi,

its not working still its showing the data  duration below 5days  .

it should show above 5days of task duration  for this particular taskname

antoniotiman
Master III
Master III

In Your App I see Dimension

=if(match(Assignedgroup,'A','B') and [Duration(in Days)]>=limit, ID)

and this filters itself Duration >= 5 since limit is 5.

However You add condition in my above Dimension like this

=If(Name='9day',If(Match(Num(WeekDay(TimeStamp#(Opendate,'YYYY-MM-DD hh:mm:ss'))),1,2,3,7) and [Duration(inDays)] >= 5,Name),Name)

Have You unchecked 'Include Null Values' ?