get a non-filtered count

Sat, 08 Aug 2009 02:06:48 GMT

hi guys,

I'm using a chart with a single dimension and a single expression which counts the number of orders that are filtered by the dimension. Instead of showing the actual count though I just want to show a percentage of total orders. How can I include this in my expression? Right now I'm using the expression:

count(distinct [order ID])

I've done something similar and got help on this forum for a case where I had two dimensions, and I wanted to get the percentage of orders in the second dimension with respect to the first dimension, so I used:

count(distinct [Order ID])/count(distinct total <[Advice Status]> [Order ID])

In this case the order ID's were filtered first by advice status, then by rule. So the numerator was a count of the orders for that rule for that advice status, then divided by the total number of orders for that advice status to get a percentage of a rule for a specific advice status.

What type of qualifier would I need to count the total order ID's after the filtering has been done?

get a non-filtered count

johnw — Sat, 08 Aug 2009 03:06:50 GMT

I'm not sure I'm following. It sounds like you would just flip on the "Relative" flag on the Expressions tab?

topic get a non-filtered count in QlikView

get a non-filtered count

get a non-filtered count