How to write a set analysis

[kunkumnaveen]

Hello all,

I need to show year start  month to selected month sales .

if apr-17 is selected then jan 17 to apr-17 sales need to be shown in bar chart

How to write this in set analysis...

Thanks

[andrey_krylov]

Hi, try this

{< Month_Year, Date = {"$(='>=' & YearStart(Max(Date)) & '<=' & Date(Max(Date)))"} >}

[kunkumnaveen]

If only a year 2017 is selected then  jan to dec Months are showing  as below

sum({<Floor_Month_year={">=$(=floor(YearStart(Max(Floor_Month_year))))<=$(=floor(Max(Floor_Month_year)))"}>}Sales)

But when i selected any month (Apr-17) instead of showing Jan-17 to Apr-17 i getting below screen

I think i need to change some where in my expression

sum({<Floor_Month_year={">=$(=floor(YearStart(Max(Floor_Month_year))))<=$(=floor(Max(Floor_Month_year)))"}>}Sales)

Any help regarding this

[kunkumnaveen]

Any help on this issue plz

[andrey_krylov]

The better way is to create a textbox and see what these expressions give you

=floor(YearStart(Max(Floor_Month_year)))

=floor(Max(Floor_Month_year))

and  what you have in Floor_Month_year

[kunkumnaveen]

Hello,i did check that

both the expression are giving the correct values individually  but when i combined them in a set analysis i am not getting the required output .

Did u see any issue in my expression .

sum({<Floor_Month_year={">=$(=floor(YearStart(Max(Floor_Month_year))))<=$(=floor(Max(Floor_Month_year)))"}>}Sales)

before any month selection it is working fine ,the issue is when i select any month

[andrey_krylov]

Can you post these values?

[kunkumnaveen]

When only Year(2017) is selected

when Year(2017) and Month(Apr) is selected

[juraj_misina · Accepted solution]

You also need to ignore your other filters, because your expression is now filtered by the Floor_Month_year field:

sum({<Floor_Month_year={">=$(=floor(YearStart(Max(Floor_Month_year))))<=$(=floor(Max(Floor_Month_year)))"}, Year, Month, YearMonth, Datenum>}Sales)

[andrey_krylov]

Hi, Juraj. You're right, I just can't figure out how the april selection gives january in the chart