Sales Dashboard

[#1]

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

[nlmmaurya]

To calculate year use Year function

Year(Date)

[carolin01]

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

[vikasmahajan]

- 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

[#5]

Hello Neelam,

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

Regards

Saurabh

[nlmmaurya]

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

[#7]

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

[#8]

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.

[#9]

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.

[Anonymous]

Year(OrderDate) as OrderYear

The above one should be in your Data table

And match this one to your Master Calandar