Calculated Dimension problem

[#1]

Hello Fellow QV users,

I have one dimension and one expression.

Dimension = Customer

Expression= SalesValue

I have created a pivot table. I would like to see only the customers with a SalesValue above or equal to 10.000. Can someone help me with this.

Regards,

Aissam

[#2]

John helped me answer a similar question I had last week. See if this link explains what you are looking for...

http://community.qlik.com/forums/t/32762.aspx

[#3]

Thanks for your response.

Unfortunately I am not looking for the best or worse values. I would like to see every customer that has a SalesValue of 10.000 euro or more. So I don't know what my variable is (<=10) to use in your particaller formula.

Regards,

Aissam

[martin59]

Hi,

Look at the attachement, i've created a calculated dimension which hide resellers when sales are above or equal to a value stored in a variable.

Hope that helps you

[montubhardwaj]

Hi Chiki,

in the expression, you can specify the condition like below:

=if(Sales>=10,000,Sales)

Please see the attached. Hope you got what you were looking for.

Regards,

Sharma

[#6]

And I certainly did not meant to suggest my own answer....

[#7]

Hi Guys,

Thanks for your comments.

The comment of Sharma, did not work because I have 3 expresions, I did not wrote this in my previous question.

The comment of Martin I did not understand, I could not create the Variable "vSalesAmount"

I have attached an excel file of the Table I created. The headers contain the scripts. Could you please help me to create the following script. I would like to see the Contracts where column (sum(JC.NetBillingActual)+sum(JC.NetBillingForecast)) is equal or greater then 10000.

Hope this helps,

Greetings,

Aissam

[martin59]

Hi,

See the calculated dimension :

=if(aggr(sum(JC.NetBillingActual)+sum(JC.NetBillingForecast),Contract)>=10000,Contract)

Hope that helps you