Chart expression similar to SQL Subquery/ Excel Vlookup
Hi,
I'm currently developing a report aiming to show what insurance policies were up for renewal that had been placed with our non-preferred insurers in a given period and if any of the clients had moved to preferred insurers in a the same period and which insurers they went to.
The first part (Renewal) is fine I just sum the premium where the renewal date is between two selected dates but the second I'd like to be almost like a sub-query in SQL as it would be the sum of premium transacted in the same period by client and a concatenation of insurers with the premium transacted.
I've tried to best illustrate the existing report, expression & requirements in the attached Excel book.
It looks like you want to do something like concat({<Insurer={“=sum(GWP)=0”}>}distinct total <Branch> Insurer,’, ’,Insurer). But I can't really tell from the excel file. Perhaps you can post a small qlikview document that illustrates the problem.
I've started looking at using Total to see if I can pull through what I want; I'll either get it working in which case i'll mark as answered otherwise load up a small qvw to assist with understanding the proble.
