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: 
niha
Creator II
Creator II

Lag Triangle in QlikSense

Hello,

This is my dummy data.

Service ReceivedDateServicePaidDateServiceAllowedAmt
1/2/20171/9/2017$143.16
1/16/20172/23/2017$339.20
1/13/20173/1/2017$478.00
1/19/20174/30/2017$342.00
1/6/20175/20/2017$206.05
1/31/20176/15/2017$589.00
1/10/20171/28/2017$123.63
1/26/20172/18/2017$300.00
1/9/20173/3/2017$653.00
1/3/20176/6/2017$23.00
2/23/20173/6/2017$103.56
2/6/20174/1/2017$78.00
2/4/20172/26/2017$2,076.00
2/26/20173/26/2017$3,906.00
2/18/20174/6/2017$20.00
2/8/20175/5/2017$212.00
2/13/20174/26/2017$42.13
2/3/20175/16/2017$99.57
2/8/20173/20/2017$78.00
2/13/20174/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.

Untitled.png

 

But I am expecting a  Triangle like below:

Untitled3.png

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
Channa
Specialist III
Specialist III

can you share your expression

Channa
niha
Creator II
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

niha
Creator II
Creator II
Author

Hi,

I think I got the answers . Thanks