topic Re: Re: Hiding options in a table in QlikView

Hiding options in a table

Tue, 03 Dec 2013 10:23:51 GMT

Hi,

I have a chart which shows results based on different statuses in a table. There is a total of four statuses: Good, bad, extra, and free. I would now like to hide the "Extra" and "Bad" results from the table so that a user cannot select them. My idea of how to do this would be to input either a condition on the table itself were it only shows "Good" and "Free", or input a trigger on the sheet that does the same, but I dont really know how to do this. Any ideas?

Cheers,

Re: Hiding options in a table

Nicole-Smith — Tue, 03 Dec 2013 18:16:08 GMT

If you want to hide the "Extra" and "Bad" results from the table, add the following set analysis to whatever your expression is:

{<Status={'Good','Free'}>}

So your final expression will look something like:

sum({<Status={'Good','Free'}>} Value)

Re: Hiding options in a table

Wed, 04 Dec 2013 09:14:15 GMT

Sorry, I dont want to hide the results (per say) I want to hide the option of having them there to begin with. The idea is that the user is to click in the table and that way filter out what he sees on screen, but I want to limit these options. I cannot just select not to select the data, however, since that would skew up the rest of the results.

Re: Hiding options in a table

Wed, 04 Dec 2013 09:47:33 GMT

Try something like this in the Add calculated Dimension

if(Status <>'Extra' or Status <>'Bad, Status) and the check 'Suppress when values are null

Re: Hiding options in a table

Wed, 04 Dec 2013 09:53:27 GMT

sorry, but this is a list box, i dont have the "suppress when null" option...

Re: Hiding options in a table

MK_QSL — Wed, 04 Dec 2013 10:03:23 GMT

In the list box expression.... type below..

=if(Status <> 'bad' and Status <> 'extra' , Status)

Re: Re: Hiding options in a table

Wed, 04 Dec 2013 10:09:38 GMT

Hi,

PFA. Hope it helps!

Re: Hiding options in a table

Wed, 04 Dec 2013 11:26:05 GMT

worked perfectly! thanks!