hi explain one more req?

[gkcchowdary]

i have one table like below

table1:

year,month,sales,area

2014,1,100,hyderabad

2014,2,200,bangalore

'

'

'

'

upto

2014,12,1200,mumbai

so my requirement is first create bar chart and starting no chart appear once i selected any one month it will display

first month sales and i selected 4 th month it will disply 4 th month sales

i selected any two months that two months sales display and more than two months selected chart hide

so any one month or two months selected chart appear if not selected chart hide,how?

[veeranj]

Hi Chaitanya,

In the layout tab, under show Section, give the Condition as GetSelectedCount(Month)<=2

When you select more that one month,the chart will get hidden .

Thanks,

Anjee

[kkkumar82]

Hi ,

Please find the attached qvw file , hope it may help you.

Thanks

Kiran Kumar

[karthikeyan1504]

Hi,

Go to chart properties -> layout.

In show conditional, enter the expression of getselectedcount(month)=1 or getselectedcount(month)=2

Warm Regards,

Karthikeyan.

[kkkumar82]

Sorry ,

I have used calculation condition and error messages in general tab.

Thanks

KK

[avinashelite]

hi

please find the attached e.g . You can achieve it two ways ..

1. Go to>Chart Properties >Layout > show>Conditional >

if(GetSelectedCount(Dimension)>0 and GetSelectedCount(Dimension)<=2,1,0)

2. Chart Properties >General >Calculation Condition >

if(GetSelectedCount(Dimension)>0 and GetSelectedCount(Dimension)<=2,1,0)

In the example select the dimension you will get the idea

[#7]

Hi. May be like this.