Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Check the attached now
Where is $2? You have used $1 and $3?
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.
Would you be able to share a sample?
Please find the attachment.
When hovered on the straight table, the value is incorrect.
But where is $2? I am not sure what the idea is here? Where does Start(Max(Date)) this go?
In the variable vexpression code, you can find $1,$2,$3. Am not sure if i missed anything.
Got it... and what is vToDate here?
Its value will be Day/Month/Year based on button clicks which i didnt implement in the sample qvw.
Can you give me a static value to test this out?