Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Zurich on Sept 24th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
cvalarcon
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 

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.

 

 

Labels (1)
0 Replies