Aggr and Sum

[#1]

Hi All,

I have a logic which I am not able to code in Qlikview.

We have a set of data, if the client clicks one specific day of the Month, the users should be able to see the data (sum) for the next 6 days including the selected day i.e 7 days data

Item	Date	Unit
ABCV	1-Jan-95	10
ABCV	2-Jan-95	20
ABCV	3-Jan-95	25
ABCV	4-Jan-95	30
ABCV	5-Jan-95	50
ABCV	6-Jan-95	20
ABCV	7-Jan-95	40

For example: If the selection is 01st Jan, the output for Item ABCV should be 195.

Thanks in Advance'.

[nilesh_gangurde]

Hi,

Use set analysis, by using set analysis you can implement it. or if possible share the sample data.

-Nilesh

[#3]

Hi Nilesh,

Please find the attached excel file. I did try to implement the same using set analysis however I was not successful in doing so. I guess my expression was not logically right to get the answer.

[jagan]

Hi,

Try this expression

=Sum({<Date={'>=$(=Date(Max(Date)))<=$(=Date(Max(Date) + 6))'}>}Unit)

Note : if above expression not working then check the date formats of Date dimension and Date(Max(Date)) are same.

Hope this Helps you.

Regards,

Jagan.

[#5 · Accepted solution]

Hi Hitesh,

Please find the attachement for the solution.

Santhosh G

[#6]

hitesh,

use the set expression as follows:

=Sum({<Date={'>=$(=Date)<=$(=Date + 6))'}>}Unit)