topic Have day and month in same table in QlikView

Have day and month in same table

Thu, 07 May 2009 15:28:55 GMT

Hi !!

See the attached file

I want to have in a same table 2 cols with the sum of day and sum of month like it :

___________________________

| | 03/03/2009 | 03/2009 |

| Sum | 4 | 8 |

I don't know how do for have this 2 dimensions in a same table...

Tks for your help

Have day and month in same table

antose — Thu, 07 May 2009 16:07:11 GMT

Hi!

Try to add Month as a dimension, see example.

Regards Anders

Have day and month in same table

Thu, 07 May 2009 17:00:59 GMT

Sorry but it's not what I want

See new attached file

If I choose 01/04/2009 i want this

________________

| | 01/04/2009 | April 2009 |

| | 16 | 30 |

You see the difference ? I want the sum of the month of the date choose in a other column

Sorry for my bad english 😉

Have day and month in same table

Thu, 07 May 2009 18:33:20 GMT

Hi,

Check the attachment. i believe that should help you.

Regards

Sridhar

Have day and month in same table

Thu, 07 May 2009 19:32:24 GMT

It's not exatly what I want but I'm going to do with... 😉

Tks

Have day and month in same table

Thu, 07 May 2009 19:46:39 GMT

ho.... was my understanding is wrong....?[:'(]

ok.. no probs.. can u explain me the scenario elaborately so tat i can break my head further...?

- Sridhar

Have day and month in same table

Thu, 07 May 2009 22:00:14 GMT

I'm going to explain my case and what I want

I have a first table INVOICE with each invoice (1 invoice = 1 record). In this record I have 4 fields (invoice n°/date/state/turnover/gross margin)

I have a second table CALENDAR with each day (1 day = 1 record) from 1/1/2006 to 1/1/2010 with a lot of fields like name of day, name of month

In a same grid I want see the sum of turnover and gross margin for one day and the sum of turnover and gross margin for the month of this day....

you understand ?

Have day and month in same table

Oleg_Troyansky — Thu, 07 May 2009 23:25:10 GMT

I think you can do it with 1 Dimension (Day) and 5 Expressions:

- Daily sum(Turnover)

- Daily sum(Margin)

- Month(Day) as an expression

- sum(Turnover) with the Set Analysis modified that will limit the data to the Month(Day)

- sum(Margin) with the Set Analysis modified that will limit the data to the Month(Day)

You might have to define an "island" Date field to enable this logic to work...

Oleg

Have day and month in same table

Tue, 19 May 2009 15:56:05 GMT

OK tks for your help 😉