Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problem with this Excell extraction data

Hello,

Someone could help me with the following?

I have this Excell document: (example.xlsl)

The problem is,I have 18000 products and I would like to know the amount sold each month of the year.

I thought creating a date field, but I would have to write all the prices by hand and it's impossible.

I would like an Excell like this,or there is any way to load data into the script that allows me to achieve this?

(ExampleSolve.xlsl)

How could i resolve this?

Thanks a lot!

Paula.

1 Reply
ashfaq_haseeb
Champion III
Champion III

May be like this.

Regards

ASHFAQ