topic Re: Label in Pivot table in QlikView

Label in Pivot table

upaliwije — Sat, 08 Feb 2020 16:44:03 GMT

Hi Friends

I have shown here a screenshot of my pivot table where date in label of last column is incorrectly shown as 31-Feb-2020 and it should actually be 28-feb 2020.

My expression for label is ='Balance as at '&Day(MonthEnd(Date#(PERIODID,'D')))&'-'&Date(Date#(PERIOD,'YYYYMM'),'MMM-YYYY')

Kindly help me to get it corrected.

Re: Label in Pivot table

sergio0592 — Sat, 08 Feb 2020 20:26:48 GMT

Hi,

Try with

Date(monthend(Date#('01'&PERIOD,'DDYYYYMM')),'DD-MMM-YYYY')

Re: Label in Pivot table

upaliwije — Mon, 10 Feb 2020 06:18:38 GMT

Thanks It works,

But I want to what does it mean by

'01'

in your expression. Pls clarify for me to learn

Re: Label in Pivot table

sergio0592 — Mon, 10 Feb 2020 10:21:35 GMT

It's just for represent in the date the first day of month. It's the DD in DDYYYYMM.

Re: Label in Pivot table

upaliwije — Mon, 10 Feb 2020 11:00:36 GMT

Thanks