Hide Excluded in Staright Table

[varunreddy]

Hi All,

I have created the straight table to show the dimension values using the drop down select. Now I am trying to "Hide Excluded" values. Is there a way we can do that in the straight table.

I am trying replicate the functionality of "Hide Excluded" in list box into straight table.

Can anyone please help me with this?

Thanks,

Varun

[sunny_talwar]

I thought Straight table did that by default

[varunreddy]

I don't want the greyed out values.

I am trying to achieve something like this:

[sunny_talwar]

Both your screenshots are not a straight table ... you are asking to hide excluded in straight table, aren't you?

[varunreddy]

Yes 

Wondering, if this is possible?

[sunny_talwar]

So, once again I think, by default... straight table doesn't show excluded values

[varunreddy]

Are there any alternatives?

[sunny_talwar]

Yes there is... close down your computer and go back home and take rest....

Just kidding... Alternative for what? Something which is QlikView is doing by default.... you want to do it using alternative? Who will be brave enough to do this ... I guess I am not

[Sergey_Shuklin · Accepted solution]

Hello, Varun!

The Aggr() function may be useful here:

[varunreddy]

Maybe I will try with button and list box.