topic Re: Set Analysis issue in Text box in QlikView

Set Analysis issue in Text box

Mon, 29 Jun 2015 07:21:10 GMT

Hi Everyone ,

I am writing the below Expression in Text box. when I select Particular month ,It is giving Correct value .I need the Same value Without Selecting Max month.

My requirement is by default it should show Max Month value.

=Num(Avg(Aggr((((Count({<Attr_Flag = {1}, Cal_Year={'$(vMax_Year)'}, Cal_Month=, Cal_Quarter=, Cal_Date={"<=$(=Max({$<Cal_Year={'$(vMax_Year)'}>}Cal_Date))"} >}Distinct [Employee Code])/
((Count({$<Cal_Month_Flag={1}, Cal_Year={'$(vMax_Year)'}, Cal_Month={'$(vMax_Month)'}, Cal_Quarter=, [Active Flag DayWise]={1}>}DISTINCT [Employee Code])+$(vTest))/2))/
Count({$<Cal_Year={'$(vMax_Year)'}, Cal_Month=, Cal_Quarter=, [Cal_Month ID]={"<=$(=Max([Cal_Month ID]))"}>}DISTINCT [Cal_Month ID]))*12),Cal_Month)),'#0.00%')

Any Suggestions would be greatly Appreciated.

Regards,

Divya

Re: Set Analysis issue in Text box

settu_periasamy — Mon, 29 Jun 2015 07:28:55 GMT

Hi,

Try this,

=Num(Avg(Aggr((((Count({1}{<Attr_Flag = {1}, Cal_Year={'$(vMax_Year)'}, Cal_Month=, Cal_Quarter=,

Cal_Date={"<=$(=Max({$<Cal_Year={'$(vMax_Year)'}>}Cal_Date))"} >}Distinct [Employee Code])/

((Count({1}{$<Cal_Month_Flag={1}, Cal_Year={'$(vMax_Year)'},

Cal_Month={'$(vMax_Month)'}, Cal_Quarter=, [Active Flag DayWise]={1}>}DISTINCT [Employee Code])+$(vTest))/2))/

Count({1}{$<Cal_Year={'$(vMax_Year)'},

Cal_Month=, Cal_Quarter=, [Cal_Month ID]={"<=$(=Max([Cal_Month ID]))"}>}DISTINCT [Cal_Month ID]))*12),Cal_Month)),'#0.00%')

Re: Set Analysis issue in Text box

avinashelite — Mon, 29 Jun 2015 07:29:26 GMT

Hi Divya,

Try to add = before all the variables and check once, if still facing same issue please post the app

Re: Set Analysis issue in Text box

Anonymous — Mon, 29 Jun 2015 07:31:52 GMT

Try to use ALL function like -

Max(ALL [Dimension])

Hope this helps.

Re: Set Analysis issue in Text box

Mon, 29 Jun 2015 07:35:52 GMT

Hi,

Thanks for the response, Still getting the same issue.

Re: Set Analysis issue in Text box

settu_periasamy — Mon, 29 Jun 2015 07:47:59 GMT

Can you post the sample data?

Re: Set Analysis issue in Text box

Anonymous — Mon, 29 Jun 2015 07:53:54 GMT

can you please share qvw..

Re: Set Analysis issue in Text box

buzzy996 — Mon, 29 Jun 2015 08:56:53 GMT

try tis,

=Num(Avg(Aggr((((Count({<Attr_Flag = {1}, Cal_Year={'$(vMax_Year)'}, Cal_Month={'$(vMax_Month)'}, Cal_Quarter=, Cal_Date={"<=$(=Max({$<Cal_Year={'$(vMax_Year)'}>}Cal_Date))"} >}Distinct [Employee Code])/
((Count({$<Cal_Month_Flag={1}, Cal_Year={'$(vMax_Year)'}, Cal_Month={'$(vMax_Month)'}, Cal_Quarter=, [Active Flag DayWise]={1}>}DISTINCT [Employee Code])+$(vTest))/2))/
Count({$<Cal_Year={'$(vMax_Year)'}, Cal_Month={'$(vMax_Month)'}, Cal_Quarter=, [Cal_Month ID]={"<=$(=Max([Cal_Month ID]))"}>}DISTINCT [Cal_Month ID]))*12),Cal_Month)),'#0.00%')