Hide an expression in the chart when a dimension of the Cyclic group is selected

[#1]

Hi All,

I have a Cyclic group showing the dimensions Year, Quarter and Week.I would like to hide an expression when a Week is selected.

Any ideas would be of great help!!

[neelamsaroha157]

Can you share some sample data...that way it would be easier to debug or find a sol'n

[#3]

Thanks for response Arvind

No luck!

[NickHoff]

I just tried this in my application using a drilldown, which is similar to the cycle and it worked.  Did you attempt to try it?  It doesn't matter if it's a cycle or drilldown because you are still selecting the dimension.

GetSelectedCount(WeekDimension) <> 0

[#5]

Hi Nick Hoff

I tried your expression as below:

=GetSelectedCount([Cyc_Dimension_4]) <> 0

I could see that for YEAR dimension of the Cyclic group the expression is hidden, but not for the Week dimension.

Is there any way that we can specify the exact dimension of the Cyclic group that we want to hide?

[NickHoff]

You aren't listening, don't use the cyc-dimension, just put week dimension in there.  It doesn't matter if it's part of a drilldown/cycle.  Look at my first reply to you, if you tried it you would of seen it works.

[MK9885]

Can you share the app?

or Data with expressions you using?

Cus I've used the same expression in my Pivot Table with Cyclic group and it works fine.

[neelamsaroha157]

Check this out Supriya...2nd expression is hidden when when your cyclic dimension is Quarter

[#9]

It worked like a charm!!

I am using the calculated dimension: Week (It is concatenation of the Qtr and Week and named as QTR_WEEK) It wasn't working as its a calculated dimension.

No that i have performed the calculations in the script and using the dimension in the expression as you suggested it worked!!

Thanks alot Nick Hoff

[MK9885]

PFA