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: 
yrstruly
Contributor
Contributor

Creating a Straight/Appropriate Table to view Total "Amount"

Can somebody please assist me?

I created a straight table to show the total amount by Category of  Excesses. The table doesn't display correctly. What am i doing wrong?

Display the Excesss Total Value per Unique Claim entry on the ClaimsListing table by adding the different type of Excesses together.

Ensure your date selection has an option to view data by Incident Period (MM/YYYY).

 

Please see: https://drive.google.com/open?id=1wk7AUNXITIsrzoY6uDgMxMFrvc-dO7n3 … AND https://drive.google.com/open?id=1Bdq0jxJ0g5cXg2jK_1YjUlr-josKXnkD …

Labels (4)
5 Replies
sujeetsingh
Master III
Master III

Well on there two ways to close this: 

 

 * One ensure your model have that slicing relationship.

 * Try using Aggregate function. It is one of the most powerful function of Qlik and fits in such requirements.

Please provide a sample app if need a deeper dig.

Thanks,

Sujeet

yrstruly
Contributor
Contributor
Author

Here is a Straight table i created.

yrstruly
Contributor
Contributor
Author

Here is the data model.

sujeetsingh
Master III
Master III

Did you tried the aggregate.

yrstruly
Contributor
Contributor
Author

Please elaborate?