Hi everybody,
I'm a new Qlikview user and i'm sorry if my question could be too easy for many expert users.
I have a database with my articles (field "Profilo") at which it's also associated the prices (field "Premio finale") required by seven firms (field "Aziende").
I'd like to create a pivot table that shows, for the selected firm (by a drop down menu):
- the articles for which the selected firm requires the lower price;
- the lower price;
- the second one lower price;
My aim is to show how much the firm that has the lower price, for a determined article, could reduce its price while keeping always the lower price
I have thought a pivot table with the following dimensions;
- Articles (field "Profilo");
- Firms (field "Aziende")
For the lower price I don't have any problem given by i fixed two variables as:
vRank=aggr(rank(-only({1<Azienda=>}[Premio finale])),Profilo,Azienda)
vPremio1=if($(vRank)=1,only([Premio finale]),0)
For the second one lower price I don't know how do it. I attached the file where i'm working and i would to thank in advance everybody who want to help me.
Regards
Alessandro
