Straight Table selection

[vanderson009]

Hello Community,

In my dashboard i have one straight table,

which includes one dimension as Month and one expression as sales,

On clicking Month other months will get disappear but i want display others also.

Means selected month shows as background green and unselect still visible but with other color.

Please help me guys.

- Thanks and Regards,

Villyee

[its_anandrjs]

This is the qlikview functionality that when you select any values in attribute it display green other wise rest are grey.

What is actual problem let me know.

[lironbaram · Accepted solution]

in your expression should look something like

sum({<Month=>}Sales) this will disregard any selections in the month field

in the background expression you should write

if(isnull(Month),gray(),green())

attach is an example

[its_anandrjs]

Use SET Analysis for the straight chart

Sum({<Month>} sales)

[sundarakumar]

PFA.

Hope this is helpful.

-

sundar