HOW TO FIND HIGHEST SELLING PRODUCT

Fri, 12 Jun 2015 06:57:51 GMT

I want to fetch the product whose sales is highest and store it into a variable. can anyone help. In short I want The name of the product whose rank is 1.

SUJIT

Re: HOW TO FIND HIGHEST SELLING PRODUCT

robert_mika — Fri, 12 Jun 2015 10:32:56 GMT

t1:

load * inline [

sales,product

1,A

3,B

4,C]

;

temp:

Load Max(sales) as MaxValue Resident t1;

Let vVariable=FieldValue('MaxValue',1);

t2:

load product as p

resident t1

where sales=$(vVariable);

Let vVar=FieldValue('p',1);

topic HOW TO FIND HIGHEST SELLING PRODUCT in QlikView

HOW TO FIND HIGHEST SELLING PRODUCT

Re: HOW TO FIND HIGHEST SELLING PRODUCT