Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
samane_ramezani
Contributor

ignore all selection in specific chart except on field

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.

Untitled.png

Tags (2)
5 Replies

Re: ignore all selection in specific chart except on field

May be this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
isingh30
Valued Contributor

Re: ignore all selection in specific chart except on field

Try this in expression.

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

Thanks.

MVP & Luminary
MVP & Luminary

Re: ignore all selection in specific chart except on field

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

Hi,

another solution might be:

QlikCommunity_Thread_290193_Pic3.JPG

QlikCommunity_Thread_290193_Pic4.JPG

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

hope this helps

regards

Marco

samane_ramezani
Contributor

Re: ignore all selection in specific chart except on field

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