Qlick comparison

[fernfrancis]

Hi Team,

I am new to Qlick sense, need you help to understand how i can do a comparison of data. for example i need to compare data of jan 2021 with the data of jan 2022 . To see the variance if i have done good or bad for that month compared to the same month the previous year.

[OmarBenSalem]

Here's a simple way to do it:

Do you have a Year and a month fields? if yes:

- Create a simple table

- as a dimension : Month

- as measures:

1) sum({<Year={"$(=max(Year))"}>}YourMeasure) : for 2022

2) sum({<Year={"$(=max(Year)-1)"}>}YourMeasure) : for 2021

3) (column(1)-Column(2))/column(2) : for variance

for more period over period analysis, please refer to:

https://community.qlik.com/t5/New-to-Qlik-Sense/YTD-MTD-issue/td-p/1278297