Non interactive charts

[#1]

HI all,

In my reports there are two sheets used.In one sheet,it has some filters and table box to show data.Another sheet contains some pie chart on same data model.

But by selecting some filters on sheet one,charts on sheet second changes accordingly.

How I can restrict it.

[tresesco]

Chart->general tab->Read Only    

[MK_QSL]

If you want temporary restriction, you can Detach the chart by right clicking it.

But once you reload the application, the Detach will be remove automatically.

For Permanent solution, you need to do Read Only as per tresesco said...

[jagan]

Hi,

Try using different Alternate states in both the sheets or exclude the selection in the expression like

Sum({<SelectedDimensionName=>} Value)

Regards,

Jagan.

[#5]

By make it Read Only,we can make charts read only.But I want to restrict filter selection on charts.

Jagan Mohan,could you plz explain it more.

[MK_QSL]

Please check enclosed file

Here if you Select Year, you will get Sales for Selected and Previous years for all customer.

But If you select Customer, the chart will not take this selection into consideration.

Hope this helps.

[#7]

could you please tell me how you done it? i have check your qvw file, it is not and implementing this but i am not sure how you done it?

Have you done it through expressions?

In my qvw,i just find out the counts on a field?

could you please explain it

[MK_QSL]

SUM({<Customer = ,Year = {'$(=Max(Year))'}>}Sales)

This will give you Sales for Maximum Selected Year but Customer = will take care that even though you will select any customer, it will not affect your end result.

The same is for Previous year..

[#9]

In this you particularly restrict one field(customer),but what if we have a 15 field coulmn and use some list boxes and table box.

In this case,do we have to mention all the fields name in expression.?

[MK_QSL]

If you want your expression  (Set Analysis) to ignore the fields, you need to type them all.