topic calculated dimension in QlikView

calculated dimension

Thu, 12 Nov 2015 05:27:49 GMT

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?

Re: calculated dimension

tresB — Thu, 12 Nov 2015 05:40:10 GMT

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])

Re: calculated dimension

Kushal_Chawda — Thu, 12 Nov 2015 05:47:48 GMT

You need aggr function

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

Re: calculated dimension

Thu, 12 Nov 2015 06:17:01 GMT

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.