topic Re: Data analysis in QlikView

Data analysis

akpofureenughwu — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Data analysis

HirisH_V7 — Fri, 01 Jul 2016 14:08:57 GMT

Hi,

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

-Hirish

Re: Data analysis

jonas_rezende — Fri, 01 Jul 2016 14:17:51 GMT

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.

Re: Data analysis

akpofureenughwu — Fri, 01 Jul 2016 16:04:53 GMT

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.

Re: Data analysis

Colin-Albert — Fri, 01 Jul 2016 16:12:48 GMT

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.

Re: Data analysis

akpofureenughwu — Fri, 01 Jul 2016 17:10:25 GMT

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