Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

convert if to set analysis

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

5 Replies
Not applicable

Hi Hilal,

Try the below expression:

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

Hi

Try like this

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

Thanks & Regards,
Mayil Vahanan R
Partner
Partner

Try this:

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

Not applicable

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

Partner
Partner

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