Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kishoreravi1983
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

Labels (5)
3 Replies
sunny_talwar

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
Contributor III
Contributor III
Author

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

 

 

sunny_talwar

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