Chart Filters restriction

[balanandam]

Hi, Can any one guide me to solve below ?

I have N Pies charts in Dashboard each for separate intention, I need to control 2 Pie's differently

1. 2 Pie's should be filtered by only Year & Product from my list box selection, any other selection from list boxes or associate selection from any other objects, means, sub selection from remaining Pie charts or other charts or filter if any ? strictly prohibited.

2. Other  Pie'(s) should be filtered by Year, Product, along with sub selection from any other Pie(s) or selection from list boxes or other filters if there any ? (i.e, by default behavior in Qlikview)

Thanks in Advance!

Balanandam

[pradosh_thakur]

Use p()  function in the first 2 chart and exclude all the filter by using {1} in the expression to exclude others..

Regards

Pradosh

[balanandam]

Thanks for the response!  Pradosh.

I wanted to make something like count the sessionsid based upon the list box selections CalendarYear, CalendarMonth ,

CalendarQuarter & Product only. So, I'm try to write something below

=Count({1<SessionHistoryId = p({<SessionStatus={'Success'},CalendarYear={"*"},Product={"*"}>},CalendarMonth={"*"},CalendarQuarter={"*"}}))

and getting error like "Error in set modifier P function parameter list"

Can you pls. help here to achieve this, since I'm very new to Qlikview and this functionality.

Thanks in Advance!

[jonathandienst]

To ignore all but a few selections, have a look here

Ignore all selections except few fields using Set Analysis

[pradosh_thakur]

=Count({1<SessionHistoryId = p({<SessionStatus={'Success'},CalendarYear={"*"},Product={"*"}>},CalendarMonth={"*"},CalendarQuarter={"*"}}))

if i break your expression down to a simple one

1:it should contain something like count({1} field) here you have missed the field name.

i guess you want to count the SessionHistoryId and your condition is it shall only consider product and year selection. so going by this and if i undrstood this correctly your expression for the first 2 pies would be something like this

=count({1<SessionStatus={'Success'}, CalendarYear= p(CalendarYear) , Product=p(Product) >}SessionHistoryId )

[balanandam]

Thanks! Pradosh. this is what I needed.

Thank you Jonathan, I will have a look into your share.

Balanandam

[pradosh_thakur]

Hi bala

if you are satisfied with the answers. Please close the thread by marking the answers correct and helpful.

regards

Pradosh