Data analysis

[akpofureenughwu]

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..

[HirisH_V7]

Hi,

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

-Hirish

[jonas_rezende]

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]

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]

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