Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stevenpiers
Contributor III
Contributor III

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

1 Solution

Accepted Solutions
chrismarlow
Specialist II
Specialist II

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.

View solution in original post

8 Replies
chrismarlow
Specialist II
Specialist II

Does this do it?

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

Regards,

Chris.

dplr-rn
Partner - Master III
Partner - Master III

try something like this

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

stevenpiers
Contributor III
Contributor III
Author

Hi Chris,

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

stevenpiers
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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

dplr-rn
Partner - Master III
Partner - Master III

whats your expression for weight?

chrismarlow
Specialist II
Specialist II

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
Contributor III
Contributor III
Author

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