topic Re: Hide rows in a straight table in QlikView

Hide rows in a straight table

kdmarkee — Mon, 15 May 2017 19:28:57 GMT

I have attached a qvw that shows the raw data and then a second chart that shows 3 rows I want to show and then be able to hide the others. I have a requirement that calls for 2 separate criteria to dictate what rows should be shown and I'm not able to get a calculated dimension to work for hiding the necessary rows. Thanks for you help.

Re: Hide rows in a straight table

vishsaggi — Mon, 15 May 2017 19:39:47 GMT

May be supress 0 values in your Presentation tab of the Straight table chart properties.

Re: Hide rows in a straight table

kdmarkee — Mon, 15 May 2017 19:47:11 GMT

That won't work because I need to show the zero rows for one half of the requirement. In this example, the rows for Account 793 need to be displayed.

Re: Hide rows in a straight table

sinanozdemir — Mon, 15 May 2017 21:08:13 GMT

Hi Kris,

How about this?

I added "0.00005" to Sum(Amount) when the conditions was met. Then in the format tab, I chose to show only two decimals

As a result of this, when you choose "suppress zero values", the rows that are met with the conditions would still show.

Let me know if this works

Thanks

Re: Hide rows in a straight table

kdmarkee — Mon, 15 May 2017 21:17:05 GMT

That is very clever, I never would have thought of that. I will try it out and let you know. Thanks.

Re: Hide rows in a straight table

vishsaggi — Mon, 15 May 2017 21:27:06 GMT

Thats a good idea. Sorry for late reply Kris. Was stuck with something. But probably you should be good with Sinan's idea.

Re: Hide rows in a straight table

kdmarkee — Mon, 15 May 2017 21:40:52 GMT

That seems to work, thanks again.

Re: Hide rows in a straight table

sinanozdemir — Tue, 16 May 2017 12:32:57 GMT

You'r welcome.

I am glad it worked.

Thanks