topic Re: use variable within set analysis in App Development

use variable within set analysis

Anonymous — Thu, 16 Feb 2017 08:26:19 GMT

Hi.

can anybody help me? )

MyFieldFromOtherTable	SumFieldFromOtherTable
95	100.00
96	200.00
97	300.00

MyFieldFromChart	calculation sum (((
95	here must be 100
96	here must be 200

This construction works in chart: Sum({<MyFieldFromOtherTable={95}>} SumFieldFromOtherTable) (in all row sum equal 100 )

This construction don't works in chart: Sum({<MyFieldFromOtherTable={MyFieldFromChart}>} SumFieldFromOtherTable)

Re: use variable within set analysis

jonathandienst — Thu, 16 Feb 2017 13:25:16 GMT

It depends on how MyFieldFromChart is defined. you could try

Sum({<MyFieldFromOtherTable={'$(MyFieldFromChart)'}>} SumFieldFromOtherTable)

Sum({<MyFieldFromOtherTable={"$(=MyFieldFromChart)"}>} SumFieldFromOtherTable)

If these do not work, I suggest you post more detail about the variable and your data model. the best would be a small sample qvw/qvf file that illustrates the problem.

Re: use variable within set analysis

Anonymous — Thu, 09 Mar 2017 14:34:23 GMT

Sorry for the pause.

both variants don't work

(Sum({<MyFieldFromOtherTable={'$(MyFieldFromChart)'}>} SumFieldFromOtherTable) and Sum({<MyFieldFromOtherTable={"$(=MyFieldFromChart)"}>} SumFieldFromOtherTable)

Re: use variable within set analysis

karthiksrqv — Fri, 10 Mar 2017 06:22:48 GMT

Hi Ihor,

In the sample you have provided, the 2 tables are not linked. You could link the 2 tables and then use a simple sum(SumFieldFromOtherTable).

table1:

Load * Inline [

MyFieldFromOtherTable,SumFieldFromOtherTable

95,100.00

96,200.00

97,300.00

];

table2:

Load * Inline [

MyFieldFromChart,MyFieldFromOtherTable

96,96

95,95

];

Re: use variable within set analysis

Anonymous — Fri, 10 Mar 2017 09:27:06 GMT

Could of course. But I did not want to be through a link. It was other task.

I think "set analysis" can not cope.

Thank you all )))))