using only in if-condition

[#1]

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

[tresB]

One issue:

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

[#3]

can you show me how please ?

[sujeetsingh]

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

[#5]

can you show me how please ?

[tresB]

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.

[swuehl]

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