Table with current field values of a NOT selected field

[Anonymous]

Hello,

I have a set of customers with the variables: ID, Store, Age and AmountSpent. There is only one entry per ID, but several IDs can have the same [Store] value.

When I select a single ID, I want a table (table box/ straignt table...) displaying the value of all my variables for each customer that has the same [Store] value of the that customer [ID]:

     Say customer with [ID]='1001' has [Store]='A': I select the [ID] (but not a [Store]) and I want a table with 4 columns (ID, Store, Age and AmountSpent) for each customer that fulfills [Store]=='A'

I've tried using something like:

     if( [Store]=Concat(Distinct [Store], ','),   ( {< [ID = >} Age)    )

but it won't work.

I'm new to Qlik so I'd appreciate any hints that help me get closer to the solution!

Many thanks.

[sunny_talwar · Accepted solution]

May be try this

Dimension

ID

Store

Age

Expression

Sum({<ID, Store = p(Store)>} AmountSpent)

[Anonymous]

It works exactly the way I wanted. Thank you very much!