Sum With Condition

[Chanty4u]

Hi All,

I want  exclude only actual value for max quarter 

in the attached app i have mentioned the requirment and result too,

[Anil_Babu_Samineni]

How about this?

Sum({<Quarter={"$(=MaxString(Quarter))"}>} Forecast)

[Chanty4u]

No anil.  its showing only for max sum forecast i need  both selected means

max quarter forecast and other selected actual

[qlikviewwizard · Accepted solution]

Hi Chanty 4u

Try like this.

=max({<Quarter={$(=concat(chr(39) & Quarter & chr(39),',') )}>}Actuals)+max({<Quarter={$(=concat(chr(39) & Quarter & chr(39),',') )}>}Forecast)

[tresesco]

This?

RangeSum(Sum({<Quarter={'$(=maxstring(Quarter))'}>}Forecast),Sum({<Quarter-={'$(=maxstring(Quarter))'}>}Actuals))

[Chanty4u]

thanks Tresesco B

this is my original expression  how can i incorporate in this?

if(Quarter=vMaxQtr  and  otherQtr Selection ,$(vFc)+$(vAc))

[tresesco]

You might have to create two new variables for this, because you need to include set analysis in it.

[raviityou]

please find attached file,

[Chanty4u]

this is my original expression  how can i incorporate in this?

here how can i use and condition in if  ?

=IF(Quarter = vNewMaxQtr,(($(vFCYOYServ)-$(vACTYOYServ)) / $(vACTYOYServ))

,

if(Quarter =$(vQtr) and Quarter=vNewMaxQtr, ($(vFCAMultiple)- $(vACTYOYServ))/$(vACTYOYServ),(($(vCurACTYOYServ)-$(vACTYOYServ)) / $(vACTYOYServ))) )

second if i not working   

vQtr = Quarter field  only

vNewMaxQutr = 2018Q3

[pintucs20]

Hi ,

can you share excel sheet of data.