topic Re: Min and max value in QlikView

Min and max value

Tue, 14 Oct 2014 06:09:46 GMT

Hi ,

How to get the immediate (nearest) min value and immediate (nearest) max value for my selection, if I have some plans like 50,100,200,300,500. If I select the 200 plan, it also should show the min value as 100, max value as 300 for my selection.

Re: Min and max value

anbu1984 — Tue, 14 Oct 2014 06:21:00 GMT

Check this

Re: Min and max value

CELAMBARASAN — Tue, 14 Oct 2014 06:29:49 GMT

Hi anbu cheliyan

Small change(Bold) with your logic to get min value. Works if morethan one is selected

Minimum

=Alt(Max({<ID={"<$(=Min(ID))"}>}ID), Min(ID))

Maximum

=Alt(Min({<ID={">$(=Max(ID))"}>}ID), Max(ID))

Re: Min and max value

Tue, 14 Oct 2014 06:37:45 GMT

hi i want to use this in chart's expression, how i can use this?

Re: Min and max value

CELAMBARASAN — Tue, 14 Oct 2014 06:43:15 GMT

Use

$(=Alt(Max({<ID={"<$(=Min(ID))"}>}ID), Min(ID)))

$(=Alt(Min({<ID={">$(=Max(ID))"}>}ID), Max(ID)))

If you are going to use it in multiple places, then keep it in variable(Ctrl+Alt+V)

Lets say vMinValueExpr equal to =Alt(Max({<ID={"<$(=Min(ID))"}>}ID), Min(ID))

and vMaxValueExpr equal to =Alt(Min({<ID={">$(=Max(ID))"}>}ID), Max(ID))

Use in charts as $(vMinValueExpr) and $(vMaxValueExpr )

Re: Min and max value

Tue, 14 Oct 2014 07:11:12 GMT

Could you pls explain the inner working of this set exp?

Many Thanks

Re: Min and max value

Tue, 14 Oct 2014 07:26:53 GMT

Hii,

Please find the attached qvw for required output.

Thanks & Regards

Prince Anand