topic Re: Issue with Expression in QlikView

Issue with Expression

Anonymous — Wed, 29 Aug 2018 05:12:27 GMT

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

Re: Issue with Expression

sunny_talwar — Tue, 04 Sep 2018 11:23:02 GMT

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

Re: Issue with Expression

Anonymous — Tue, 04 Sep 2018 12:59:12 GMT

Hi Sunny,

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

Re: Issue with Expression

sunny_talwar — Tue, 04 Sep 2018 13:01:23 GMT

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

Re: Issue with Expression

sunny_talwar — Tue, 04 Sep 2018 14:07:46 GMT

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))

Re: Issue with Expression

hamzabob1 — Wed, 05 Sep 2018 04:35:49 GMT

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.

Re: Issue with Expression

hamzabob1 — Thu, 06 Sep 2018 05:59:57 GMT

swuehl‌

jontydkpi‌

Please help...

Thanks

Re: Issue with Expression

sunny_talwar — Thu, 06 Sep 2018 12:54:22 GMT

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))

Re: Issue with Expression

hamzabob1 — Fri, 07 Sep 2018 05:40:36 GMT

Perfect Bro...

Thank you so much...