Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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