topic Filtering Dimension within the Accumulated Threshold is not working in QlikView

Filtering Dimension within the Accumulated Threshold is not working

Wed, 27 May 2015 06:00:19 GMT

Hi Experts

I have little Complex problem Please see below pic

Now i have following

Requirements:

1. Colored rows are the Project and Customers who are above the Company Budget

2. I need to hide the details of those who are above the budget (Colored Rows)

3. And 2nd Requirement is ,For example when we filter US and UK the customers within the budget only should be filtered ( in this case total cumulative unit should be 4 (Sort by Rank (Descending)) )

4. Sorting should be dynamic projects can be selected by sorting either by ranking or by probability (They must be sorted in descending order)

5. Note : Total Cumulative Amount is compared against Budget

Kindly help to Achieve this

Thanks in advance

Regards

Veeki

Re: Filtering Dimension within the Accumulated Threshold is not working

Wed, 27 May 2015 06:22:26 GMT

Hi Experts,

I have achieved the first requirement Hiding the rows by making all the expression rows which are above budget zero and then ticking suppress zero values option under Presentation tab.

regards

Veeki

Re: Filtering Dimension within the Accumulated Threshold is not working

Wed, 27 May 2015 06:38:17 GMT

Please help me to achieve the 2nd issue... the Complex one