Problem with Only function

[Anonymous]

Hi community,

I have a trouble using only function in a chart expression. My dimension is dimension1, and my expression is like:

=sum({<flag={'1'}, dimension2={'$=(Only(dimension1))'}>} Sales)

dimension1 and dimension2 are same format, result of MonthName function in script.

I tried with ' and " and without them, but still not working.

I'd appreciate any help. Thanks.

Marc.

[MK_QSL]

Try

=sum({<flag={'1'}, dimension2={"=dimension2 = dimension1"}>} Sales)

[Anonymous]

Thanks Manish, but it works only for one unique value selected in dimension1.

[MK_QSL]

Provide few lines of sample data.. may be 5-6 enough

[Anonymous]

Manish, PFA.

I've excluded flag dimension to make it easy.

Marc

[MK_QSL]

Create a Chart

Dimension

Dimension1

Expression

SUM(IF(dimension1 = dimension2,Sales))

[Anonymous]

Yes, it works here but it is not going fine with the other conditions in the set analysis. Tomorrow I will prepare another sample data with more info and fields to analize it deeper.

Thanks a lot, Manish.

Marc.

[Anonymous]

Manish,

PFA.

The white background zone is the expected value (linked to an alternate estate). Total in left table for november 2014 should match the value in the right side.

Thanks.

[MK_QSL]

I am finding difficulties to understand due to field name... Could you please create a sample excel file with expected output?

[Anonymous]

Sorry Manish. I've renamed field. You could see expected output for november 2014 in the table added in the right side.

Thanks.