topic Re: Re: Non interactive charts in QlikView

Non interactive charts

Wed, 05 Mar 2014 11:01:54 GMT

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.

Re: Non interactive charts

tresB — Wed, 05 Mar 2014 11:04:09 GMT

Chart->general tab->Read Only

Re: Non interactive charts

MK_QSL — Wed, 05 Mar 2014 11:07:59 GMT

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

Re: Non interactive charts

jagan — Wed, 05 Mar 2014 11:13:19 GMT

Hi,

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

Sum({<SelectedDimensionName=>} Value)

Regards,

Jagan.

Re: Non interactive charts

Wed, 05 Mar 2014 11:26:33 GMT

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.

Re: Non interactive charts

MK_QSL — Wed, 05 Mar 2014 11:47:05 GMT

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.

Re: Non interactive charts

Thu, 06 Mar 2014 09:17:51 GMT

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

Re: Non interactive charts

MK_QSL — Thu, 06 Mar 2014 09:23:35 GMT

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

Re: Non interactive charts

Thu, 06 Mar 2014 09:49:11 GMT

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

Re: Non interactive charts

MK_QSL — Thu, 06 Mar 2014 09:51:27 GMT

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

Re: Non interactive charts

Thu, 06 Mar 2014 10:03:32 GMT

I have a simple expression count(field1) to count field values.In dimesion I am using another field which is a date.

Now I am trying to create new expression suggested by you.

I have created count({<Field3 =}[Field1]),to ignore field3 but it showing error.

Can you please suggest what I am doing wrong in this?and also how I can mention Field4,field5 in this to ignore?

Re: Non interactive charts

MK_QSL — Thu, 06 Mar 2014 10:08:01 GMT

Dear Tushar,

Better if you upload you sample file with limited data.

It is the best and effective way to help you at this stage.

Re: Re: Non interactive charts

Thu, 06 Mar 2014 10:36:48 GMT

Here is the sample file.I just want to restrict the change of bar chart in sheet2,by clicking on any object at sheet1.fileters should work only on sheet 1 but there will be no impact on sheet2.

Re: Re: Re: Non interactive charts

MK_QSL — Thu, 06 Mar 2014 10:40:18 GMT

Like this?

Re: Non interactive charts

Thu, 06 Mar 2014 10:47:54 GMT

Thanks Manish,Its perfect.

Could you pleasetell,from where I can read aboout scripts and expressions in qlikview,as I am pretty in qlikview.

Re: Non interactive charts

MK_QSL — Thu, 06 Mar 2014 10:50:43 GMT

The best way of learning QlikView is

1) Go through reference manual

2) Give your valuable time on reading QlikView Blogs and Question-Answers on Community

3) Try to purchase any books suggested in below link.

http://community.qlik.com/message/472897#472897

Hope this helps.