# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Live Chat, June 29th 10AM ET. Bring your Qik Sense Enterprise, Client Managed questions! REGISTER
cancel
Showing results for
Did you mean:
Creator II

## Lag Triangle in QlikSense

Hello,

This is my dummy data.

 Service ReceivedDate ServicePaidDate ServiceAllowedAmt 1/2/2017 1/9/2017 \$143.16 1/16/2017 2/23/2017 \$339.20 1/13/2017 3/1/2017 \$478.00 1/19/2017 4/30/2017 \$342.00 1/6/2017 5/20/2017 \$206.05 1/31/2017 6/15/2017 \$589.00 1/10/2017 1/28/2017 \$123.63 1/26/2017 2/18/2017 \$300.00 1/9/2017 3/3/2017 \$653.00 1/3/2017 6/6/2017 \$23.00 2/23/2017 3/6/2017 \$103.56 2/6/2017 4/1/2017 \$78.00 2/4/2017 2/26/2017 \$2,076.00 2/26/2017 3/26/2017 \$3,906.00 2/18/2017 4/6/2017 \$20.00 2/8/2017 5/5/2017 \$212.00 2/13/2017 4/26/2017 \$42.13 2/3/2017 5/16/2017 \$99.57 2/8/2017 3/20/2017 \$78.00 2/13/2017 4/16/2017 \$90.00

I created a pivot with Service Receive YearMonth and Service Paid Year Month as Dimension and Service Allowed Amount as Measure and I got as follows.

But I am expecting a  Triangle like below:

Note: As per data above in the Service   Receive Date of Jan , Service Paid Date in January 01/09/2017 and 1/28/2017 and the total amount in January 143+123 = 266 (around) . Service Paid in Feb  for Jan service Year is 339+300 = 639 (around).

But I am not getting the expected result . The second Picture is correct one . The first one is done by Pivot Table with Two dimension and measure as Sum(Service Allowed Amount). I think I have made some where wrong. Please advice.

Regards,

Niha

3 Replies
Specialist III

Channa
Creator II
Author

Hello,

I used a Pivot Table with dimension in Row as Service Year and in  Column and Expression is just Sum(ServiceAllowedAmount). I think some think has to be modified here.

Niha

Creator II
Author

Hi,

I think I got the answers . Thanks