topic Re: Sales periods in QlikView

Sales periods

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

1. implement a qv diagram in which you can specify the top 10 periods with the maximum total amount of sales

- the sales period is the two dates between which sales were made daily.

2. implement a similar diagram, but taking into account the categories of goods

- sales period by category, these are two dates, between which sales of goods of the same category were made daily

Re: Sales periods

Anil_Babu_Samineni — Wed, 07 Nov 2018 03:13:05 GMT

If i understand correct

1) Sum({<SALES_DATE={">=$(=Min({1}SALES_DATE))<=$(=Max({1}SALES_DATE))"}, SALES_CATEGORY={"=Rank(Sum({<SALES_DATE={">=$(=Min({1}SALES_DATE))<=$(=Max({1}SALES_DATE))"} SALES_PRICE))<=10"} >} SALES_PRICE)

2) Not understand, What do you mean "between which sales of goods of the same category were made daily"