show detailed information per month

[#1]

Hello friends

I'm building a report and I have the NEXT issue.

I have a date "Transaction date" used as a method to filter information. For example: "View all transactions in January," as shown below.

The only information I list when it was "stored" or where "there are changes" in one transaction day. What I need is to see the full performance of January a day, it does not matter if the number in column "AVG ON-HAND BALANCE" and "ANNUAL DEMAND repeat for every day that no changes have occurred. As shown below.

Thanks in advance !

Karen[:S]

jan-10	Onhand balance	Annual Demand	RMT
1	2 216	302016	136
2	2 216	302016	136
3	2 216	302016	136
4	2 216	302016	136
5	2 216	302016	136
6	2 216	302016	136
7	2 216	302016	136
8	2 216	302016	136
9	2 216	302016	136
10	2 216	302016	136
11	2 216	302016	136
12	2 216	302016	136
13	2 216	302016	136
14	2 216	302016	136
15	2 216	302016	136
16	2 216	302016	136
17	2 216	302016	136
18	2 216	302016	136
19	2 216	302016	136
20	2 216	302016	136
21	2 216	302016	136
22	2 216	302016	136
23	2 216	302016	136
24	2 216	302016	136
25	2 216	302016	136
26	2 216	302016	136
27	2 300	302016	131
28	2 300	302016	131
29	4 250	302016	71
30	4 250	302016	71
31	4 250	302016	71
Average	2 418	302016	125

I do not know if the solution is to create a date variable and see if the records are within the range month for example .... I think I'm a little confused! besides I am new to this forum and QlikView!

[#2 · Accepted solution]

Good morning Karen,

here are a modified version. I hope it point you in the right direction.

Good luck!

Rainer

[#3]

Beautiful morning for you!

Now my file works great.

Without you this would not have been possible.

The biggest of hugs to you master! and my apologies if I've used your time to help me.

Have a beautiful day,

I hope we keep in touch! (Hehehehe)

Thanks again Rainer!!!

Karen

[#4]

Beautiful morning for you!

Now my file works great.

Without you this would not have been possible.

The biggest of hugs to you master! and my apologies if I've used your time to help me.

Have a beautiful day,

I hope we keep in touch! (Hehehehe)

Thanks again Rainer!!!

Karen