Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
cvalarcon
New Contributor III

Qlikview - Variation in pivot table

Hi experts,  I have this pivot table created from one excel file.  I have 3 levels in this Pivot table 

  1. Product
  2. House
  3. Seler 

1.jpg

The Proporcion field is working fine with this formula in the Expresions:

=if(Period=$(vPeriodo1)and Dimensionality()=1,count(Product)/count(total<Period,>(Product)),
if(Period=$(vPeriodo1)and Dimensionality()=2,count(Product)/count(total<Period,>(Product)),
if(Period=$(vPeriodo1)and Dimensionality()=3,count(Product)/count(total<Period,>(Product)))))

So I like to know wich is the best way to have an additional column with the quantity variation between the last period (in this case 201903) and the Last period -1 (201902)  (orange column).  

And the reletion should be available in all Dimensions.

2.jpg

Thanks in advance.