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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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).