Bar chart should not effect with selection

[polisetti]

Hi,

In my reports i had one bar chart and one straight table. When ever i click on bar chart the bottom straight table should filter according to the selection made in bar chart. Now the requirement is the data in straight table should filter but the bar chart should on filter on selection.

Ex:

I have a dimension month :jan, feb, mar , apr .If i select on mar the straight table should show data related to mar, but the bar chart should show all the 4 months.

I tried Set reference option in properties, but it is breaking at some times.

Is there any other process to show like this ?

Thanks,

Polisetti

[ashfaq_haseeb]

Hi,

Create a separate state for bar chart.

Look at alternate states.

Look at the attached document

Regards

ASHFAQ

[#3]

GO to Properties of barchart and Select Detach May it helps to you.

[lironbaram]

you can use set analysis in the bar chart expression

if you want the bar chart to disregard all selection

just change the expression to sum({1} yourfieldname)

[sudeepkm]

in your bar chart you can modify the expression like below.

sum({<Month=>} Sales). any selection of Month in straight table or any where in the dashboard will not change the bar chart values.

[polisetti]

Hi,

Thanks for you immediate reply.

Please check the screenshot, so i want to show in same visualization.

When the bar is selected the particular data should show in straight table and the particular bar should come in different color.

Thanks

Polisetti

[sujeetsingh]

use set analysis

[sujeetsingh]

Poli,

Just use expression to change bar colour when the dimension get selection

[polisetti]

Can you please give me any example or sample qvw.

Thanks

[sujeetsingh]

See this sample