topic Data x Indice in Brasil

Data x Indice

paulomulato — Fri, 27 May 2016 02:34:14 GMT

Senhores, voces poderiam me ajudar no seguinte problema, tenho uma tabela fato com a data de faturamento, gostaria de incluir uma coluna auxiliar em que para data eu adicionasse um indice, esse indice começaria sempre com 1 para meses diferentes. exemplo abaixo.

Dt Nota	Indice
02/05/2016	1
03/05/2016	2
04/05/2016	3
05/05/2016	4
06/05/2016	5
07/05/2016	6
09/05/2016	7
10/05/2016	8
11/05/2016	9
12/05/2016	10

Re: Data x Indice

Anonymous — Fri, 27 May 2016 03:12:27 GMT

Hi PauloRoge,

Maybe you could use the Peek function. Please check the attached qvw.

Regards,

-- Karla

Re: Data x Indice

sunny_talwar — Fri, 27 May 2016 09:34:17 GMT

Not sure what you want, but try one of these:

Table:

LOAD Month(Date) as Month,

Date,

AutoNumber(Month(Date)) as Indice,

AutoNumber(RowNo(), Month(Date)) as Indice1;

LOAD Date(MakeDate(2013, 12, 31) + RecNo()) as Date

AutoGenerate Today() - MakeDate(2013, 12, 31) + RecNo();

Re: Data x Indice

paulomulato — Fri, 27 May 2016 16:49:41 GMT

Thank sunny , it worked.

Re: Data x Indice

paulomulato — Sat, 28 May 2016 20:46:04 GMT

Hi Sunny, I have a doubt, as I do with a table that I have repeated lines for the same date and with different years?

Re: Data x Indice

sunny_talwar — Sat, 28 May 2016 21:04:55 GMT

You can try this with MonthName function, instead of Month function

Table:

LOAD Month(Date) as Month,

Date,

AutoNumber(MonthName(Date)) as Indice,

AutoNumber(RowNo(), MonthName(Date)) as Indice1;

LOAD Date(MakeDate(2013, 12, 31) + RecNo()) as Date

AutoGenerate Today() - MakeDate(2013, 12, 31) + RecNo();

Re: Data x Indice

paulomulato — Sat, 28 May 2016 21:15:03 GMT

It did not work , as it puts the image AutoNumber per month and not per day.

Re: Data x Indice

paulomulato — Sat, 28 May 2016 21:16:19 GMT

follow script:

NBase_Indice:

LOAD

[Dt Nota],

count([Dt Nota]) as total_data,

AutoNumber(MonthName([Dt Nota])) as Indice_Data

FROM

(qvd) Group by [Dt Nota];

Re: Data x Indice

sunny_talwar — Sat, 28 May 2016 21:17:35 GMT

Check the attached

Re: Data x Indice

sunny_talwar — Sat, 28 May 2016 21:18:57 GMT

May be this:

NBase_Indice:

LOAD [Dt Nota],

Count([Dt Nota]) as total_data,

AutoNumber(RowNo(), MonthName([Dt Nota])) as Indice_Data

FROM (qvd)
Group by [Dt Nota];

Re: Data x Indice

paulomulato — Sat, 28 May 2016 21:26:32 GMT

amazing, thanks one more time...

Re: Data x Indice

sunny_talwar — Sat, 28 May 2016 21:28:48 GMT

Not a problem. I am glad I was able to help. I would request you to close this thread by marking correct and helpful answers

Qlik Community Tip: Marking Replies as Correct or Helpful

Re: Data x Indice

paulomulato — Sat, 28 May 2016 21:30:19 GMT

Re: Data x Indice

Clever_Anjos — Mon, 22 Aug 2016 21:25:20 GMT

Olá, já resolveu? Se alguma resposta te ajudou, marque como "Correta" para fechar o tópico.

Como obter ajuda? Leia antes de postar