Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

zagzebski
Contributor

Setting criteria for minimal sales

This shoud be so simple but I am drawing a complete blank.

If I wanted to do something as basic as saying I want a dimension of SALES_PERSON and expression of Sum(Sales). Where would I add the crtiera to only pull back only SALES_PERSON with sales greater than 5000?

I tried to do it by checking the "Enable Condition" area on the dimension tab and adding sum(sales)>5000. I also tried to add to use the "Conditional" checkbox on the presentation tab and adding sum(sales)>5000 to the SALES_PERSON column. Neither worked.

I know this should be simple!

Tags (2)
1 Solution

Accepted Solutions

Re: Setting criteria for minimal sales

For your expression:

sum({<SALES_PERSON={'=sum(Sales)>5000'}>}Sales)

2 Replies

Re: Setting criteria for minimal sales

For your expression:

sum({<SALES_PERSON={'=sum(Sales)>5000'}>}Sales)

gopalopsharma
Contributor

Re: Setting criteria for minimal sales

Hello Zagzebeski,

There is one simple method, to use "Dimension Limit" tab. You can explore and do a lot of things with this functionality.

One thing to be taken care of is that the Dimension limit is calculated only on the first expression in the chart.

Community Browser