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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
solverproblems
Contributor
Contributor

Hide Column using before or after function on Pivot Table

I'm in a pivot table showing periods from some month,

Like this:

                            2019-01 | 2019-02 | 2019-03

Column1             1                  2                3

Column2             2                  3                 1

 

If I use before function to show the sum 2+3 from Column2 using before(), then sum 1+2 from Column1 using after(), It will result 8.

I want to get this same result in a 2019-02 row but hiding 2019-01 column. It is posible??

If I hide it desappear 

 

Labels (3)
2 Replies
ingridhusby17
Partner - Contributor II
Partner - Contributor II

Did you solve this @solverproblems ?
I have the same question.

brunos
Contributor
Contributor

Utilizzando il menu

Add-ons

Data handling:

  • Include zero values