Data modelling

[sureshmaddipati]

Hi 

How to pull next year values and show in current year column in qliksense i.e

For example: 2024 year values need to show in 2023 year column

[MatheusC]

Hi, @sureshmaddipati 

See with the function above:

https://help.qlik.com/pt-BR/sense/February2024/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Inter....

I'll leave an example below, adapt it according to your fields and expression:

If(FieldYear= Year(Today(1)),above(sum([Value]),1), sum([Value]))

Regarts, Matheus