No data to be displayed

[#1]

Hello Experts,

I have a requirement. I have a couple of list boxes (List boxes A, B , C, D say) in a sheet. and then there are few charts (say X, Y, Z).

The problem statements is when any value is selected from List box A, Chart X shouldn't show any data even though it has relevant data to be shown. And again when any value from List Box B is selected, then Chart Y shouldn't show any data  even though it has relevant data to be shown. And in any other time if none of the value is selected from either A or B, both the graph should act as usual. And if list boxes C or D is selected, the graphs should still show data.

Please help.

[MayilVahanan]

Hi

Without view the data model and sample file, its difficult to give solutions. Can you please provide a sample file?

[#3]

Thanks for the response.

Please find attached a sample file.

Thanks

[Anonymous · Accepted solution]

Bikash,

You can use Calculated Condition (or Show Condition to hide the charts completely), and use GetSelectedCount() as condition.  For example, calculated condition for chart X would be

GetSelectedCount(A)>0

or even simply GetSelectedCount(A) - it implies ">0"

I hope you'll figure out the rest.

Regards,

Michael

Edit: I got it just the opposit way, the condition for X is GetSelectedCount(A)=0  (that is, no selections)

Edit 2: See attached, I added calclution conditions to charts X and Y

[israrkhan]

Hi Bikash,

on chart properties>> general tab>> calculation condition, use expression, for example :

let say for Chart X,  you can write like, =count(distinct A)>=1,

mean when 1  or more values will be selected in list A then it will be calculated. and you can show a message to user to select 1 or more values from list A to see the data.

you can manage the others in same way...

[MayilVahanan]

Hi

Try like this

GetSelectedCount(Revenuefacttable.BillToName) = 0 In calculation condition.

Its helps.

[#7]

Thanks for the response.

Really appreciate it.

[#8]

Great! It worked. Thanks and appreciate it.