topic Hide Excluded in Staright Table in QlikView

Hide Excluded in Staright Table

varunreddy — Thu, 25 Jan 2018 15:51:51 GMT

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

Re: Hide Excluded in Staright Table

sunny_talwar — Thu, 25 Jan 2018 16:02:09 GMT

I thought Straight table did that by default

Re: Hide Excluded in Staright Table

varunreddy — Thu, 25 Jan 2018 16:06:47 GMT

I don't want the greyed out values.

I am trying to achieve something like this:

Re: Hide Excluded in Staright Table

sunny_talwar — Thu, 25 Jan 2018 16:09:17 GMT

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

Re: Hide Excluded in Staright Table

varunreddy — Thu, 25 Jan 2018 16:10:14 GMT

Yes

Wondering, if this is possible?

Re: Hide Excluded in Staright Table

sunny_talwar — Thu, 25 Jan 2018 16:12:14 GMT

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

Re: Hide Excluded in Staright Table

varunreddy — Thu, 25 Jan 2018 16:15:17 GMT

Are there any alternatives?

Re: Hide Excluded in Staright Table

sunny_talwar — Thu, 25 Jan 2018 16:18:16 GMT

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

Re: Hide Excluded in Staright Table

Sergey_Shuklin — Thu, 25 Jan 2018 16:19:31 GMT

Hello, Varun!

The Aggr() function may be useful here:

Re: Hide Excluded in Staright Table

varunreddy — Thu, 25 Jan 2018 16:21:18 GMT

Maybe I will try with button and list box.

Re: Hide Excluded in Staright Table

varunreddy — Thu, 25 Jan 2018 16:23:28 GMT

Hi Shuklin,

This is exactly what I am looking for. Thanks for your help

Cheers,

Varun.