Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've seen a similar post, but it wasn't fully answered.
I have a number of customers that belong to different Market Segments and different Sales Offices,
I want to make selections like Year, Market Segment and Sales Office and Group1. I want two tables, a list of customers that belong to the selections made with their sales (easy, standard Qlikview table in my sample file), then I want a table that shows a list of customers that belong to all the selections made EXCEPT Group1.
Using my example, if you select Commercial Printer and Sales Office 30, you see 4 customers exist. If you then select Vinyl or Banner from Group 1, you only see 3 customers, I want a table that lists the 4th customer.
My real QVW will also have selection items not included in this sample like Year, Month, Sales Rep, so I don't want to specify what the selections should include, however I can specify that Group1 is the exception.
hope you can help!
thanks,
Sue
Try a table chart with dimension Customer Code and expression:
=sum({<[Customer Code] = e(),Group1= >}[Sales])
Is this what you want?
Try a table chart with dimension Customer Code and expression:
=sum({<[Customer Code] = e(),Group1= >}[Sales])
Is this what you want?
Perfect, that's exactly what we are looking for!
Thank you!