Button Selections

[bharatkishore]

Hi All,

I have two charts and a button in one sheet. Now my requirement is if i do any selections in one chart the button(Name is "Clear Filters")

should  be able to clear only that particular chart.. It should not reflect the other chart.

Note: I do not want using Alternate States

Thanks,

Bharat

[jagan]

Hi,

Try like this

Without using Alternate States it is very difficult.  The alternate solution is

For example you are using Country field as filter, try like below

Data:

LOAD

Country,

Country AS Country_2,

'

'

'

FROM DataSource;

Now in Sheet1 use Country as filter and in your expression use this

=Sum({<Country_2=>} MeasureName)

Note: you have to use Country_2 in all expressions in Sheet1.

In Sheet2 use Country_2 as filter and use the below expressions

=Sum({<Country=>} MeasureName)

Note: you have to use Country in all expressions in Sheet2.

Hope this helps you.

Regards,

jagan.

[Chanty4u]

chk now

[bharatkishore]

Thanks Chanty for the reply. But as per ur file i am unable to do any selections in the second chart.

My requirement is i should able to filter the charts(Straight Table) but button should clear only for one chart. It should not clear the two charts.

Sorry if i am not able to explain clearly.

[bharatkishore]

Thanks a lot Jagan for the reply.

Hope i am clear with y requirement. If not i will explain again:

I have one straight table chart with some fields and i have a button.

Now if you select on any field on the chart the chart will get filtered. Now i need to get as with the help of a button i need to clear the filters made on the chart. Only with button i need to clear it.

Thanks,

Bharat

[jagan]

Instead of using Clear All, Use Clear Field Country in Sheet1 and Count_2 in sheet.  If you have additional repeat this.

This is the only way that we can implement this, otherwise you have to go for Alternate States.  Not sure why you are not going for that.

Regards,

Jagan.