topic Set Analysis in QlikView

Set Analysis

Mon, 23 Jan 2012 20:26:56 GMT

Hi All

Quick question in set analysis.

I have three columns in table.

ID, PlanDate,ActualDate

Requirement is to

Count ID's which has a PlanDate

Count ID's which has a ActualDate

I wrote something like this

Count({< PlanDate = {'*'} >} DISTINCT ID) which should give count of ID's which are planned.

I have a graph which has PlanDate as X axis

Plan =Count({< PlanDate = {'*'} >} DISTINCT ID)

Actual = Count({< ActualDate = {'*'} >} DISTINCT ID)

are the two bars in the graph

since i am using {'*'} in set analysis I am not able to perform lasso funtionality, meaning if I need only one month data in the graph, i can click the bar corresponding to that month, which should return only that month's data, but that is not happening in my case.

Help me with the set analysis which should work well with lasso functionality

Thanks in advance!

Set Analysis

swuehl — Mon, 23 Jan 2012 20:54:33 GMT

Try

=Count({< PlanDate = p() >} DISTINCT ID)

Set Analysis

Mon, 23 Jan 2012 20:58:06 GMT

Great. That works fine. But what does P() mean?

Set Analysis

swuehl — Mon, 23 Jan 2012 21:06:57 GMT

p() function (and her brother, the e() function) are implicte field value definitions, please have a look at the Help - set analysis, too.

p() is representing the element set of possible values of a field, while e() the excluded. The possible values are defined by your selection state.

Set Analysis

Mon, 23 Jan 2012 21:08:21 GMT

Thanks a lot swuehl!

Set Analysis

Tue, 24 Jan 2012 04:52:42 GMT

An helpful presentation about Set-Analysis

QlikLearn-Set-Analysis-Presentation.pdf

http://community.qlik.com/docs/DOC-1867

Set Analysis

Sun, 05 Feb 2012 09:55:09 GMT

bother thanks fro the pdf