topic Re: Chart Filters restriction in QlikView

Chart Filters restriction

balanandam — Thu, 12 Oct 2017 18:14:07 GMT

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

Re: Chart Filters restriction

pradosh_thakur — Thu, 12 Oct 2017 18:32:27 GMT

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

Regards

Pradosh

Re: Chart Filters restriction

balanandam — Fri, 13 Oct 2017 06:26:32 GMT

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!

Re: Chart Filters restriction

jonathandienst — Fri, 13 Oct 2017 07:01:35 GMT

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

Ignore all selections except few fields using Set Analysis

Re: Chart Filters restriction

pradosh_thakur — Fri, 13 Oct 2017 07:33:17 GMT

=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 )

Re: Chart Filters restriction

balanandam — Fri, 13 Oct 2017 07:49:07 GMT

Thanks! Pradosh. this is what I needed.

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

Balanandam

Re: Chart Filters restriction

pradosh_thakur — Fri, 13 Oct 2017 09:51:24 GMT

Hi bala

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

regards

Pradosh