Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
varunreddy
Contributor III

Hide Excluded in Staright Table

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

Tags (2)
1 Solution

Accepted Solutions
Sergey_Shuklin
Valued Contributor

Re: Hide Excluded in Staright Table

Hello, Varun!

The Aggr() function may be useful here:

aggr_hide.png

10 Replies

Re: Hide Excluded in Staright Table

I thought Straight table did that by default

varunreddy
Contributor III

Re: Hide Excluded in Staright Table

I don't want the greyed out values.

I am trying to achieve something like this:

Re: Hide Excluded in Staright Table

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

varunreddy
Contributor III

Re: Hide Excluded in Staright Table

Yes 

Wondering, if this is possible?

Re: Hide Excluded in Staright Table

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

varunreddy
Contributor III

Re: Hide Excluded in Staright Table

Are there any alternatives?

Re: Hide Excluded in Staright Table

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
Valued Contributor

Re: Hide Excluded in Staright Table

Hello, Varun!

The Aggr() function may be useful here:

aggr_hide.png

varunreddy
Contributor III

Re: Hide Excluded in Staright Table

Maybe I will try with button and list box.