Create Dimensions

[Anonymous]

Hi,

I want to create a dimension for all charts in my QlikSense App, which should include the following:

Year 2016, Year 2017 YTD, each moth of Year 2017.

Is that possible?

Many thanks in advance.

[its_anandrjs]

For Year 2016

=sum({<[Year Field] = {$(=max([Year Field])-1) } >} SalesValue)

For Year 2017 YTD

=sum({<[Year Field] = {$(=max([Year Field])), NumMonth={">=$(=Max(NumMonth)) <=$(=Max(NumMonth))"}  }>} SalesValue)