Chart should be static irrespective of selection

[bharani8]

Hi Experts - I have a quick clarification...

In the attached qvw... i have a Calculated Date field (Plz forget the logic in that expression )

Now my requirement is , When i select the date in that Multibox... i dont want any corresponding selection to happen in the chart below .... Strictly plz suggest other than ALTERNATIVE STATE

[sunny_talwar]

You can use Sum({1}Value) and then no selection will impact your chart

[sunny_talwar]

Or this to ignore selection in just YDAY field

Sum({<YDAY>}Value)

[devarasu07]

Hi,

Try like this (just ignore Date the selection from your chart object using set analysis method)

sum( {<YDAY=>}Value)

[bharani8]

Hey Sunny - TY!

In this dummy DB it is working fine... but same logic it is not working my original DB ...

In my main DB.. i have a Month field created with below Exp...

=if((right(Date(if(YDAY=Aggr( NODISTINCT Max(YDAY),Month_Name, Year_Name),YDAY),'MM/DD/YYYY'),4) &

     lEFT(Date(if(YDAY=Aggr( NODISTINCT Max(YDAY),Month_Name, Year_Name),YDAY),'MM/DD/YYYY'),2)) = CALENDAR_YEAR_MONTH_CD,

MonthName((if(YDAY=Aggr( NODISTINCT Max(YDAY),Month_Name, Year_Name),YDAY))))

and in the chart ,i have 3 expressions... How do i make this chart static.. irrespective of any month selected ??

[sunny_talwar]

May be you need to ignore selection in YDAY, Month_Name and Year_Name... the best way to know is to make a selection and see what all fields have selection in the current selection box. Ignore selection in all those fields to make it static when you select in the above

[vvvvvvizard]

Good day

Right click the obkect and choose detach

[bharani8]

Yes.. Same thing i followed... I see 4 fields selected in the Current selection box...

So i gave in all the 3 expression as below..

Exp1 -->sum({<CALENDAR_YEAR_MONTH_CD = ,YDAY = ,Month_Name = ,Year_Name = >}[Financial Plan])

Exp2-->Sum({<CALENDAR_YEAR_MONTH_CD = ,YDAY = ,Month_Name = ,Year_Name = >}[MTD Shipments])

Exp3-->=(Sum({<CALENDAR_YEAR_MONTH_CD = ,YDAY = ,Month_Name = ,Year_Name = >}[MTD Shipments])/Sum({<CALENDAR_YEAR_MONTH_CD = ,YDAY = ,Month_Name = ,Year_Name = >}[Financial Plan]))

Still i see the chart is changing when i select the Month..

[bharani8]

But there are few other selections for which i need the chart to change

[bharani8]

Any Idea stalwar1‌ ?