General Information (Help!)

[#1]

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

[#2]

is there anybody who could help me?