topic Re: Add when no record found in QlikView

Add when no record found

Fri, 04 Oct 2013 17:44:38 GMT

I need to create a straight or pivot table that has dimensions of Sales Person and Customer. For a selected product type (set analysis) sales are totaled in an expression. I need the chart to show the top 5 customers for a sales person and then create a "dummy" customer called "Other Customers" with the total of sales for customers not in the top five. Also if a Sales person has no customer with sales for the product type I need the sales person to show and the customer dimension to show "Other Customer" with a sales total of 0 (zero).

How can I do this?

Thanks,
Stephen

Re: Add when no record found

swuehl — Fri, 04 Oct 2013 18:03:05 GMT

Have you looked into the dimension limits feature? I think this should solve your top 5 and Others requirement, though I am not really sure if this handles the zero sales value correctly.

Re: Add when no record found

Gysbert_Wassenaar — Fri, 04 Oct 2013 18:28:46 GMT

Using a straight table you can set the dimension limits for the second dimension Customer to Show Largest 6 values and enable the Others option. You won't be able to show the zero sales though.