Regarding the Multiple Expression in the KPI

[Sunilkumar3]

Hi,

I want. to show Multiple Expression in the KPI.

Example:

By default :-

Sum({<Flag = {'YTD'}>}Sales)

if  Month_year  Dimension  Selected then Sum(Sales)

So how to write the Expression in the KPI 

Thanks & Regards,

Sunil Kumar

[mominh_uzaifa · Accepted solution]

Hello

Try this

if(GetSelectedCount(Month_year)>0,Sum(Sales),Sum({<Flag = {'YTD'}>}Sales))

Thanks & Regards,

Huzaifa Momin

[sarafoster]

You can use the "if" function to create a conditional expression in your KPI that displays the YTD sales when the "Flag" dimension is selected, and the monthly sales when the "Month_year" dimension is selected. Here's an example expression:

if(GetSelectedCount(Flag) > 0, Sum({<Flag={'YTD'}>}Sales), if(GetSelectedCount(Month_year) > 0, Sum(Sales), 0))

This expression checks if either "Flag" or "Month_year" dimensions are selected, and based on that, calculates the corresponding sales value. If neither of these dimensions are selected, it will return a value of 0.   UMR.com