Set Analysis

[hkg_qlik]

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,

H

[lironbaram · Accepted solution]

hi try

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

[Miguel_Angel_Baeyens]

Hi,

Another option:

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

Hope that helps.

Miguel

[#4]

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

[vlad_komarov]

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

[#6]

Thank you so much Vladimir,

I really appreciate.

Regards

Giampiero

[Anonymous]

Hi Giampiero,

un can find nice manual here..

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

Hope this help

Andrea

[#8]

Hi Miguel,

Thanks a lot.

It seems to be a very good guide.

Giampiero

[hkg_qlik]

Thank you all..

H