Set Analysis

[#1]

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!

[swuehl · Accepted solution]

Try

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

[#3]

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

[swuehl]

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.

[#5]

Thanks a lot swuehl!

[#6]

An helpful presentation about Set-Analysis

QlikLearn-Set-Analysis-Presentation.pdf

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

[#7]

bother thanks fro the pdf