topic Set Analysis in QlikView

Set Analysis

hkg_qlik — Thu, 07 Jun 2012 13:32:31 GMT

Resolved Date is not null

Syntax for the above statement in terms of set analysis?

Count({1<Resolved Date is not null >}Distinct [Counter Incident Number])

Regards,

Set Analysis

lironbaram — Thu, 07 Jun 2012 13:34:42 GMT

hi try

Count({1<Resolved Date ={"*"}>}Distinct [Counter Incident Number])

Re: Set Analysis

Miguel_Angel_Baeyens — Thu, 07 Jun 2012 13:40:20 GMT

Hi,

Another option:

Count({< [Resolved Date] = P([Resolved Date]) >} DISTINCT [Counter Incident Number])

Hope that helps.

Miguel

Set Analysis

Thu, 07 Jun 2012 13:59:46 GMT

Hi Miguel,

I'm sorry to bother you, could you please explain to me the P() function.

I don't find any guide about it.

Thanks a lot

Giampiero

Set Analysis

vlad_komarov — Thu, 07 Jun 2012 14:04:26 GMT

Giampiero,

P() is used to show Possible Values. See QV help for details:

sum( {$<Customer = P({1<Product={‘Shoe’}>} Customer)>} Sales )
returns the sales for current selection, but only those customers that ever have bought the product ‘Shoe’. The element function P( ) here returns a list of possible customers; those that are implied by the selection ‘Shoe’ in the field Product.

Regards,

Vladimir

Set Analysis

Thu, 07 Jun 2012 14:10:25 GMT

Thank you so much Vladimir,

I really appreciate.

Regards

Giampiero

Set Analysis

Anonymous — Thu, 07 Jun 2012 14:17:23 GMT

Hi Giampiero,

un can find nice manual here..

http://community.qlik.com/servlet/JiveServlet/previewBody/1867-102-1-1858/QlikLearn-Set-Analysis-Presentation.pdf

Hope this help

Andrea

Set Analysis

Thu, 07 Jun 2012 14:24:27 GMT

Hi Miguel,

Thanks a lot.

It seems to be a very good guide.

Giampiero

Set Analysis

hkg_qlik — Thu, 07 Jun 2012 15:55:00 GMT

Thank you all..