Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Like this?
Chart->general tab->Read Only
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...
Hi,
Try using different Alternate states in both the sheets or exclude the selection in the expression like
Sum({<SelectedDimensionName=>} Value)
Regards,
Jagan.
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.
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.
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
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..
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.?
If you want your expression (Set Analysis) to ignore the fields, you need to type them all.