How to hide columns using conditions

[#1]

Hello QV masters,

I'm asking you for helping us with the following issue: I have a pivot table than I'm showing these columns:

- BUDGET

- PVIEW

- REAL

- PROYECCION

These expression are SUM() of FIGM.FACT_EST_VALOR field when FIGM.FACT_EST_TABLA_ORIGEN equals BUDGET, PVIEW, REAL or PROYECCION and i'm using a special Num() format when users has selected 'USD' or 'CLP' currency. I'm including also ITEM, SUBITEM and MONTH such as dimensions.

The PROYECCION column needs a special treatment ,because this column is showing values for a specific month (in this case, Jun-2015). I'm trying to hide using Conditional showing in expressions with no luck.

Could you help me with this??

Any suggestions will be appreciated.

Thanks!!

Christian.-

[Anonymous]

The qvw you provided is password protected.

[#3]

Sorry Michael, I'm sending password:

User: ADMIN

Pass:ADMIN1

Thanks!

Christian.-

On Wed, Jun 24, 2015 at 6:28 PM, Michael Gardner <qcwebmaster@qlikview.com>

[#4]

I'm posting now a QVW without section access.

Could you help me with this??

Thanks a lot

Christian.-

[#5]

hey, didn't get you exactly...

just check if this is what you are expecting. !

[ramoncova06]

what conditions are needed for it to be hidden ?

also once it's displayed  the column will be included for the other months

[#7]

Hi Ramon,

I'm need the following: i'm want to show PROYECCION column when it have values, independent of user's selections.

I'm posting a image with explanations.

[#8]

Thanks Navdeep, but your solution doesn't works...

Could you have any suggestions?

[ramoncova06]

I don't think that is going to work, either the metric is displayed or not, I don't believe you can hide it that way, though I don't remember ever getting a request like that, let me run my own tests