General Information (Help!)

Thu, 22 Oct 2015 12:21:53 GMT

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

Re: General Information (Help!)

Thu, 22 Oct 2015 14:26:25 GMT

is there anybody who could help me?

topic General Information (Help!) in QlikView

General Information (Help!)

Re: General Information (Help!)