Minumal value with certain criteria

[sculptorlv]

Hello!

The problem is...

I have the chart in my qlikview report:

Number	Name	Type	Q	Price
1913654	GAIDA SIA	C-AULIKA		80
1913654	GAIDA SIA	C-PHEDRA	1	77
1913654	GAIDA SIA	C-PHEDRA	3	50
1913654	GAIDA SIA	C-PHEDRA	4	45
1913654	GAIDA SIA	C-PHEDRA	5	0

I can make an agrregation function to get minimal value for each Type:

=Aggr(MAX(Price,),Type) - the result is:

Number	Name	Type	Q	Price	Aggre
1913654	GAIDA SIA	C-AULIKA		80	80
1913654	GAIDA SIA	C-PHEDRA	1	77	77
1913654	GAIDA SIA	C-PHEDRA	3	50	77
1913654	GAIDA SIA	C-PHEDRA	4	45	77
1913654	GAIDA SIA	C-PHEDRA	5	0	77

Now,

I need to get similar formula to get MAX value for TYPE, where Q <=3 The result should be:

Number	Name	Type	Q	Price	Aggre
1913654	GAIDA SIA	C-AULIKA		80	80
1913654	GAIDA SIA	C-PHEDRA	1	77	50
1913654	GAIDA SIA	C-PHEDRA	3	50	50
1913654	GAIDA SIA	C-PHEDRA	4	45	50
1913654	GAIDA SIA	C-PHEDRA	5	0	50

How can I make such function??

Thank you in advance!!

[sculptorlv]

Really TNAK YOU!!

Something absolutely new for me ...

[sculptorlv]

Uhh... I forgot..   this number 3 is calculated value!!

sum(IF(InMonth(Bouth__PostingDate,Today(),-1),Bouth_Cofee_Item_Quantity,0))

Is it possible to migrate it in previous formula

[sunny_talwar]

Now you made it really complicated

Would it be possible to share a sample to check it out?

Preparing examples for Upload - Reduction and Data Scrambling