topic Sets with multiple fields in the condition using variable in QlikView

Sets with multiple fields in the condition using variable

shyamcharan — Tue, 29 Mar 2016 00:57:14 GMT

Hi Experts,

How can I include multiple fields in the sets using the variable?

I am trying the below but it is not working.

Sum({<$(vStaffOfficerfields)>}ResponseMin)/Sum({<$(vStaffOfficerfields)>}ResponseCase)

vStaffOfficerfields = 'InternalStaff,ExternalStaff,Contractors,Executives,NonExecutives,OutsideStaff'

InternalStaff,ExternalStaff,Contractors,Executives,NonExecutives,OutsideStaff are fields with different staff names.

I am trying to create a summary value to ignore all the selections made on these staff fields. However, since the number of fields are more, i am trying to put them in a variable and call them through the variable for easy maintenance.

Can anyone suggest how can I get this correct?

Thanks in advance.

Regards,

Shyam.

Re: Sets with multiple fields in the condition using variable

Anonymous — Tue, 29 Mar 2016 04:05:46 GMT

Try add "Total" after sum (total.

Re: Sets with multiple fields in the condition using variable

settu_periasamy — Tue, 29 Mar 2016 04:26:35 GMT

Hi,

try to remove the single quote and check it. It will show the error line, just ignore it..

Re: Sets with multiple fields in the condition using variable

shyamcharan — Wed, 30 Mar 2016 03:12:44 GMT

Thanks settu.