Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
Really TNAK YOU!!
Something absolutely new for me ...
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
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