Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
kishoreravi1983
New Contributor III

Set Analysis Syntax

Hi Team,

Can you Please help me to fix this expressions.

Actual Expression:

=sum({$*<Version = {'AOP'}, KPI_Attribute_1 = {'Numerator'}, KPI_Attribute_2 = {'$(v_Aggregate_On)', 'Auto'}, Year =, Quarter=, Month=, %FiscalPeriod.KEY = {'$(vCurrentYear)0$(vCurrentMonth)'}>}[# Measure])

Need to Replace Variables with Actual Variable Exp. Bez its not working in Alternate states

vCurrentYear =right(max({<Version = {'ACT'}>}%FiscalPeriod.KEY), 2)

vCurrentMonth =left(max(%FiscalPeriod.KEY), 4)

I am Trying this

=sum({$*<Version = {'ACT'}, KPI_Attribute_1 = {'Numerator'}, KPI_Attribute_2 = {'$(v_Aggregate_On)', 'Auto'}, Year =, Quarter=, Month=, %FiscalPeriod.KEY ={$(="left(max(%FiscalPeriod.KEY), 4)")},
 %FiscalPeriod.KEY = {$("=right(max({<Version = {'ACT'}>}%FiscalPeriod.KEY), 2)")}>}[# Measure])

Can some one help me to fix this it would be very great help.

Regards,

Ravi

Tags (1)
3 Replies

Re: Set Analysis Syntax

Your year is only 2 characters and Month is 4?

vCurrentYear =right(max({<Version = {'ACT'}>}%FiscalPeriod.KEY), 2)

vCurrentMonth =left(max(%FiscalPeriod.KEY), 4)

Or is it the other way around??

kishoreravi1983
New Contributor III

Re: Set Analysis Syntax

Hi Sunny,

Sorry it was my copy paste mistake the community. not at expression level.

What ever is  in the variable  need to fit directly in expression.

Regards,

Ravi

 

 

Re: Set Analysis Syntax

How exactly does your field %FiscalPeriod.KEY look like? Would you be able to share a screenshot of a list box on %FiscalPeriod.KEY