Showing weeks on x axis

[Anonymous]

Hi

I am having a dimension which shows weeks on X axis , when no values are selected from a certain column , the max week should not be shown , when value is selected then then all weeks have to be shown ...

i have been trying something like below ..as my calculated dimension

if(getselectedcount(Col1) = 0 , date(startweek - 1,'MM/DD/YYYY') , date(startweek,'MM/DD/YYYY'))

but it does not work .

Thanks

[whiteline]

Hi.

It seems like it could be solved with set analysis.

Could you post an example or at least describe your chart more ?

[matthieu_burel]

Perhaps could you try something like ...

= IF(getselectedcount(Col1) = 0,

          IF(startweek <= Max(All startweek) - 1,

               startweek

          ,

               Null()

          )

     ,

          startweek

)