topic Re: Show Minimum value in QlikView

Show Minimum value

Anonymous — Fri, 05 Sep 2014 13:20:24 GMT

Hi guys,

My first post which i am hoping you can help with !

Basically i have a table which returns the following

What i am trying to do is return just the lowest value within the customer price. This has been setup as an expression so hoping that this is possible?

Any help would be greatly appreciated.

Thanks!

Mel

Re: Show Minimum value

MK_QSL — Fri, 05 Sep 2014 13:24:18 GMT

Provide sample data please!

Re: Show Minimum value

Anonymous — Fri, 05 Sep 2014 13:28:02 GMT

Simply this could be what you are after :

Min ( [YourCustomerPriceExpression] )

If then could you share the expression and clarify.

Re: Show Minimum value

Anonymous — Fri, 05 Sep 2014 13:31:33 GMT

Sorry I thought the screenshot would suffice!

Here's the expression which is calculating the customer price

=Price-"Discount Amount"

Discount Amount is another expression.. Not sure if this helps?

Re: Show Minimum value

Anonymous — Fri, 05 Sep 2014 13:33:33 GMT

What if you try :

min ( Price-"Discount Amount")

Re: Show Minimum value

Anonymous — Fri, 05 Sep 2014 13:37:49 GMT

Unfortunately that just changes the values to "-" within the customer price

Re: Show Minimum value

jonathandienst — Fri, 05 Sep 2014 13:50:07 GMT

Assuming the customer price is calculated, then something like:

=Min(Aggr(Price * (1 - discount_perc), Price))

HTH

Jonathan

Re: Show Minimum value

Anonymous — Fri, 05 Sep 2014 14:00:39 GMT

Hi Jon

unfortunately that has still returned "-" within the column..

Re: Show Minimum value

JonnyPoole — Fri, 05 Sep 2014 15:11:00 GMT

To return the minimum price in the whole chart and repeat that value on each row use the TOTAL clause in the aggregation function (this case its min):

min( Total [Customer Price] )

If you want the minimum amongst other dimensional values (subtotal) add the dimension value like this

min( Total <dimension> [Customer Price] )

However, if your [Customer Price] is actually an expression instead of just a field, the syntax will change. What is the expression for [Customer Price] ?

Re: Show Minimum value

Anonymous — Mon, 08 Sep 2014 07:51:56 GMT

Hi there,

The expression which I am using to get the Customer Price is quite simple.. It just the price column minus the discount amount.

Expression for discount amount is - =((Price/100)*discount_perc)

Customer Price - =Price-"Discount Amount"

Thanks

Re: Show Minimum value

Anonymous — Thu, 11 Sep 2014 12:50:54 GMT

Hi guys,

With the help of both Bill and Jonathan I have figured this out! So thanks a lot for your help guys