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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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