topic Re: Pivot Chart Help - Conditions in QlikView

Pivot Chart Help - Conditions

Anonymous — Thu, 09 Apr 2015 15:31:32 GMT

Hello,

Looking for help on the Pivot Table dimension shown below

I am using the following calculated dimension:

=IF(YEAR < $(vBusinessYear) , YEAR & ' YE', YEAR & ' YTD' )

I would like to get rid of 2005-2007 on the graph as I only need >= 2008. I am also looking to have this table static to always show each year, so I have YEAR =, in the set analysis. Is there a way to change the calculated dimension or use the conditional setting? I have tried several options with no luck.

Thank you,

Justin

Re: Pivot Chart Help - Conditions

sunny_talwar — Thu, 09 Apr 2015 15:34:04 GMT

Did you try this by any chance?

=If(YEAR >= 2008, IF(YEAR < $(vBusinessYear) , YEAR & ' YE', YEAR & ' YTD'))

Update: and ensure that you have suppressed the null value for the calculated dimension.

Best,

Sunny

Re: Pivot Chart Help - Conditions

Anonymous — Thu, 09 Apr 2015 15:36:08 GMT

I thought I had, but apparently I did not.

Thanks for the help,

Justin

Re: Pivot Chart Help - Conditions

sunny_talwar — Thu, 09 Apr 2015 15:37:06 GMT

So did it work now?

Best,

Sunny

Re: Pivot Chart Help - Conditions

Anonymous — Thu, 09 Apr 2015 15:38:15 GMT

Sure does Sunny, thank you again.

Re: Pivot Chart Help - Conditions

sunny_talwar — Thu, 09 Apr 2015 15:39:00 GMT

Awesome!, glad to help.

Best,

Sunny