Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Issue with Expression

@stigchel

stalwar1

Hello Friends

In attached application,I need to display count of projects delayed and completed on time in Benchmark column.

Ex:  it should give count of negative values and positive values available in column when expanded.

For , NPD 122, Proj Name Capacity Expansion it should display  '5 -0'  as (5 count of -9 is available in data) under Benchmark column when collapsed til Project Name.  As of now its showing -45.

Thanks & Regards

Chintan

1 Solution

Accepted Solutions
sunny_talwar

Try this

=If(Dimensionality() = 2,

Sum(Aggr(If(Sum({<End={'Start'},Task_Group={'Benchmarking'}>}S_DayDiff1)> 0, 1, 0), NPR_WBS, Project_Name_WBS)) & ' - ' & Sum(Aggr(If(Sum({<End={'End'},Task_Group={'Benchmarking'}>}A_DayDiff2) > 0, 1, 0), NPR_WBS, Project_Name_WBS)),

Sum({<End={'End'},Task_Group={'Benchmarking'}>}A_DayDiff2) - Sum({<End={'Start'},Task_Group={'Benchmarking'}>}S_DayDiff1))

View solution in original post

8 Replies
sunny_talwar

Display '5 -0' or do you just want to see 5?

Anonymous
Not applicable
Author

Hi Sunny,

5-0  for this case  , but  if positive are 3 then 5-3 and so on.

sunny_talwar

And this is when the chart isn't expanded? What happens when the chart is expanded?

sunny_talwar

Try this

=Sum(Aggr(If(Sum({<End={'Start'},Task_Group={'Benchmarking'}>}S_DayDiff1)> 0, 1, 0), NPR_WBS, Project_Name_WBS)) & ' - ' & Sum(Aggr(If(Sum({<End={'End'},Task_Group={'Benchmarking'}>}A_DayDiff2) > 0, 1, 0), NPR_WBS, Project_Name_WBS))

hamzabob1
Partner - Contributor III
Partner - Contributor III

Dear Sunny,

thanks for your rpl but this is not what we want.

we want  count of positive and negative numbar when the chart is collaps and -9 when the chart is expand.

Plz once check project status sheet so u'll get what we want.

johnw

stalwar1 Thanks again.

hamzabob1
Partner - Contributor III
Partner - Contributor III

swuehl

jontydkpi

Please help...

Thanks

sunny_talwar

Try this

=If(Dimensionality() = 2,

Sum(Aggr(If(Sum({<End={'Start'},Task_Group={'Benchmarking'}>}S_DayDiff1)> 0, 1, 0), NPR_WBS, Project_Name_WBS)) & ' - ' & Sum(Aggr(If(Sum({<End={'End'},Task_Group={'Benchmarking'}>}A_DayDiff2) > 0, 1, 0), NPR_WBS, Project_Name_WBS)),

Sum({<End={'End'},Task_Group={'Benchmarking'}>}A_DayDiff2) - Sum({<End={'Start'},Task_Group={'Benchmarking'}>}S_DayDiff1))

hamzabob1
Partner - Contributor III
Partner - Contributor III

Perfect Bro...

Thank you so much...