topic Re: Straight Table selection in QlikView

Straight Table selection

vanderson009 — Thu, 24 Apr 2014 05:37:23 GMT

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 — Thu, 24 Apr 2014 05:43:44 GMT

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 — Thu, 24 Apr 2014 05:52:54 GMT

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 — Thu, 24 Apr 2014 05:58:23 GMT

Use SET Analysis for the straight chart

Sum({<Month>} sales)

sundarakumar — Thu, 24 Apr 2014 06:12:45 GMT

PFA.

Hope this is helpful.

sundar