Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
vaizero01
New 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

Re: Sales periods

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)