topic Re: How i can Write This expression With out If Statement!!! in QlikView

How i can Write This expression With out If Statement!!!

Wed, 25 Mar 2015 06:36:35 GMT

I want write Below expression with using if Condition in set expression

Please can one help me on this

if(FcstALMeFW='Rem. Fcst.' or FcstALMeFW='Rem. Fcst.w/o Judge',sum({<FiscalYearQuarter=,MeasureType={'FFYR'},SubRegion=>} CommitAmount))

Thanks

Manju

sagarkharpude — Wed, 25 Mar 2015 06:42:38 GMT

Without If condition:

=sum({<MeasureType={'FFYR'},FcstALMeFW={'Rem. Fcst.','Rem. Fcst.w/o Judge'},SubRegion=FiscalYearQuarter=>} CommitAmount)

With if condition

=sum(if(FcstALMeFW='Rem. Fcst.' or FcstALMeFW='Rem. Fcst.w/o Judge',MeasureType='FFYR',CommitAmount))

Wed, 25 Mar 2015 07:16:09 GMT

Hi ,

Thanks For Replay After applying this I got some Issue please look the out put and let know what is the issue

please look attachment