topic set analysis in QlikView

set analysis

Wed, 16 May 2012 16:06:03 GMT

Hi,

I'm starting with set analysis.

I did a formula = Sum ({<[Fiscal Year-Month]={"2012/05"}>}[Commit Demand])/1000

It's working.

I try to replace {"2012/05"} by a field and it's not working.

= Sum ({<[Fiscal Year-Month]=[Current Fiscal Year-Month]>}[Commit Demand])/1000

= Sum ({<[Fiscal Year-Month]={[Current Fiscal Year-Month]}>}[Commit Demand])/1000

Someone can help me?

Thanks.

Eva

Jason_Michaelides — Wed, 16 May 2012 16:12:50 GMT

Hi Eva,

Try:

= Sum ({<[Fiscal Year-Month]={$(=Only([Current Fiscal Year-Month])}>}[Commit Demand])/1000

Hope this helps,

Jason

Wed, 16 May 2012 16:23:06 GMT

Hi Jason,

Thanks for your answer, Unfortunately, It's not working neither :'(

It tried your formula

= Sum ({<[Fiscal Year-Month]={$(=Only([Current Fiscal Year-Month])}>}[Commit Demand])/1000

tihs one :

= Sum ({<[Fiscal Year-Month]={$(=Only([Current Fiscal Year-Month]))}>}[Commit Demand])/1000

and

=Only([Current Fiscal Year-Month]) give the right value.

Wed, 16 May 2012 17:06:17 GMT

= Sum({<[Fiscal Year-Month]= {"$(=Only([Current Fiscal Year-Month]))"} >}[Commit Demand])/1000

Jason_Michaelides — Wed, 16 May 2012 17:08:19 GMT

Isn't that the same as the answer I gave you?

Wed, 16 May 2012 17:37:57 GMT

I jsut added from yours

Sum({<[Fiscal Year-Month]= {"$(=Only([Current Fiscal Year-Month]))"} >}[Commit Demand])/1000

Jason_Michaelides — Wed, 16 May 2012 21:11:30 GMT

Ah.