topic Re: Help with expression in QlikView

Help with expression

Anonymous — Fri, 22 May 2015 16:38:09 GMT

Hi guys,

Please can you help me put the two expressions below into one.

=sum(If(WildMatch([opp_type],'Monthly*'),opp_count))

=sum({<opp_create_year={$(vCurrentYear)}>} opp_count)

I cannot seem to figure this one out !

Thanks

Gysbert_Wassenaar — Fri, 22 May 2015 16:50:18 GMT

=sum({<opp_create_year={$(vCurrentYear)}, opp_type = {'Monthly'}>} opp_count)

Clever_Anjos — Fri, 22 May 2015 16:51:32 GMT

=sum({<[opp_type]={"Monthly*"},opp_create_year={$(vCurrentYear)}>} opp_count)

Anonymous — Fri, 22 May 2015 16:52:45 GMT

May this is what you want:

=sum({<opp_create_year={$(vCurrentYear)}>} If(WildMatch([opp_type],'Monthly*'), opp_count))

=sum({<opp_create_year={$(vCurrentYear)}, opp_type={'Monthly*'}>} opp_count)

MarcoWedel — Fri, 22 May 2015 21:54:29 GMT

Hi,

other solutions could be:

=Sum(If(opp_type like 'Monthly*' and opp_create_year=$(vCurrentYear), opp_count))

=-Sum((opp_type like 'Monthly*' and opp_create_year=$(vCurrentYear))*opp_count)

although set expressions should perform better.

hope this helps

regards

Marco