Pivot Table - Show Data for a Particular Value - Qlik Community

microwin88x · ‎2014-03-27

Hello!

I have a Pivot Table with the following Fields:

And on the other side I have this expression:

=ONLY({<USER_APP={$(vUser)}>} OFFICE)

Where that expression returns me the corresponding Office that is associated to a User

Now my question is the following:

Each Client is associated to a particular Office where he works.

I want to put a filter in the Pivot Table in order to show me only the Clients that belong to the Office obtained in the expression =ONLY...

How can I do this?

Thank you!!!

Josh_Good · ‎2014-03-27

Try

sum( {$<Clients= P({1<Office={$(=chr(39) & ONLY({<USER_APP={$(vUser)}>} OFFICE) & Chr(39)}>} Clients)>} Attentions)

I assumed your base expression was

Sum(Attentions).