topic Re: using only in if-condition in QlikView

using only in if-condition

Mon, 25 Nov 2013 10:02:07 GMT

Hi qlikviewers,

Where is the error please ? i can't see it !!!!

=Count(DISTINCT if(Oppo_CreatedDate >= only(MonthStart(Date#(MoisAnnée,'MMM YYYY'))) // and Oppo_CreatedDate<= only(MonthEnd(Date#(MoisAnnée,'MMM YYYY'))) and IsNull(Oppo_Closed) , OpportunityCD))

Thanks a lot

Re: using only in if-condition

tresB — Mon, 25 Nov 2013 10:08:04 GMT

One issue:

You can't directly use one aggregation function (here only) within another (here count); you have to use it with AGGR.

Re: using only in if-condition

Mon, 25 Nov 2013 10:09:11 GMT

can you show me how please ?

Re: using only in if-condition

sujeetsingh — Mon, 25 Nov 2013 10:10:10 GMT

Count(DISTINCT if(Oppo_CreatedDate >= only(MonthStart(Date#(MoisAnnée,'MMM YYYY'),1)) ))

-----In this you were missing brackets while closing and the value for if() statement

Re: using only in if-condition

Mon, 25 Nov 2013 10:12:49 GMT

can you show me how please ?

Re: using only in if-condition

tresB — Mon, 25 Nov 2013 10:28:12 GMT

I would give you a general example:

=concat(distinct IF(aggr(rank(sum(Sales)),Salesperson)<=3,Salesperson&CHR(13)))

Here, SUM has been used within another aggregation function CONCAT. And that has only been possible because of AGGR that defines the aggregation level (dimension).

I can't access app right now, otherwise would request you to share your sample app.

Re: using only in if-condition

swuehl — Mon, 25 Nov 2013 10:31:12 GMT

If you don't want to use set analysis in your only() functions, I think you don't need only() here:

=Count(DISTINCT if(Oppo_CreatedDate >= MonthStart(Date#(MoisAnnée,'MMM YYYY'))

and Oppo_CreatedDate<= MonthEnd(Date#(MoisAnnée,'MMM YYYY')) and IsNull(Oppo_Closed)

, OpportunityCD))