topic Re: Set Analysis - Filter the Dimension and Ignore all Filters for Count in QlikView

Set Analysis - Filter the Dimension and Ignore all Filters for Count

Thu, 10 Sep 2015 10:02:17 GMT

I have a table information in pivot table as below with filtering by date (08 Aug and 09 Aug)

My problem is outstanding only show for specific date which is 08-Aug and 09-Aug, i would like to show the total of outstanding instead of specific date (e.g. 09-Aug = 800++). How can I do it and what formula can be apply?

In fact the total outstanding for processor is 800++

Processor	ABC
Date	08-Aug	09-Aug
Vol Received	101	171
Vol Processed	139	128
Outstanding	183	249

Re: Set Analysis - Filter the Dimension and Ignore all Filters for Count

Thu, 10 Sep 2015 20:46:41 GMT

Please elaborate the question with some examples.

Re: Set Analysis - Filter the Dimension and Ignore all Filters for Count

Fri, 11 Sep 2015 02:01:38 GMT

For example, by refer to As-Is table outstanding only show for specific date which is 08-Aug and 09-Aug only.

Total Outstanding for processor "ABC" as at 09 Aug is 800 cases (To be table). I would like to show the total of oustanding 800 cases for processor "ABC". Appreciate if your could share with me what formula should be apply?

As-Is			To-Be
Processor	ABC		Processor	ABC
Date	08-Aug	09-Aug	Date	08-Aug	09-Aug
Vol Received	101	171	Vol Received	101	171
Vol Processed	139	128	Vol Processed	139	128
Outstanding	183	249	Outstanding		800

Re: Set Analysis - Filter the Dimension and Ignore all Filters for Count

sunny_talwar — Fri, 11 Sep 2015 03:04:57 GMT

How did you come up with 800 for Outstanding? Without knowing the logic, we will have a hard time giving you any solution. Can you share raw date behind your above example?