topic Re: show alternative require in straight table in QlikView

show alternative require in straight table

yadav_anil782 — Mon, 03 Aug 2015 08:52:15 GMT

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 .

Re: show alternative require in straight table

yadav_anil782 — Mon, 03 Aug 2015 09:31:08 GMT

plz revert if anyone can resolve this issue

Re: show alternative require in straight table

Colin-Albert — Mon, 03 Aug 2015 09:37:35 GMT

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.

Re: show alternative require in straight table

Gysbert_Wassenaar — Mon, 03 Aug 2015 09:38:11 GMT

See attached example.

Re: show alternative require in straight table

jonathandienst — Mon, 03 Aug 2015 09:44:53 GMT

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).