topic Re: Please help me in getting variance in QlikView

Please help me in getting variance

shiveshsingh — Wed, 25 Nov 2020 16:16:04 GMT

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%

Re: Please help me in getting variance

qlikviewwizard — Sat, 01 Sep 2018 05:25:44 GMT

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);

Re: Please help me in getting variance

qlikviewwizard — Sat, 01 Sep 2018 05:26:38 GMT

Expressions:

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

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