ignore all selection in specific chart except on field

[Anonymous]

Hi Qlikers

I want to Create a straight table (as like as Below image)  that ignore all selections in fields except Branch

in other hand

when I select Branch ,the straight table "always" shows all personnel's information who works in it and not omit any personnel ID and Personnel Name and level.

[Anil_Babu_Samineni]

May be this?

Sum({$<[$(=Concat({1<$Field={'Branch'}>} distinct $Field,']=,[')&']=')>} Measure)

[isingh30]

Try this in expression.

= only({<Personnelname = {'*'},Personnelid = {'*'},Level = {'*'}>} Branch)

Thanks.

[rwunderlich]

Add an expression like this to the table.

Sum({<Personnelname=, Personnelid=, Level=>}1)

Then hide that expression column on the Presentation tab.

-Rob

[MarcoWedel]

Hi,

another solution might be:

Only({1<Branch=$::Branch>} PersonnelName)

hope this helps

regards

Marco

[Anonymous]

I use this formula  as expression (mix of Marco and Rob solution) in straight Chart

=sum({1<level=,personnel id=,personnel name=,branch::$ branch>}1)

Thanks