Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

yrstruly
New 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 …

5 Replies
Highlighted
sujeetsingh
Honored Contributor III

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

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
New Contributor

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

Here is a Straight table i created.

yrstruly
New Contributor

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

Here is the data model.

sujeetsingh
Honored Contributor III

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

Did you tried the aggregate.

yrstruly
New Contributor

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

Please elaborate?