topic Re: Aggr and Sum in QlikView

Aggr and Sum

Tue, 14 Jan 2014 05:58:34 GMT

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'.

Re: Aggr and Sum

nilesh_gangurde — Tue, 14 Jan 2014 06:06:58 GMT

Hi,

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

-Nilesh

Re: Re: Aggr and Sum

Tue, 14 Jan 2014 06:13:40 GMT

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.

Re: Aggr and Sum

jagan — Tue, 14 Jan 2014 06:29:11 GMT

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.

Re: Re: Re: Aggr and Sum

Tue, 14 Jan 2014 06:38:18 GMT

Hi Hitesh,

Please find the attachement for the solution.

Santhosh G

Re: Aggr and Sum

Tue, 14 Jan 2014 06:40:06 GMT

hitesh,

use the set expression as follows:

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