Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
stevenpiers
New Contributor II

If value = minimum value and value = .. then

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

Tags (1)
8 Replies
chrismarlow
Contributor III

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

Does this do it?

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

Regards,

Chris.

dilipranjith
Valued Contributor II

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

try something like this

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

stevenpiers
New Contributor II

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

Hi Chris,

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

stevenpiers
New Contributor II

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

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!

Sample_IfValueMinimumValueAndValueThen.jpg

stevenpiers
New Contributor II

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

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

dilipranjith
Valued Contributor II

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

whats your expression for weight?

chrismarlow
Contributor III

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

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

316485.png

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

Regards,

Chris.

stevenpiers
New Contributor II

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

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

Community Browser