Variable in Filter Selection

[kishores]

Hi Team,

We have a query to get the Delta values between multiple expressions.

For example, we have a 5 expressions and wants to check the delta value between these 5 values.

So, I have taken two INLINE tables A & B with same 5 expression labels , but unable to get an approach get the delta value(A-B)

Table A:

Load * INLINE [

A

1

2

3

4

5

];

Table B:

Load * INLINE [

B

1

2

3

4

5

];

1 - 5 are labels of each expression.

Now created a variable A as vA = A & vB = B.

After this , when I check with vA-VB, not getting any values.

So, please help me how to get the correct Delta values.

Thanks,

Kishore S

[kishores]

Hi Team,

Forgot to mention in above post that

We have to use filters A,B and depending on the Label selection in the filters, we have to get the Bar chart value.

Kishore S

[gmenoutis]

So you say A and B are labels of expressions. How are the fields that contain the *Actual* expression named?

[kishores]

Hi,

Expressions would be like

Sum({<Year ={2017}>}Amt) , Label as 2017 Actual

Sum({<Year ={2019}>}Amt), Label as Forecast

Like as above , we have multiple expressions (written as per our data) 

Table A:

Load * INLINE [

A

2017 Actual

Forecast

];

Table A:

Load * INLINE [

B

2017 Actual

Forecast

];

Delta = A-B

Here, this delta will be apply as per selection on Table A,Table B. THIS DELTA SHOULD BE CHANGE AS PER FILTER SELECTION .

NOTE: WE DON'T WANT MULTIPLE DELTA'S EXPRESSION, IT SHOULD BE ON FLY DEPENDING ON SELECTIONS.

Ex: 2017 Actual(Table A) - Forecast (Table B) 

Thanks

Kishore S

[gmenoutis]

This can be done using the evaluation operator, but still you have to save the expressions *somewhere*.  Maybe something like this:

Table A:

Load * INLINE [

A, A_formula

2017 Actual,Sum({<Year ={2017}>}Amt)

Forecast,Sum({<Year ={2019}>}Amt)

];

Will this be possible? If yes, we can find a way.

[kishores]

These expressions, we are taking in a bar chart.

I have tried the sample which you have shared but not getting the Delta .

Can you please check something and share qvf file (If it works )?.

Thanks

Kishore S

[gmenoutis]

I did not give an answer. I am asking you where the expressions will be stored. They have to be stored inside the data model. If you do this, I can work out a solution for you.

[kishores]

Hi,

Sorry and No these are not stored in Data model., created at  UI level.

Thanks,

Kishore S