topic Re: Showing weeks on x axis in QlikView

Showing weeks on x axis

Anonymous — Wed, 21 Aug 2013 15:31:46 GMT

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

Re: Showing weeks on x axis

whiteline — Sat, 24 Aug 2013 20:29:26 GMT

Hi.

It seems like it could be solved with set analysis.

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

Re: Showing weeks on x axis

matthieu_burel — Sat, 24 Aug 2013 21:00:58 GMT

Perhaps could you try something like ...

= IF(getselectedcount(Col1) = 0,

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

startweek

Null()

)

startweek

)