topic Set analysis based on multibox selection in QlikView

Set analysis based on multibox selection

Thu, 11 Aug 2011 07:53:44 GMT

Hi,

I am making use of a set analysis function for an expression. A field 'name' can be selected by a multibox, but does not always have a selection. I would like to base the set analysis on the selection of 'name' in the multibox, ONLY when there are one or more names selected.

So the set analysis looks like:

sum({< name=, eng_partner_name={name}, eng_costcenter_key = {$(vCostCenter)}, emp_level = {'junior'}>} timeAmount)

The current problem with this set analysis is that none of the 'eng_partner_name' records are selected when there has been no selection on the multibox.

How to get this fixed?? I prefer to avoid if functions.

Set analysis based on multibox selection

klausskalts — Thu, 11 Aug 2011 08:58:47 GMT

This might not be what you are looking for - but when I this "problem" it's normally because I do not want the cagrt to calculate at all before selections have been made.

If this is the case I suggect that to setup a Calculation condition in the General Tab in the Chart Properties.

e.g. Count(distinct [Field]) >=1

and in the Error Messages you state that a selection must be made before the chart/table will show any value.

OK?

Set analysis based on multibox selection

lironbaram — Thu, 11 Aug 2011 09:09:58 GMT

hei

try this

sum({< name=, eng_partner_name=P(name), eng_costcenter_key = {$(vCostCenter)}, emp_level = {'junior'}>} timeAmount)

what it does it check if eng_partner_name is in the possible values of name

Set analysis based on multibox selection

Fri, 12 Aug 2011 08:42:32 GMT

This works perfectly Liron!

Never heard of that function before, but I'll keep it in mind.

Thanks!