Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sales periods

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


1 Reply
Anil_Babu_Samineni

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"

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful