Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Stefano2
Contributor
Contributor

Visualisation tab

Hi all,

i've created in VISUALIZATION the tab 1 where columns c) and d) are obtained with formulas. Now, i would create the table 2 but when i create it by converting the table one into a pivot or by creating a new table with a dimension a) and measure d)  the result assigned to A,B, C is always zero. I don't understand why.

It could be grateful if you could help me. thanks a lot

1) a) b) c) d)
  Category Month Values tot for category
  A Jan 0 2
  A Feb 2 2
  A March 0 2
  B Jan 1 7
  B Feb 1 7
  B March 5 7
  C Jan 0 5
  C Feb 0 5
  C March 5 5
         
2) Category Values    
  A 2    
  B 7    
  C 5    

 

1 Solution

Accepted Solutions
Mario_ES
Contributor III
Contributor III

It's because in a pivot table the dimensions contract. If you want to see it the same way you do with table 1, you have to expand it clicking the +. At the end of the day c) is a count and d) a sum of c). 

View solution in original post

1 Reply
Mario_ES
Contributor III
Contributor III

It's because in a pivot table the dimensions contract. If you want to see it the same way you do with table 1, you have to expand it clicking the +. At the end of the day c) is a count and d) a sum of c).