topic Set Analysis - Get List of current selections into specific field in QlikView

Set Analysis - Get List of current selections into specific field

Sat, 25 Sep 2010 17:32:58 GMT

Hi Guys,

The following expression works, but How do I change the values in the list, to the list of selected values in a specific field?

=Sum( {$ < [SalesTargets.STMonth] = {'01', '02', '05'} > } SalesTargets.Quant)

=Sum( {$ < [SalesTargets.STMonth] = { IvMontNo } > } SalesTargets.Quant) I have tried this but it is not working.

Thanks in advance,

Aldo.

Miguel_Angel_Baeyens — Sat, 25 Sep 2010 20:03:59 GMT

Hello Aldo,

You can use the following

=Sum( {$ < [SalesTargets.STMonth] = P(IvMontNo) > } SalesTargets.Quant)

Hope that helps.

Sat, 25 Sep 2010 20:44:31 GMT

Hi there,

The following seems to be working:

=Sum( {<[SalesTargets.STMonth] = {$(=GetFieldSelections(IvMonthNo, ',',12))} >} SalesTargets.Quant)

I tried: =Sum( {$ < [SalesTargets.STMonth] = P(IvMonthNo) > } SalesTargets.Quant) but it is not working. What's the meaning of P ?

Thanks,

Aldo.

Miguel_Angel_Baeyens — Sat, 25 Sep 2010 20:59:01 GMT

Hi,

P() is used in set analysis to get all possible values in one field while E() is used to get all excluded values for the specified field.

On the other hand, GetCurrentSelections will work, although if you use it for non-numeric fields you will need to quote values

chr(39) & GetFieldSelections(Field, chr(39) & ',' & chr(39), 12) & chr(39)

So the final result look like

'A', 'B', 'C'

Regards.

Sat, 25 Sep 2010 21:04:01 GMT

Thanks man.