topic Re: group MonthNames in QlikView

group MonthNames

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

PLease get names based on the month hired

Example

Name	Hiring Date	Jul	Jun	May
SGJM	29.07.2016	Yes	NO	NO
YZSH	29.07.2016	Yes	NO	NO
SLGP	02.06.2016	NO	Yes	NO
ABCM	01.06.2016	NO	Yes	NO
ADMH	01.06.2016	NO	Yes	NO
SDLY	23.05.2016	NO	NO	Yes

Re: group MonthNames

sunny_talwar — Tue, 09 Aug 2016 11:19:51 GMT

Not sure I understand

Why not create Month([Hiring Date]) as [Hiring Month]

Re: group MonthNames

its_anandrjs — Tue, 09 Aug 2016 11:24:24 GMT

Can you please explain bit more what is your requirement why you have separate month fields.

Regards,

Anand

Re: group MonthNames

its_anandrjs — Tue, 09 Aug 2016 11:37:55 GMT

You can try this way also for getting only hired data

tmpData:
CrossTable(Month, Data, 2)
LOAD * INLINE [
Name, Hiring Date, Jul, Jun, May
SGJM, 29.07.2016, Yes, NO, NO
YZSH, 29.07.2016, Yes, NO, NO
SLGP, 02.06.2016, NO, Yes, NO
ABCM, 01.06.2016, NO, Yes, NO
ADMH, 01.06.2016, NO, Yes, NO
SDLY, 23.05.2016, NO, NO, Yes
];

NoConcatenate
New:
LOAD Name,
[Hiring Date],
Month,
Data
Resident tmpData
Where Data = 'Yes';

DROP Table tmpData;

Regards,

Anand