Chart implementation with condition

ashmitp869 — Fri, 07 May 2021 02:19:49 GMT

Hi there,

I have two text box ,

When click one text box, I need to show chart with expression .

So created a variable vSelect1

Expression1 :

sum({$<Measure_PPH={1},Month=,MonthYear=,[Date]={">=$(=vMinReportingDate)<=$(=vMaxReportingDate)"}>} [AP.Measure_LOS])

and when the other text box is selected, the below expression need to work

sum({$<Measure_PPH={1},Month=,MonthYear=,[Date]={">=$(=vFYStart)<=$(=vMaxReportingDate)"}>} [AP.Measure_LOS])

and dimension : PPH_condition

I used conditional expression : GetSelectedCount(vSelect1) = 1 , but its not working.

Please assist with suggestion.

Re: Chart implementation with condition

MayilVahanan — Fri, 07 May 2021 04:31:27 GMT

I hope you have trigger to assign the value to the variable (vSelect1) when you select the text box.

In that case, try like below

In Conditional tab.

vSelect1 =1

or you can try one expression by using if condition something like

If(vSelect1 =1, sum({$<Measure_PPH={1},Month=,MonthYear=,[Date]={">=$(=vMinReportingDate)<=$(=vMaxReportingDate)"}>} [AP.Measure_LOS]),

sum({$<Measure_PPH={1},Month=,MonthYear=,[Date]={">=$(=vFYStart)<=$(=vMaxReportingDate)"}>} [AP.Measure_LOS]))