Text box expression issue

vijetas42 — Thu, 18 May 2017 09:42:31 GMT

Hi All,

I am facing an issue in one scenario where i need to calculate project count where phase should be complete and sales value should be >0

In this scenario if I have two phases for single project then it should consider it as various and should not take count in completed

Project Id Phase Sale

1 Complete 13245

1 Inception 124134

2 Complete 124335

2 Cancelled 0

so from above example Id 1 should not get considered because it is having two phase and both are >0 in other side ID 2 should be considered because cancelled phase is having value as 0 so, it should count only completed one.

I have use expression like this,

count(DISTINCT {<[Phase]={'Complete'},[Project Id]={"=sum($(vSales))>0"}>}

if(Aggr(count(DISTINCT [Phase]),[Project Id])=1, [Project Id])) but it didn't work

Please suggest

Re: Text box expression issue

vinieme12 — Thu, 18 May 2017 09:57:40 GMT

i'm confused, please confirm expected output for the above table

Re: Text box expression issue

malini_qlikview — Thu, 18 May 2017 13:59:12 GMT

Hi ,

You can use advanced set analysis,

try this in the expression,

Sum({<[Project Id]={"=(Sum({<Phase={'Complete'}>}Sale)-Sum({<Phase={'*'}-{'Complete'}>}Sale))=Sum({<Phase={'Complete'}>}Sale)"}>} Sale)

Attached is the sample application for the same

topic Re: Text box expression issue in QlikView

Text box expression issue

Re: Text box expression issue

Re: Text box expression issue