Get Min value of Expression

[sunilkumarqv]

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,-

[amit_saini]

Sunil,

This will help u:

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

Thanks,

AS

[amit_saini]

Check attachment.

Thanks,

AS

[sunilkumarqv]

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 .

[amit_saini]

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

Thanks,.
AS

[jyothish8807]

Hi Sunil,

Try this:

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

Regards

KC

[its_anandrjs]

Hi,

What if you use

Dim:-Data

Expre:- Sum(Value)

Expre:- Min(Value)

And output is

Regards

Anand

[MK_QSL]

Create a Chart

Dimension

Data

Expressions

1)

SUM(values)

2)

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

[anbu1984]

Dimension: Data, value

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

Or

Dimension: Data, value

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

Uncheck "Suppress Zero Values" in Presentation tab

[sunilkumarqv]

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