Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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...