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: 
Clotildeh
Contributor
Contributor

Total

Hello! 

I have worked long time with Qlikview but totally Newbie with a QlikSense.  I have existing report which I inherited and it needs a new column (see the example picture). We have a new customer spending divided by month in first 12 months period.  I get the monthly totals with sum(if(customer_age_months=12)) etc. But I am asked now to get totals for all the customers FIRST months spending when they become customers, which I have hi-lighted on yellow. Any ideas how to get this total?

Screenshot 2021-05-06 at 15.57.36.png

1 Reply
JordyWegman
Partner - Master
Partner - Master

Hi,

Could you  maybe show where you would like to have this data? In a graph just like you show? There are multiple possibilities for this!

Jordy

Climber

Work smarter, not harder