Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor III
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 


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.


Thanks in advance.



Labels (3)
0 Replies