Element Functions P() and E()

Thu, 22 May 2014 21:12:29 GMT

I understand that P() uses all possible values and E() uses all excluded values. however, what is not clear to me is whether functions refer to the user selected values or to the entire document. Which is it?

Re: Element Functions P() and E()

fkeuroglian — Thu, 22 May 2014 22:05:02 GMT

Hi, depends

if you select something , the function is on the selected register but if you do not select, the function will be in the whole registers.

Example:

sum( {$<Customer = P({1<Product={‘Shoe’}>} Customer)>} Sales )

if you check some filters the total of recors will decrease and the function will be for the selection only

if you do not select any filters, the function will be in the total of records

see this

Good luck

Fernando

P() & E() and where do you use them?

topic Re: Element Functions P() and E() in QlikView

Element Functions P() and E()

Re: Element Functions P() and E()