Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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
Highlighted

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"

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)