Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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