Using Text as Field in Sum function

[chhavi376]

Hi All,

I cannot share the QV file but i am explaining a scenario where i am stuck.

There is one field in the data:

TYPE

c1

c2

c3

c4

ANd there is another table in my data like:

c1    c2    c3    c4

1      1        0        1

1      0        1        1

I want a table(on UI) like:

Type          sum()

c1            2

c2            1

c3            1

c4            2

So i am trying to use SUM(fieldvalue('Type',RowNo)) function to get the sum. The problem is that QV is not able to identify that the return value of fieldvalue() function is a column name.

[chhavi376]

PFA--

[tresesco]

I could not really find the issue. Could you please explain a bit more about the issue w.r.t. the sample file shared?