topic Re: can u correct this set expression? in QlikView

can u correct this set expression?

balasundaram — Sat, 06 Sep 2014 10:48:28 GMT

=Count({<FiscalYearNum = {"$(=Max(FiscalYearNum))"},LOSTandFOUND.Status={Withus} >}[LOSTandFOUND.Description of item found]))

above expression intension is i need max year with status is 'withs'...but above expression not working..any one corect my expression

ajaykumar1 — Sat, 06 Sep 2014 10:49:54 GMT

Try like;

=Count({<FiscalYearNum = {"$(=Max(FiscalYearNum))"},LOSTandFOUND.Status={"Withus"} >}[LOSTandFOUND.Description of item found])

PrashantSangle — Sat, 06 Sep 2014 10:51:05 GMT

Hi,

try this,

Count({<FiscalYearNum = {"$(=Max(FiscalYearNum))"},LOSTandFOUND.Status={'Withus'} >}[LOSTandFOUND.Description of item found])

Regards

balasundaram — Sat, 06 Sep 2014 10:54:32 GMT

thanks ..its working....

balasundaram — Sat, 06 Sep 2014 10:54:50 GMT

thank u

ajaykumar1 — Sat, 06 Sep 2014 10:56:14 GMT

If its working close the thread.

balasundaram — Sat, 06 Sep 2014 14:22:22 GMT

This question is Not Answered.(Mark as assumed answered)

balasundaram Sep 6, 2014 10:21 AM

='Total '& Count([Moc.Type .])+Count(Moc.Type.)

above expression i written in under presentation tab in "TEXT IN CHART" , i am trying to show total count,but i used sum not working

MarcoWedel — Sat, 06 Sep 2014 14:42:54 GMT

press

at the answer that solved your problem

thanks

regards

Marco