show alternative require in straight table

[yadav_anil782]

Hi Qlik Experts,

i'm not able find show alternative option in straight table which we use in list box . i have attched screen shot of my table and i want if i select one project name then rest  projects name should be show in diffrent color like list box . plz suggest  what to do in straight table because in straigh table all othervalue going to hide when i m selection one perticuler  row  .

[yadav_anil782]

plz revert if anyone can resolve this issue

[Colin-Albert]

Try a list box showing the Project and on the Expressions tab add an expression for Area, this will give you the two columns you want.

[Gysbert_Wassenaar]

See attached example.

[jonathandienst]

I suggest that you post an example document to make the advice more accurate. But in general this is what you need to do:

• Add a set expression to you chart expression to override all selections
• For example:   Sum({1} Sales)
• Click the + next to the expression in Properties | Expressions
• Select Foreground Colour
• Enter a colour expression that will change the colour of the selected expression:
• For example:    =If(Count(Project) > 0, LightRed())  Or
• Or    =If(Index(GetFieldSelections(Project), Project) > 0, LightRed())

Or use an added column in a list box (but you will not get a header for the column for this).