topic Problem in set analysis in QlikView

Problem in set analysis

Mon, 29 Feb 2016 13:15:45 GMT

Hi ,

My set analysis setup based on month. quarter ,year. i am caluculating total usage based on FY. I am getting total usage wrong but if i select based on quarter the results are correct. Can any help with this please.

i used below expression for TOTAL

=num(((sum({<STAFF_TYP_CD = {'CV'}

,FTE_YEAR={'$(vCurrentFY)'}

,JOIN_DT=

,Month=

,PPED=

,CY_YEAR=

,FISCAL_YEAR=

,CY_YRMO=

,FY_YRMO=

,MonthYear=

>}TOT_HRS_USG)

+

sum({<STAFF_TYP_CD = {'CC'}

,FISCAL_YEAR={'$(vCurrentFY)'}

,JOIN_DT=

,Month=

,PPED=

,CY_YEAR=

,CY_YRMO=

,FY_YRMO=

,MonthYear=

>}TOT_HRS_USG))/2080)

,'###,###.###')

Re: Problem in set analysis

sunny_talwar — Mon, 29 Feb 2016 18:32:07 GMT

The expression seems to look fine, do you have a sample to look into?