Chart implementation with condition

[ashmitp869]

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.

[MayilVahanan · Accepted solution]

HI @ashmitp869 

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]))