Set expression problem

[sarasunagaram]

Hi All,

Set expression is not working properly ,it is giving zero values.

vperiod-SubField(PeriodWeek,'-',2)

Exp: sum({<Period={"$(vperiod)"}>}Sales)

Please find the attached app an data.

Thanks in Advance.

Muni

[sarasunagaram]

Hi Rakesh ,

I have some other filters in my set expression.how can give those as well.

[boorgura]

if they are based on Period week, adjust the if condition accordingly. Else, you can combine the  if with a set expression.

SUM({<set_expression>} if(condition, Sales)

OR

SUM(if(condition_1 and condition_2, Sales)

[sarasunagaram]

This is the sum({$<Period ={"<=$(=Only({<Week,Month>}subfield(PeriodWeek,'-',2) ))"}>} Sales)  expression using in my chart

[boorgura]

what exactly are you trying to achieve here?

[sarasunagaram]

here regardless of my week and month show data according to that row period. my dimension is periodweek. Problem is period is not able  to compare with sub field value.

[boorgura]

please confirm - if this is what you want.

If period is 03,06,09 or 12  sum(Sales)/5 else sum(Sales)/4.

That's it? Or any other criteria?