topic selection in QlikView

selection

denis115 — Thu, 17 Aug 2017 06:31:29 GMT

HI! I have 3 objects: client ,unloadplace and product, when I select a field from client and after I select a field from unloadplace, I need to see all products of this client in another tabrow but not only field of selected unloadplace, is it possible? I've used : sum({$1}product) and it worked but I need something more universal because there are different situations when first I select field from unloadplace and after this I select client and I need to change expression from sum({$1}product) into sum({$2}product).

Thanks in advance!

Re: selection

felipedl — Thu, 17 Aug 2017 17:12:00 GMT

Hi Cucuta,

If I understood your problem, you need to show all products a specific client has, ignoring the unloadplace selection correct?

If so, you can treat it inside the set analysis, ignoring the selection of unloadplace, something like this

sum({<unloadplace>}product) // This will ignore the unloadplace selections.

Felipe.

Re: selection

denis115 — Fri, 18 Aug 2017 07:22:46 GMT

Thanks!

Re: selection

oknotsen — Fri, 18 Aug 2017 08:44:50 GMT

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .