topic Re: How to add custom Year column in data in QlikView

How to add custom Year column in data

vikas_nandanwar — Mon, 25 Dec 2017 06:16:35 GMT

Hi,

I have transaction date as one of the column

I get auto calendar in my measure field.

I have another sheet with same date but the year should be displayed as Planned year

Sales Transaction date =

2016

2017

Plan Transaction year =

2017

I want Plan Transaction year = 2017P

How to get that?

Thanks,

Vikas

Anil_Babu_Samineni — Mon, 25 Dec 2017 07:30:31 GMT

Not really sure?

[Plan Transaction Year] & 'P' as [Plan Transaction Year]

Load [Sales Transaction Year], 'Sales' as Flag From Sales;

Load [Plan Transaction Year] & 'P as [Plan Transaction Year], 'Plans' as Flag From Sales;

pipuindia99 — Tue, 26 Dec 2017 16:19:59 GMT

Hi,

Like this

Sales Transaction date = 2016, 2017

max([Sales Transaction date])&'P' as [Plan Transaction Year]

Plan Transaction year = 2017