Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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

3 Replies
Highlighted

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??

Highlighted
Contributor III
Contributor III

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

 

 

Highlighted

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