Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this?
Sum({$<[$(=Concat({1<$Field={'Branch'}>} distinct $Field,']=,[')&']=')>} Measure)
Try this in expression.
= only({<Personnelname = {'*'},Personnelid = {'*'},Level = {'*'}>} Branch)
Thanks.
Add an expression like this to the table.
Sum({<Personnelname=, Personnelid=, Level=>}1)
Then hide that expression column on the Presentation tab.
-Rob
Hi,
another solution might be:
Only({1<Branch=$::Branch>} PersonnelName)
hope this helps
regards
Marco
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