Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

soniasweety
Contributor III

Add to filter

Hi

Antonio Mancini

Can you look into this?   

Tags (2)
6 Replies
antoniotiman
Honored Contributor III

Re: Add to filter

Hi,

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

Regards,

Antonio

antoniotiman
Honored Contributor III

Re: Add to filter

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

soniasweety
Contributor III

Re: Add to filter

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

antoniotiman
Honored Contributor III

Re: Add to filter

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

Re: Add to filter

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

Re: Add to filter

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' ?