Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
coddra_6
Contributor III
Contributor III

Last Date by Time Hierarchical Group

Hey, What's up?

I get a problem, I have a time hierarchical group (Year, Month, Day) where I hace clients accounts, when I see them daily it shows correctly how it close at the end of the day adding the amounts of the accounts by client, but when I wanna see them monthly it adds all the amounts of all the account of all the days of the month and I just wanna the sum of the amount of the last day of the month. It happens the same way when i wanna see them annually.

Example:

Date          Client           Account   Amount   

29/11/2012    Alberto Rojas    10015     1,000.00

29/11/2012    Alberto Rojas    10030     3,000.00

30/11/2012    Alberto Rojas    10015     1,500.00

30/11/2012    Alberto Rojas    10030     4,500.00

What I wanna see when I select daily is:

Fecha          Cliente          Total

29/11/2012     Alberto Rojas    4,000.00

30/11/2012     Alberto Rojas    6,000.00

And Monthly is:

Fecha          Cliente          Total

30/11/2012     Alberto Rojas    6,000.00

I was trying to do it with If(IsNull(NombreMes), Sum({<[Fin Mes] = {'S'}>} Monto), Sum(Monto))

I hope you can help me.

1 Reply
Gysbert_Wassenaar

Try creating some flag fields in the script. You can use these to filter the data based on the current field in the group. See attached qvw.


talk is cheap, supply exceeds demand