Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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
And I certainly did not meant to suggest my own answer....
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
Hi,
See the calculated dimension :
=if(aggr(sum(JC.NetBillingActual)+sum(JC.NetBillingForecast),Contract)>=10000,Contract)
Hope that helps you