topic Dynamic set analysis based on table in QlikView

Dynamic set analysis based on table

Tue, 24 Mar 2015 23:43:06 GMT

Hello, I'm currently building a table with set analysis instructions

Group	SetAnalysis_Field
Red group	{$<Color={"Red"}>
Blue Group	{$<Color={"Blue"}>
Green Group	{$<Color={"Green"}>

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?

Thank you.

Re: Dynamic set analysis based on table

Anonymous — Tue, 24 Mar 2015 23:54:28 GMT

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)

Re: Dynamic set analysis based on table

Wed, 25 Mar 2015 03:01:09 GMT

thanks for pointing that out but the expression sum($(SetAnalysis_Field)Volume) didn't work

Re: Dynamic set analysis based on table

shanemichelon — Wed, 25 Mar 2015 03:22:43 GMT

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.

Re: Dynamic set analysis based on table

Anonymous — Wed, 25 Mar 2015 04:16:38 GMT

add that closing brace

and try sum($(=SetAnalysis_Field)Volume)

Re: Dynamic set analysis based on table

Anonymous — Wed, 25 Mar 2015 04:21:46 GMT

if you want to select multiple groups together you will have to use

concat function

Group	SetAnalysis_Field
Red group	Red
Green Group	Green
Blue Group	Blue

{$<Color={$('"'&=concat(SetAnalysis_Field, ',')&"'")}>Volume)

or you can do the string processing in variable and keep your set analysis expression cleaner