Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
In our requirement i have one list box called 'business' and values called 'generic' and 'safety' .
on behalf of generic i want to show charts and on behalf of safety another chart in same sheet.
kindly guide how to conditionally i can do this scenario.
Thanks.
Virendra
Hi,
You can write in expression sett analysis.
Chart1:
In dimension,
Fieldname
In Expression,
Sum({<business={'generic'} >} value_field)
Chart2:
In dimension,
Fieldname
In Expression,
Sum({<business={'safety'} >} value_field)
You can use this in your chart's conditional show expression:
GetFieldSelections(business) = 'generic' for 1st chart and
GetFieldSelections(business) = 'safety' for 2nd chart
HTH
Best,
Sunny
You can conditionally show or hide objects, in the properties layout tab set conditional show and an expression.