Discussion Board for collaboration related to QlikView App Development.
Hello, I'm currently building a table with set analysis instructions
The idea is to add the group column to a table, so using the Set Analysis field, set the filter in the operation:
'sum(' & SetAnalysis_Field & ' Volume)'
The concatenation works fine, but i can't make the formula work.
Any ideas of how to do this?
Hi, just for a quick response I noticed that you SetAnalysis_Field records are missing the "}" to close off the set analysis. Also try maybe sum($(SetAnalysis_Field)Volume)
thanks for pointing that out but the expression sum($(SetAnalysis_Field)Volume) didn't work
I don't think what you are trying will work. Set analysis is performed before the table is generated and therefore cannot give different values based on table fields.
add that closing brace
and try sum($(=SetAnalysis_Field)Volume)
if you want to select multiple groups together you will have to use
or you can do the string processing in variable and keep your set analysis expression cleaner