Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal will move to Qlik Community Oct 4. Temporary case outage Oct 3. READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
santhosh_k_n
Creator II
Creator II

Data presentation

hi all,

I am having data as follows,

DIm1Dim2ProductDateMeasere1Measure2Measure3Measure4Measure5Measure6
D1C1p11/11/2014 0:001000353025110
D1C1p11/12/2014 0:0001102500135
D1C1p11/13/2014 0:0001351003090145
D1C1p11/16/2014 0:00000000
D1C1p11/17/2014 0:000145502465130
D1C1p11/18/2014 0:0001300100130
D1C1p11/19/2014 0:00013032445117
D1C1p11/20/2014 0:000117150050217
D1C1p11/21/2014 0:0002172004355362
D1C1p11/24/2014 0:00000000
D1C1p11/29/2014 0:000362010100262
D1C1p11/30/2014 0:000262908045307
D1C1p11/31/2014 0:000307506044313
D1C1p12/1/2014 0:00031340067286
D1C1p12/2/2014 0:00028630023293

Where

1. Measure2 will be zero if measure1 is available

2. Data gets generated from the day Measure1 data is entered

3. Measure2=Measure6 from next day of the Measure1 entered

4. measure6 is calculated based on the measuer1 to measure5

Now when am applying filters on the above data and present in the report the result should be as follows,

1. From date: 01/01/204 to 30/01/2014

DIm1Dim2ProductMeasere1Measure3Measure4Measure5Measure6
D1C1p100000

2. From date 11/01/2014 to 30/01/2014

DIm1Dim2ProductMeasere1Measure3Measure4Measure5Measure6
D1C1p1100682231475307

3. from date: 15/Nov/2014 to 25/Nov/2014

DIm1Dim2ProductMeasere1Measure3Measure4Measure5Measure6
D1C1p114543281215

362

The report logic for Measure1 and Measure6 are as follows,

1. Measure1 = Measure1 is measure1 is available

                    or

Measeure1=Measure2 if Measeure2 is available

                    or

Measure1 =measure6 for the last date which is less than from date

2. Measure6= measure6 on To date

          or

Measure6=Measure6 of the last max date which is less than To date

Please guide

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached example.


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
santhosh_k_n
Creator II
Creator II
Author

Hi all,

I am able to present this data as required if i duplicate the Measure2 and Measure6 for each date(for missing dated in the table.) but this is increasing the data load and QVD size which is not suggestible.

Can you please guide on this for any alternate solution.

Regards,

Santhosh N

Gysbert_Wassenaar

See attached example.


talk is cheap, supply exceeds demand

View solution in original post

santhosh_k_n
Creator II
Creator II
Author

Hi Gysbert,

Thanks for the solution but I had one more issue hear.

The Data filter am using in the report is another field from a Calender related table and I am filtering the data in Transactions by mapping Date filed to the Date field in the Calender table.

Now in this scenario which date field i need to use in the expression.

BR,

Santhosh N

santhosh_k_n
Creator II
Creator II
Author

Hi Gysbert,

In the report i posted the 3rd case, where from date is 15th Jan which has no data, but on 15th the Measure 1 in report should be equal to the previous available date, that is 13th Jan's Measure6, can you please guide how to implement this.

Regards,

Santhosh