Please help me in getting variance

[shiveshsingh]

Hi

I have attached sample data

please help with expression

Etiquetas de columna
Valores	2017/02	2018/02	YoY
Suma de Sales	8238	16279	97.6%
Suma de Income	565	1015	79.6%
Suma de expenses	451	1003	122.4%

[qlikviewwizard]

Hi,

You can achieve like this.

Data:
CrossTable(Dimension, Data, 2)
LOAD Date#(date,'YYYY/MM') as Date,
    product,
    Sales,
    Income,
    expenses
FROM

(ooxml, embedded labels, table is Hoja1);

[qlikviewwizard · Accepted solution]

Expressions:

sum({<Date={"$(=date(addmonths(date(max(Date),'YYYY/MM'),-12),'YYYY/MM'))"}>}Data)

Sum( {$<Date={"$(=Date(Max(Date),'YYYY/MM'))"}>} Data )