topic Calculated Dimension date set analysis in QlikView

Calculated Dimension date set analysis

Mon, 15 Apr 2013 12:15:51 GMT

Hi All

I have a date Calculated dimension which returns for my table only this and last FY.

As this is a calc dimension if I select 2013 it is reducing the data to only the one FY. I would like it to show always the two FY as per the calc date Dimension regardless of the date selections.

I have sucessfuly performed Set analysis for expresssions - however am struggling for the calc dimension.

I have been playing with the below logic - could someone point me in the right direction pls.

=if(FinancialYear=vCurFY,vCurFY, If(FinancialYear=VCurFYPrev,VCurFYPrev))

//=if({<FinancialYear = {$(CurFY))} ,

DateVal=,FinancialYear=,

FinancialPeriod=,

FinancialWeek = >}

Thanks

Re: Calculated Dimension date set analysis

alexandros17 — Mon, 15 Apr 2013 12:32:20 GMT

in set analysis if you want to exclude a selection for example myField you have to

Example:

sum of myVal not considering selection of myField:

sum({$<myField=>} myVal)

hope it helps

Re: Calculated Dimension date set analysis

Mon, 15 Apr 2013 13:53:55 GMT

Thanks for your response.

The field I want to exclude selectio0ns from is a Date so Im not sure how to set the expression out.

Thanks