Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Non interactive charts

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.

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

15 Replies
tresesco
MVP
MVP

Chart->general tab->Read Only    

MK_QSL
MVP
MVP

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
Partner - Champion III
Partner - Champion III

Hi,

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

Sum({<SelectedDimensionName=>} Value)

Regards,

Jagan.

Not applicable
Author


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
MVP
MVP

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.

Not applicable
Author

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
MVP
MVP

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..

Not applicable
Author

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
MVP
MVP

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