topic If value = minimum value and value = .. then in QlikView

If value = minimum value and value = .. then

stevenpiers — Wed, 10 Oct 2018 15:26:41 GMT

Hi,

I'm looking for a proper expression for the following issue:

I have a list of items (30.000 + rows and counting...) for which I know what kind of packaging it is (column STREEP) and if I want to publish it (column VPUIT)

For the minimum absolute value of STREEP and with VPUIT value 1 I want to show the articles in a pivottable. So for my calculated dimension I'd like to have this expression.

The yellow marked cells in the sample file should be the result

Is there anyone who can help me out? Thanks in advance!!

Re: If value = minimum value and value = .. then

chrismarlow — Wed, 10 Oct 2018 15:42:50 GMT

Does this do it?

FirstSortedValue({<VPVUIT={1}>}STREEP,fabs(STREEP))

Regards,

Chris.

Re: If value = minimum value and value = .. then

dplr-rn — Wed, 10 Oct 2018 16:00:39 GMT

try something like this

aggr(max({<VPVUIT={1}>}STREEP),Artikel) this will return the appropriate value of STREEP

Re: If value = minimum value and value = .. then

stevenpiers — Thu, 11 Oct 2018 07:21:54 GMT

Hi Chris,

Unfortunately no... I get a NULL result, thanks though.

Re: If value = minimum value and value = .. then

stevenpiers — Thu, 11 Oct 2018 08:06:01 GMT

Hi Dilip,

My result should be as below. Your expression does work but needs a little extra effort I'm afraid. Your help is very appreciated!

Re: If value = minimum value and value = .. then

stevenpiers — Thu, 11 Oct 2018 08:08:01 GMT

Weight in Requested Result should be 304 of course...

Re: If value = minimum value and value = .. then

dplr-rn — Thu, 11 Oct 2018 10:29:04 GMT

whats your expression for weight?

Re: If value = minimum value and value = .. then

chrismarlow — Thu, 11 Oct 2018 13:39:41 GMT

It appeared to work for me, but looking at the later posts there is more to your data model .

Attaching the app just in case it is of any use (I do have personal edition though).

Regards,

Chris.

Re: If value = minimum value and value = .. then

stevenpiers — Tue, 16 Oct 2018 09:23:23 GMT

The app is too big and sensitive to send. I'll try to make a workable version. I'll get back to you asap.