topic Re: Pivot table Max date in QlikView

Pivot table Max date

nvijay5757 — Sun, 07 Aug 2022 15:18:16 GMT

Hi ,

in pivot table how to take max date

ex:

in original ppap column as end_date. in this some rows are showing two to three dates how to take max date. if i apply MAX(date) not working.

LOAD Distinct site_code,
Concat(DISTINCT part_description,', ') as Part_descriprion_new,
date(Max(end_date), 'YYYY-MM-DD') as end_date, 1 as date_flag
Resident Input Group By site_code;

i have written in script but all is grouping then it is showing only one site code. help me thanks.

Re: Pivot table Max date

BrunPierre — Sun, 07 Aug 2022 21:33:12 GMT

Maybe like this

TEMP:
LOAD Distinct site_code,
Part_descriprion_new,
end_date,
1 as date_flag
Resident Input;

FINAL:
LOAD site_code,
date_flag,
Concat(DISTINCT part_description,', ') as Part_descriprion_new,
Max(Date(end_date),'YYYY-MM-DD') as end_date
Resident TEMP
Group By site_code,date_flag;

DROP Table Input;

Re: Pivot table Max date

nvijay5757 — Mon, 08 Aug 2022 05:28:11 GMT

Hi thanks for your reply,

above load i have used Left Join( Input).

so if take resident then remaining cols missing.

Re: Pivot table Max date

BrunPierre — Mon, 08 Aug 2022 07:33:22 GMT

@nvijay5757 Sorry, I didn't quite catch what you said.

Re: Pivot table Max date

BrunPierre — Thu, 25 Aug 2022 14:08:52 GMT

@nvijay5757 Is your question answered?