topic ignore all selection in specific chart except on field in QlikView

ignore all selection in specific chart except on field

Anonymous — Sun, 04 Feb 2018 11:57:57 GMT

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.

Re: ignore all selection in specific chart except on field

Anil_Babu_Samineni — Sun, 04 Feb 2018 12:07:22 GMT

May be this?

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

Re: ignore all selection in specific chart except on field

isingh30 — Sun, 04 Feb 2018 17:09:46 GMT

Try this in expression.

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

Thanks.

Re: ignore all selection in specific chart except on field

rwunderlich — Sun, 04 Feb 2018 17:50:02 GMT

Add an expression like this to the table.

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

Then hide that expression column on the Presentation tab.

-Rob

Re: ignore all selection in specific chart except on field

MarcoWedel — Sun, 04 Feb 2018 22:07:33 GMT

Hi,

another solution might be:

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

hope this helps

regards

Marco

Re: ignore all selection in specific chart except on field

Anonymous — Tue, 06 Feb 2018 14:59:18 GMT

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