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

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

yrstruly — Sat, 16 Nov 2024 21:50:00 GMT

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).

sujeetsingh — Tue, 27 Nov 2018 03:17:30 GMT

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 — Tue, 27 Nov 2018 06:25:07 GMT

Here is a Straight table i created.

yrstruly — Tue, 27 Nov 2018 06:26:22 GMT

Here is the data model.

sujeetsingh — Wed, 28 Nov 2018 01:51:49 GMT

Did you tried the aggregate.

yrstruly — Wed, 28 Nov 2018 05:26:10 GMT

Please elaborate?