topic SET ANALYSIS : Nested expressions in QlikView

SET ANALYSIS : Nested expressions

Thu, 14 Apr 2011 10:47:57 GMT

Hello community.

Can someone explain me how it works?

An example will be good.

Thanks

rbecher — Thu, 14 Apr 2011 11:11:36 GMT

Hi,

this is an example:

sum({$<Customer={"=sum({l<Product={'A'}>} Sales)>0"}>} Sales)

It represents the sum of all Sales for the set of Customers who purchased Product 'A'.

- Ralf

rahulgupta — Thu, 14 Apr 2011 11:12:39 GMT

Hey Hi Yimen,

You can use it like this...


=Sum( {<Date={'$(=max(Date))'}>}Sales)

Hope this works as per your requirement...!!

nathanfurby — Thu, 14 Apr 2011 12:11:20 GMT

Ralf - Is that a typo in your expression or does the 'S' perform some other function?

rbecher — Thu, 14 Apr 2011 12:16:28 GMT

You're right! It's a typo, should be $... I'll change it.

- Ralf

nathanfurby — Thu, 14 Apr 2011 12:19:26 GMT

OK thanks - I'm still relatively new and quite recently discovered the P and E functions. Wanted to make sure I wasn't missing out

Thu, 14 Apr 2011 12:34:04 GMT

Can you enlighten me... what are P and E functions? 🙂

rbecher — Thu, 14 Apr 2011 12:37:34 GMT

There is a good explanation in the online help...