topic Re: Sales Dashboard in QlikView

Sales Dashboard

Wed, 14 May 2014 07:30:22 GMT

Hello Group,

I am new to qlickview and want to prepare sales dashboard. Below are the parameter, I am planning to use

Which product has taken maximum time to ship ( Ship date - Order date)?

- order date - Ship date - Product category - Product subcategory - Product name

As we have many order date available including different moth , years and dates. But I want to combine all dates into year( Ex : any date or month belong to 2010 years should show me only 2010 in Filed etc)

Also want to display sales and profile in same bar graph adjacent to each other.

Please suggest, how can I achieve this. Thanks in advance.

Regards

Re: Sales Dashboard

nlmmaurya — Wed, 14 May 2014 07:42:55 GMT

To calculate year use Year function

Year(Date)

Re: Sales Dashboard

carolin01 — Wed, 14 May 2014 07:44:16 GMT

Hi,

to get the year out of your date field use:

Year(OrderDate) as OrderYear,

I´m not quite sure if you are searching for a sum function to get the sum of sales:

You could use it as as chart expression if you use the OrderYear as dimension then:

sum(Sales) as SumSales,

sum(Profile) as SumProfile,

Best regards

Carolin

Re: Sales Dashboard

vikasmahajan — Wed, 14 May 2014 07:48:46 GMT

- Create Master Calender

- Create Data Model using link tables with all possible combinations with keys.

- Create Sql Scripts to fetch data into qvd.

- Apply Incremental Load

- QlikView

Linke for demo.

Vikas

Re: Sales Dashboard

Wed, 14 May 2014 07:49:39 GMT

Hello Neelam,

Thanks for reply. Can I call you to discuss further, rather then discussing here.

Regards

Saurabh

Re: Sales Dashboard

nlmmaurya — Wed, 14 May 2014 07:58:39 GMT

Hi,

If u want to find Which product has taken maximum time to ship then use this:

Calculate max(count(Ship Date)) group by Product.

It may work for you.

Regards,
Neelam

Re: Sales Dashboard

Wed, 14 May 2014 08:01:05 GMT

Hello Neelam,

Is it possible to talk to you on phone, as it will be easy for me doing this dashboard.

Waiting for positive reply.

Regards

Saurabh

Re: Sales Dashboard

Wed, 14 May 2014 10:07:31 GMT

Hello,

In SET section of edit script, I have put

SET DateFormat='YYYY'; to get only years. But I want to group the years, as currently I am getting same year multiple times. Can you please suggest, how do I achieve this.

Re: Sales Dashboard

Wed, 14 May 2014 10:17:40 GMT

Hello,

In SET section of edit script, I have put

SET DateFormat='YYYY'; to get only years. But I want to group the years, as currently I am getting same year multiple times. Can you please suggest, how do I achieve this.

Also where I need to post this calculation. Will it be under SET or LOAD section of edit script.

Re: Sales Dashboard

Anonymous — Wed, 14 May 2014 11:02:08 GMT

Year(OrderDate) as OrderYear

The above one should be in your Data table

And match this one to your Master Calandar

Re: Sales Dashboard

Wed, 14 May 2014 11:06:45 GMT

Hello Jebalmalai,

Thanks for reply. As I am new to this tool, Can you please provide me your contact detail, So that I can call you to take your help.

Regards

Saurabh

Re: Sales Dashboard

Anonymous — Wed, 14 May 2014 11:10:18 GMT

Hi Saurabh,

Not sure I can share the number in this public forum.

But can you please post the document with some dummy numbers,I will find out the issue and reply.

Regards

Jeba

Re: Sales Dashboard

Wed, 14 May 2014 11:13:45 GMT

Hello Jeba,

Thanks for reply. Can you please add me on gmail atleast. sourabhkhandelwal123@gmail.com

As its difficult for me to get your help on this chat. Hope your wont mind. Or You can give me miss call on 08886400400 my mobile .

Thanks & Regards

Saurabh

Re: Sales Dashboard

Wed, 14 May 2014 11:40:02 GMT

Are you there now.

Regards

Saurabh

Re: Sales Dashboard

Wed, 14 May 2014 13:08:35 GMT

Hello,

I am still waiting for solution . Can anybody help me

Regards

Saurabh