topic Re: How to hide columns using conditions in QlikView

How to hide columns using conditions

Wed, 24 Jun 2015 21:22:17 GMT

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

Re: How to hide columns using conditions

Anonymous — Wed, 24 Jun 2015 21:27:44 GMT

The qvw you provided is password protected.

Re: How to hide columns using conditions

Wed, 24 Jun 2015 21:34:57 GMT

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>

Re: How to hide columns using conditions

Thu, 25 Jun 2015 18:15:01 GMT

I'm posting now a QVW without section access.

Could you help me with this??

Thanks a lot

Christian.-

Re: How to hide columns using conditions

Thu, 25 Jun 2015 18:35:01 GMT

hey, didn't get you exactly...

just check if this is what you are expecting. !

Re: How to hide columns using conditions

ramoncova06 — Thu, 25 Jun 2015 18:40:55 GMT

what conditions are needed for it to be hidden ?

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

Re: How to hide columns using conditions

Thu, 25 Jun 2015 19:16:34 GMT

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.

Re: How to hide columns using conditions

Thu, 25 Jun 2015 19:18:32 GMT

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

Could you have any suggestions?

Re: How to hide columns using conditions

ramoncova06 — Thu, 25 Jun 2015 19:27:21 GMT

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