topic Calculated Dimension problem in QlikView

Calculated Dimension problem

Mon, 23 Aug 2010 15:24:34 GMT

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

Calculated Dimension problem

Mon, 23 Aug 2010 15:39:13 GMT

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

Calculated Dimension problem

Mon, 23 Aug 2010 15:59:59 GMT

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

Re. :Calculated Dimension problem

martin59 — Mon, 23 Aug 2010 16:19:11 GMT

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

Calculated Dimension problem

montubhardwaj — Mon, 23 Aug 2010 16:20:14 GMT

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

Calculated Dimension problem

Mon, 23 Aug 2010 19:50:16 GMT

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

Re. :Calculated Dimension problem

Tue, 24 Aug 2010 14:01:32 GMT

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

Re. :Re: Re. :Calculated Dimension problem

martin59 — Mon, 30 Aug 2010 14:47:55 GMT

Hi,

See the calculated dimension :

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

Hope that helps you