topic Re: Problem with E() in QlikView

Problem with E()

kamal_sanguri — Mon, 11 Jul 2016 08:55:20 GMT

Hi,

I was working with P & E () (In process of learning them).. I think, I got some understanding of both of the functions.. but still I stuck in a situation where E() is not returning the expected value..

Attaching a qvw.. Pls help me to understand what the problem is..

Thanks,

-Kamal

Re: Problem with E()

sushil353 — Mon, 11 Jul 2016 09:00:09 GMT

Hi,

your Cust field Is not linked with the customer table, that is why your expression is not working,

='Customer not listed as Cust (Only C) using E but not getting correct value - ' & sum({<Customer=e({<Customer={'A','B'}>}Customer)>}Value)

HTH

Re: Problem with E()

kamal_sanguri — Mon, 11 Jul 2016 09:07:12 GMT

Thanks Sushil for looking into it. Yes, I know.. it will work this way but I don't understand why it is not working with '*'. Currently, I have only 'C' not listed in Cust list. However, this list may get change or we may have 'A' or/and 'B' leaving that list. or, if more items in future are added then it would not be a good idea to modify the expression all the time.

Thanks,

-Kamal

Re: Problem with E()

kamal_sanguri — Mon, 11 Jul 2016 09:15:20 GMT

If you look at the middle text box, '-=p' is giving the desired result ( equivalent to E ) but still I am confused why E() is not behaving correctly.

Thanks,

-Kamal

Re: Problem with E()

kamal_sanguri — Mon, 11 Jul 2016 09:16:39 GMT

connection between Customer and is not required.. look at the first 2 text boxes.. they are giving the correct result.

Even, if you use sum({<Customer=e({<Cust={'A,B'}>}Cust)>}Value).. it will work absolutely fine.. even though there is no connection between Customer and Cust.

Thanks,

-Kamal

Re: Problem with E()

Anil_Babu_Samineni — Mon, 11 Jul 2016 10:39:24 GMT

Kamal,

You are saying - Got some idea. But, In qvw i didn't see any implementation tables using Possible - P() and Exclude = E().

Re: Problem with E()

kamal_sanguri — Mon, 11 Jul 2016 10:43:11 GMT

check the expression behind Text objects..

Thanks,

-Kamal

Re: Problem with E()

kamal_sanguri — Mon, 11 Jul 2016 10:45:10 GMT

the problem is expression in third text box is not giving correct result.

Re: Problem with E()

Anil_Babu_Samineni — Mon, 11 Jul 2016 10:56:16 GMT

Usually, P() Vs E()

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

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

returns the sales for current selection, but only those customers that never bought the product ‘Shoe’. The element function E( ) here returns the list of excluded customers; those that are excluded by the selection ‘Shoe’ in the field Product.

Re: Problem with E()

kamal_sanguri — Mon, 11 Jul 2016 14:15:32 GMT

Hi stalwar1, if you could have a look on it per your convenience.

Many Thanks,

-Kamal