topic if condition in min value in QlikView

if condition in min value

Mon, 21 May 2012 09:25:39 GMT

Hi all
I have to calculate the min value of the size "sales".
I know that the syntax is: min(sales)
Before calculating the min I have to normalize the format of the sale's values. For do this I use this:

if(sales<100, sales,
if(sales>100 and sales<10000, sales/100,
if(sales>10000, sales/1000)))
Now how can I calculate the min of the value "sales" determined in the if condition?

Thanks

Re: if condition in min value

jagannalla — Mon, 21 May 2012 09:48:14 GMT

Hello,

Main:

Load *,

if(sales<100, sales,

if(sales>100 and sales<10000, sales/100,

if(sales>10000, sales/1000))) as TempSales

From Table;

Load Min(TempSales) as MinSalesValue

Resident Main;

Hope it hepls you.

if condition in min value

Mon, 21 May 2012 09:54:40 GMT

But i have to do this in the script?

There isn't a way to do it in the expression editor of the chart where i have to calculate the min?

if condition in min value

Jason_Michaelides — Mon, 21 May 2012 10:32:25 GMT

Can't you just wrap the whole expression in Min()?

Min(

if(sales<100, sales,

if(sales>100 and sales<10000, sales/100,

if(sales>10000, sales/1000)))

)

Although I would probably recommend that in the script you define a factor and use this instead of the nested IF in the UI:

Sales:

LOAD

if(sales<100, 1,

if(sales>100 and sales<10000, 100,

if(sales>10000, 1000))) AS SalesFactor

FROM....;

Then, in the UI:

Min(Sales/SalesFactor)

Hope this helps,

Jason

if condition in min value

Mon, 21 May 2012 10:51:05 GMT

Thanks!