topic Re: First minimum value in QlikView

First minimum value

qvqfqlik — Fri, 27 Jan 2017 17:15:07 GMT

I need help with calculating first minimum Unit price for an Offer number within Same Division

eg below: In division 07, need to see any one of the Offer numbers with Minimum Unit Price

Re: First minimum value

sunny_talwar — Fri, 27 Jan 2017 17:30:44 GMT

There is 4 minimum Unit Price for Division 07... which OfferNo you want to see and where do you want to see this information?

Re: First minimum value

qvqfqlik — Fri, 27 Jan 2017 18:38:37 GMT

in the same chart I need the display the data

within a division, I need to display any one of record the Offer number that is having same minimum Unit price

for eg: for division 07 , any one of those offer numbers with minimum price, now that all offers in that division have same price, I need to display on of those instead all the four offers numbers

This should happen for all the divisions.

Re: First minimum value

sunny_talwar — Fri, 27 Jan 2017 18:51:06 GMT

Instead of using OfferNo as a dimension, try an expression like this:

Dimension

ITEMNO

DIVISION

UNIT_PRICE

Expression

If(UNIT_PRICE = Min(TOTAL <ITEMNO, DIVISION> UNIT_PRICE), MinString(OFFERNO))