topic Re: convert if to set analysis in QlikView

convert if to set analysis

Fri, 22 Nov 2013 15:21:42 GMT

hi,

I need to convert my expressions based on if-condition:

=Count(DISTINCT if(Oppo_CreatedDate>= MonthStart([Datedopportunite]) and Oppo_CreatedDate<= MonthEnd([Datedopportunite])and IsNull(Oppo_Closed) , OpportunityCD))

=Count(DISTINCT if(Oppo_CreatedDate>= MonthStart([Datedopportunite]) and Oppo_CreatedDate<= MonthEnd([Datedopportunite])

and IsNull(Oppo_Closed) , OpportunityCD))

To a set analysis !!!

thanks

Re: convert if to set analysis

Fri, 22 Nov 2013 15:39:12 GMT

Hi Hilal,

Try the below expression:

=count({<Oppo_CreatedDate = {">= $(=MonthStart(Datedopportunite)) <= $(=MonthEnd(Datedopportunite))"}, Oppo_Closed = {''}>} OpportunityCD)

Re: convert if to set analysis

MayilVahanan — Fri, 22 Nov 2013 15:42:30 GMT

Try like this

=count({<Oppo_CreatedDate = {">= $(=MonthStart(Datedopportunite)) <= $(=MonthEnd(Datedopportunite))"}, Oppo_Closed -= {'*'}>} Distinct OpportunityCD)

Re: convert if to set analysis

danielact — Fri, 22 Nov 2013 15:42:41 GMT

Try this:

=Count(DISTINCT {$<Oppo_CreatedDate={'=Oppo_CreatedDate>= MonthStart([Datedopportunite]) and Oppo_CreatedDate<= MonthEnd([Datedopportunite])'}, Oppo_Closed={'=IsNull(Oppo_Closed)'}>} OpportunityCD)

Re: convert if to set analysis

Fri, 22 Nov 2013 15:58:27 GMT

thanks for solutions but no one of these set analysis work, they return 0

Re: convert if to set analysis

danielact — Fri, 22 Nov 2013 16:00:47 GMT

Can you post a qvw so we can take a look at the dataset?