topic Re: Restrict dimension based on calculated value in QlikView

Restrict dimension based on calculated value

Thu, 13 Sep 2012 21:46:58 GMT

I am trying to create a table which would show me the top 20 customers based on sales who have made at least 5 purchases in a Straight Table. I have added a condition to the table loading that states:

Count(Sales.id) > 5

which stops the entire table from loading data if the total number of sales is less than 5. However, what I want is to stop the loading of a particular row in the table if the total number of sales is less than 5. I tried putting in the following expression into the dimension for the table, but I get an "Error in calculated dimension":

if(Count(Sales.id) > 5, Customer.name)

How do I go about doing this?

Thanks!

Re: Restrict dimension based on calculated value

whiteline — Fri, 14 Sep 2012 09:15:20 GMT

It's not so easy.

You have to explain to QV how this expression should be calculated:

=aggr(if(Count(Sales.id) > 5, Customer.name), Customer.name)

Re: Restrict dimension based on calculated value

Fri, 14 Sep 2012 10:05:47 GMT

Dear Elie,

Please see the attached QV File.

Regards

Mhatim