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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Apply set analysis in pivot table

Hello Guys ! I need some help!

I'm using a pivot table with 2 dimensions : MonthYear and id_code.

In expression, i have :

Count( DISTINCT Aggr (   if((( SUM(x) + SUM(y)) = 0), code1), code1, MonthYear))

I want to select 1 month in pivot table and show the month selected + 2 previous month. If select in pivot table october, show september and august.

How to do it?

Thanks !

Morandi

0 Replies