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.

[#2]

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?

[MK_QSL]

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.

[#4]

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.

[MK_QSL · Accepted solution]

Like this?

[#6]

Thanks Manish,Its perfect.

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

[MK_QSL]

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.