Hide fields within a straight table

[Anonymous]

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

[Anonymous]

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

[#3 · Accepted solution]

Hi,

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

Regards,

Marina C.

[Anonymous]

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

[#5]

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.

[Anonymous]

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

[Anonymous]

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!

[#8]

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.

[Anonymous]

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...