Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Mahamed_Qlik
Specialist
Specialist

Source data format

Hi Experts,

Seeking for your help here.
Attached is file format which is source data.
In Sheet 1 :  Sample data with actual format.
In Sheet 2: Expected data in table object.

 

Note: In expected data, all the year data needs to be, in sample it is given only for one year.
Kindly help.

 

Regards,

Mahamed

Labels (1)
3 Replies
Mark_Little
Luminary
Luminary

HI @Mahamed_Qlik 

When i am speaking with people on project i would first explain that that is not data, that is information as it is data put into context so not idea for loading.

Is the source data used to create the report available?

Mahamed_Qlik
Specialist
Specialist
Author

Hi Mark,

Yes. Even though  it is information but business wants to use as data for reporting purpose.
 

Mahamed_Qlik
Specialist
Specialist
Author

Hi Mark

Got any solutions??