variable in set analysis P() and E()

[carolin01]

Hi,

I´ve tried two functions as a variable:

if(GetSelectedCount(OTDStage)>1, '',

  if(GetSelectedCount(OTDStage)=0, '',

  if(GetFieldSelections(OTDStage) = '1. Earlier -5', '1. Earlier -5',

  if(GetFieldSelections(OTDStage) = '2. On Time -3 / 0 Days', '2. On Time -3 / 0 Days',

  if(GetFieldSelections(OTDStage) = '3. On Time -3 / + 1 Day' , '3. On Time -3 / + 1 Day',

  if(GetFieldSelections(OTDStage) = '4. On Time -3 / + 2 Days', '4. On Time -3 / + 2 Days',

  if(GetFieldSelections(OTDStage) = '5. On Time -5 / 0 Days', '5. On Time -5 / 0 Days',

  if(GetFieldSelections(OTDStage) = '6. On Time -5 / + 1 Day', '6. On Time -5 / + 1 Day',

  ''))))))))

Result example in Qlik View text box: 1. Earlier -5

or     

=if(GetSelectedCount(OTDStage)>1, '',

if(GetSelectedCount(OTDStage)=0, '',

if(GetFieldSelections(OTDStage) = '1. Earlier -5', chr(39) & '1. Earlier -5' & chr(39),

if(GetFieldSelections(OTDStage) = '2. On Time -3 / 0 Days', chr(39) & '2. On Time -3 / 0 Days' & chr(39),

if(GetFieldSelections(OTDStage) = '3. On Time -3 / + 1 Day' , chr(39) & '3. On Time -3 / + 1 Day' & chr(39),

if(GetFieldSelections(OTDStage) = '4. On Time -3 / + 2 Days', chr(39) & '4. On Time -3 / + 2 Days' & chr(39),

if(GetFieldSelections(OTDStage) = '5. On Time -5 / 0 Days', chr(39) & '5. On Time -5 / 0 Days' & chr(39),

if(GetFieldSelections(OTDStage) = '6. On Time -5 / + 1 Day', chr(39) & '6. On Time -5 / + 1 Day' & chr(39),

''))))))))

Result example in Qlik View Text Box: '1. Earlier -5'

Now I´ve a simple function that uses the variable:

sum({$<OrderPhase_Desc = {'Revenue'}, OnTimeDelivery = {'$(=vOTDStage)'} >}NettAmount$(vCurrency))

The result is zero in Qlik Sense, not showing what I´m doing wrong. I´m sure I´m just overlooking something but I just can´t see it right now... As a second step I would like to replace the field "OnTimeDelivery" by another variable. Is that possible? I haven´t tried it before and I´m still stucked with the first one.

Many thanks for your help!!

[sunny_talwar]

Carolin -

I am glad we were able to help you learn something new today

Happy New Year!!

Best,

Sunny