Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
akpofureenughwu
Creator III
Creator III

Data analysis

Good day everyone,

I have lot of tables on excel I got to merge to built a monthly, quarter, half- year, yearly report.

I need clues especially for the combination of the month....

Please find attached excel file for clarity. Thanks

I'm proposing putting the data on sql but how to manage the date in a challenge..

5 Replies
HirisH_V7
Master
Master

Hi,

Just checked your file, Can you please elaborate your requirement and make some sample data to analyse it easy way.

-Hirish

HirisH
“Aspire to Inspire before we Expire!”
jonas_rezende
Specialist
Specialist

Hi, Akpofure Enughwure.

Do you want link the tables through field [INVOICED AMOUNT]?

The makedate() function you can help to format the date. Ex.: Makedate(Year([INVOICED AMOUNT]) ,Month([INVOICED AMOUNT])) //If no day is stated, 1 (the 1:st) is assumed.

After, create it master calendar - https://community.qlik.com/thread/48693

Regards,

Jonas Melo.

akpofureenughwu
Creator III
Creator III
Author

Hello everyone, Thanks for your response.

hirishv7

I have update the excel file I sent earlier, Hopefully that will help..

I need to build an app that will report customer's activities in monthly,  quarter and half year interval.

as well obtain the customer's sum of certain item (Sales invoiced)say  at a defined  period ( a full year).

jonas.rezende

Can you throw more light on your suggestion if you can build an ap with the updated excel file?

stalwar1

Hey bro, I need your help on this one.

Thanks everyone.

Colin-Albert

There is a great document by marcus_sommer that brings together many items from the community showng how to use dates in Qlik.

How to use - Master-Calendar and Date-Values

This will show you how to create a calendar that links a date to the various date parts - month, year, quarter etc.

akpofureenughwu
Creator III
Creator III
Author

colin_albert

Thanks for your suggestion,

Can you help me with previous app on master calenderat your disposal so I can practice with it?

Thanks