topic Re: Hide fields within a straight table in QlikView

Hide fields within a straight table

Anonymous — Thu, 31 Jul 2014 18:22:53 GMT

Hi, I wanted to hide certain fields in my straight table, I tried putting getselectedcount in the conditional but it doesn't work.

Can someone help please?

For example I just wanted to show the orange filled column:

Thanks

Re: Hide fields within a straight table

Anonymous — Thu, 31 Jul 2014 18:35:15 GMT

Oh, I forgot to mention that the getselectedcount did work but it zeroed out everything, because the Estimate is a calculation based on all the other 3 columns. Once I use getselectedcount()=0, my estimate gets zeroed out as well.

Thanks

Re: Hide fields within a straight table

Thu, 31 Jul 2014 18:36:13 GMT

Hi,

In Presentation Tab you have the option of Show or Hide Column!

Regards,

Marina C.

Re: Hide fields within a straight table

Anonymous — Thu, 31 Jul 2014 18:40:54 GMT

I don't have that option.. I am using the Personal edition, though it's still Qlikview 11. Is that why I don't have that option??

Thanks

Re: Hide fields within a straight table

Thu, 31 Jul 2014 18:44:59 GMT

No, that happens because you are using Pivot Table and not Straight Table!

There is no option to hide columns in Pivot Tables.

You can either write an expression joining all other expressions in one calculation or mask the column so that the user can't see it (tipically, white text color and shorten the column width as far as you can).

Marina C.

Re: Hide fields within a straight table

Anonymous — Thu, 31 Jul 2014 18:47:31 GMT

Wahahaha!!! You are sooo right! God I kept thinking I was using straight table!!!!! Thanks!

Re: Hide fields within a straight table

Anonymous — Thu, 31 Jul 2014 19:03:34 GMT

Hi Marina, would you know how to exclude value within the BU for example I want to exclude 'C' from this table. How'd I do it?

THanks!

Re: Hide fields within a straight table

Thu, 31 Jul 2014 19:10:43 GMT

Hi Chang,

Yes, you should use Set Analysis in your expressions like this:

sum({< BU -= {'C'} >} TotalRevenue )

Or you can do it adding a Calculated Dimension (in dimensions tab) instead of BU:

If(BU <> 'C', BU)

and make sure you check 'Suppress When Value Is Null' checkbox!

I think the latter option would be the best for you, as you are using more than 1 expression!

This would work both on Pivot or Straight Table

Regards,

Marina C.

Re: Hide fields within a straight table

Anonymous — Thu, 31 Jul 2014 19:23:24 GMT

mm it works, but I have 2 different dimensions within that cyclic group. When I add the calculated dimension, it messes up the other dimension within that cyclic group...