topic Re: Set Analysis Syntax in QlikView

Set Analysis Syntax

kishoreravi1983 — Sat, 16 Nov 2024 20:40:05 GMT

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

Re: Set Analysis Syntax

sunny_talwar — Fri, 14 Jun 2019 11:46:56 GMT

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

Re: Set Analysis Syntax

kishoreravi1983 — Mon, 17 Jun 2019 06:05:58 GMT

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

sunny_talwar — Mon, 17 Jun 2019 11:43:40 GMT

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