Solved: Count product by value list per week - Qlik Community - 2156279

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services | Qlik Help

Ask a Question

Hi, could someone help me in counting the product by value list per week found? I want the result would be like this:

1 Solution

Accepted Solutions

Load Valuelist,Product,DateFound,Week(DateFound) as ProductWeek

From XyzSource;

Then use a Pivot table

RowDimensions: Valuelist,Product

ColumnDimension: ProductWeek

Measure: Count(Product)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

2 Replies

Load Valuelist,Product,DateFound,Week(DateFound) as ProductWeek

From XyzSource;

Then use a Pivot table

RowDimensions: Valuelist,Product

ColumnDimension: ProductWeek

Measure: Count(Product)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

Load Valuelist,

Product,

DateFound,

'products in week'&Week(DateFound) as ProductWeek

From source