Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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"

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)