calculated dimension

[#1]

Hi

I want a dimension which displays weekend values but data range must be weekstart to weekend. so i made calculated dimension as :

=only({<[Number Date]={">=[Week First date] <=[Week Last date]"}>}([Week Last date]))

but as we know only must be used when inner set returns 1 value.

can any 1 suggest a way to achieve this?

[tresesco]

prudhvi teja wrote:

.....

but as we know only must be used when inner set returns 1 value.

I really did not get this point. Could you share a sample qvw and explain the expected output? What I guess is you probably need aggr() here. May be like:

=Aggr(only({<[Number Date]={">=[Week First date] <=[Week Last date]"}>}([Week Last date])), [Week Last date])

[Kushal_Chawda]

You need aggr function

aggr(only({<[Number Date]={">=[Week First date] <=[Week Last date]"}>}([Week Last date])),[Number Date])

[#4]

Hi tresesco,

wat i mean is i have weekfirst date and weeklast date for a calender date.

in 1 chart i have weeklast date as dimension and count(employee number) as measure. but for some weeks wrong values are displayed. so i am thinking to restrict explicitly the dimension to include date range from week strt to week last for a respective week last date.

pls find attachment.