Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SET ANALYSIS : Nested expressions

Hello community.

Can someone explain me how it works?

An example will be good.

Thanks

7 Replies
rbecher
MVP
MVP

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

Astrato.io Head of R&D
rahulgupta
Partner - Creator III
Partner - Creator III

Hey Hi Yimen,

You can use it like this...


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


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

nathanfurby
Specialist
Specialist

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

rbecher
MVP
MVP

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

- Ralf

Astrato.io Head of R&D
nathanfurby
Specialist
Specialist

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 Smile

Not applicable
Author

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

rbecher
MVP
MVP

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

Astrato.io Head of R&D