Parameters in set analysis

[Anonymous]

Hi All,

When trying to use a parameter in the set analysis facing some issues.

below is the variable am creating

set vExpression =

num(Avg({<[KPI] = {$1},Year=,Month=,Day=,[Date],[Date]={">=$(=Num($(=vToDate& 'Start(Max(Date))'))) <=$(=Max(Date))"}>} Actual),$3)

and using =$(vExpression ('KPI1','#.##')). But it's not working. When I placed it in straight table and hovered the expression

>=$(=Num($(=vToDate& 'Start(Max(Date))'))) <=$(=Max(Date)) is being showed as >= <=.

I also tried passing 'Start(Max(Date))' as $3 . But the result is same.

The value of vToDate will be Day/Week/Month

Can someone explain what I am doing wrong.

[sunny_talwar]

Where is $2? You have used $1 and $3?

[Anonymous]

Sorry Sunny,

At first i tried,

set vExpression =

num(Avg({<[KPI] = {$1},Year=,Month=,Day=,[Date],[Date]={">=$(=Num($(=vToDate& $2))) <=$(=Max(Date))"}>} Actual),$3)

and used $(vExpression ('KPI1','Start(Max(Date))','#.##')).

Later I tried ,

set vExpression =

num(Avg({<[KPI] = {$1},Year=,Month=,Day=,[Date],[Date]={">=$(=Num($(=vToDate& 'Start(Max(Date))'))) <=$(=Max(Date))"}>} Actual),$2)

and used $(vExpression ('KPI1','#.##')).

Neither of them worked.

[sunny_talwar]

Would you be able to share a sample?

[Anonymous]

Please find the attachment.

When hovered on the straight table, the value is incorrect.

[sunny_talwar]

But where is $2? I am not sure what the idea is here? Where does Start(Max(Date)) this go?

[Anonymous]

In the variable vexpression code, you can find $1,$2,$3. Am not sure if i missed anything.

[sunny_talwar]

Got it... and what is vToDate here?

[Anonymous]

Its value will be Day/Month/Year based on button clicks which i didnt implement in the sample qvw.

[sunny_talwar]

Can you give me a static value to test this out?