how to reflect my charts based on selection?

[gkcchowdary]

Hi

I have product,customer,country,region, year  fields.and i am creating two charts.one is bar chart other one line chart.

my requirement is when i select product and customer list box it reflect the bar chart.

       when i select year,region and country in list box it reflect the line chart .

my chart is always showing initial and when selection is done in list box than only reflect the chart.

how to implement?

Thanks

Chaitanya 

[vishsaggi]

Can you elaborate a little more with an example please?

You want to hide and show the charts based on listbox selections?

In the Bar chart properties layout tab, conditional show

Use like = IF(GetSelectedCount(product) OR Getselectedcount(customer), 1, 0)

In the Line chart properties layout tab, conditional show

Use like = IF(GetSelectedCount(Year) OR Getselectedcount(Region) OR Getselectedcount(Country), 1, 0)

Can you tell me what you want to see if you dont select anything in the list box.

OR you can use set analysis in your chart expressions to disregard the dimensions like

This is for Bar chart.

= Sum({$<Year=, Region=, Country=>} Yourfieldname)

This is for Line chart.

= Sum({$<Product=, Customer=>} Yourfieldname)

IF none of these, please elaborate your output.

[shiveshsingh]

You can put condition in Lyout tab of both the charts.

like using getfieldselection

[gkcchowdary]

Hi Nagaraju,

My requirement is not show and hide chart.

Example:you creating bar chart.if you select 2010 year it is automatically reflect chart and display the 2010 year sales.

Chart always showing.

My requirement is :

You have 10 filters means 10 list boxes.

If you select 5 list boxes reflect bar chart and if you select 10 list boxes reflect the line chart.

This is interview question.

Thanks

Chaitanya

[gkcchowdary]

If it is writing the condition in layout Tab chart is hide. And you select list boxes than it showing.

My requirement:example

Take bar chart Dimension year and expression sum(sales).and no need to hide the chart.

If you select product and country and region.if made the selection above 3 list box than only reflect the chart .If is not made any selection it just showing the chart initially what you are creating.

Thanks

Chaitanya

[shiveshsingh]

You can set default selections by creating OnOpen Sheet trigger.

If you open the sheet default selections will be there and you can change them as per your need.

[vishsaggi]

‌Did you try set analysis expressions I mentioned in my earlier response?

[vijetas42]

Hi,

you can bypass the slection from listboxes in your chart expression like, if you want to exclude country region and year selection from bar chart then in set expression you can write,

sum({<Country,Region,Year>}value) and same for line chart to exclude product and customer,sum({<Product,Customer>}value).

[gkcchowdary]

Hi Nagu,

my requirement is not related to hide and show chart.and not exclude thing.

see you have two charts one is bar and line chart.and 6 list boxes in your dashboard.

if you select any 3 list boxes reflect bar chart and if you select all list boxes reflect the line chart.

[shiveshsingh]

If you have 6 listboxes say, 1,2,3,4,5,6

for bar chart - sum({<4,5,6>}sales) , bypass 3 listboxes value

Like this?