Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

ilanbaruch
Contributor III

orders above 100k of top 5 customers

hi all

in my model i have a pivot table with 4 dims. and 1 expression , i would want to sum in the expression 

only the orders above 100k of the top five customers.

 

any ideas ?

advanced thanks

4 Replies
Claudiu_Anghelescu
Contributor III

Re: orders above 100k of top 5 customers

Try using Dimension Limits.

sample.PNG

To help community find solutions, please don't forget to mark as correct.
Highlighted
shiveshsingh
Honored Contributor

Re: orders above 100k of top 5 customers

You can define it in Dimension Limits tab

ilanbaruch
Contributor III

Re: orders above 100k of top 5 customers

hi, there is no Dimension Limits in a pivot object..
dapostolopoylos
Contributor III

Re: orders above 100k of top 5 customers

Check out the attached document, i believe it will be helpful

 

Father/Husband/BI Developer