topic Re: Get Min value of Expression in QlikView

Get Min value of Expression

sunilkumarqv — Mon, 22 Dec 2014 06:39:43 GMT

Hi ,

I need to get min value in expression into other

Example

Data,value

A,23

B,35

C,55

D,44

E,33

If Data was dimension then expression was sum(value) then in one more expression need get min value like below

Data,value,Min value

A,23, 23

B,35,-

C,55,-

D,44,-

E,33,-

Re: Get Min value of Expression

amit_saini — Mon, 22 Dec 2014 06:41:59 GMT

Sunil,

This will help u:

http://community.qlik.com/message/212463#212463

Thanks,

Re: Get Min value of Expression

amit_saini — Mon, 22 Dec 2014 06:46:57 GMT

Check attachment.

Thanks,

Re: Get Min value of Expression

sunilkumarqv — Mon, 22 Dec 2014 06:55:33 GMT

But im my case im not simply used sum of value there we used if else conditions in expression .

i wonder helps for the same .

Re: Get Min value of Expression

amit_saini — Mon, 22 Dec 2014 06:58:46 GMT

Yes this will work for sure even if u are using if condition.

Thanks,.
AS

Re: Get Min value of Expression

jyothish8807 — Mon, 22 Dec 2014 07:09:30 GMT

Hi Sunil,

Try this:

if(min(value)=min(total value),min(value),'-')

Regards

Re: Get Min value of Expression

its_anandrjs — Mon, 22 Dec 2014 07:21:33 GMT

Hi,

What if you use

Dim:-Data

Expre:- Sum(Value)

Expre:- Min(Value)

And output is

Regards

Anand

Re: Get Min value of Expression

MK_QSL — Mon, 22 Dec 2014 10:20:04 GMT

Create a Chart

Dimension

Data

Expressions

SUM(values)

IF(SUM(value) = Min(TOTAL Aggr(SUM(value),Data)), SUM(value))

Re: Get Min value of Expression

anbu1984 — Mon, 22 Dec 2014 10:26:05 GMT

Dimension: Data, value

Expr: Sum(value) , If(value = Min(TOTAL value),value)

Dimension: Data, value

Expr: If(value = Min(TOTAL value),value)

Uncheck "Suppress Zero Values" in Presentation tab

Re: Get Min value of Expression

sunilkumarqv — Mon, 22 Dec 2014 10:26:11 GMT

Thanks for your help anyhow that really helps me,i Quite change the expression get the result .

Re: Get Min value of Expression

sunilkumarqv — Tue, 30 Dec 2014 07:47:23 GMT

what about in case of distinct values

Data,value

A,23

B,23

C,55

D,44

E,33

Re: Get Min value of Expression

anbu1984 — Tue, 30 Dec 2014 07:52:08 GMT

If(value = Min(TOTAL value),value)