topic Re: Narrow down expressed values by setting some conditions/limits? in QlikView

Narrow down expressed values by setting some conditions/limits?

Tue, 09 Aug 2016 06:48:33 GMT

Hi Guys,

I'm trying to show expression values that are over 4,000 in below chart, which means only showing value 13,722 and 4,454, and off course their corresponding dimensions. How can I achieve that? The original expression here is simple as a SUM().

Set analysis seems not working on this.

Thank you!

Jia Junqing

Re: Narrow down expressed values by setting some conditions/limits?

Gysbert_Wassenaar — Tue, 09 Aug 2016 07:47:21 GMT

On the Dimension Limits tab enable the Show only values that are option and choose the Greater Than or Equal To option. Enter 4000 in the input field next to that and finally choose exact amount in third input field.

Alternatively you can try a set analysis expression: sum({<YourXaxisDimensionHere = {"=sum(Amount)>=4000"} >}Amount)

Re: Narrow down expressed values by setting some conditions/limits?

sunny_talwar — Tue, 09 Aug 2016 08:26:41 GMT

Or you can always use the if statement (which might be the only way if you have more than one dimension, unless you can uniquely define the two dimensions using a single field)

If(Sum(Amount) >= 4000, Sum(Amount))

Re: Narrow down expressed values by setting some conditions/limits?

Tue, 09 Aug 2016 09:06:08 GMT

Hello, Gysbert,

What if I have 2 expressions need to be conditioned, how to connect the two conditions for "YourXaxisDimensionHere", I tried setting conditions for each of the expressions, but the logic seems not AND, but OR. For example, I have below 2 expressions but I only want the dimension with columns red circled showing off.

Expression#1: SUM(Amount)

Expression#2: Count(Number)

Jia Junqing

Re: Narrow down expressed values by setting some conditions/limits?

sunny_talwar — Tue, 09 Aug 2016 10:03:47 GMT

May be this for and AND logic:

Sum({<YourXaxisDimensionHere = {"=sum(Amount)>=4000 and Count(Number) > X"} >}Amount)Re: Narrow down expressed values by setting some conditions/limits?

Re: Narrow down expressed values by setting some conditions/limits?

Wed, 10 Aug 2016 07:28:09 GMT

Thank you! works!