topic Re: Chart expression similar to SQL Subquery/ Excel Vlookup in QlikView

Chart expression similar to SQL Subquery/ Excel Vlookup

Anonymous — Wed, 25 Jan 2017 16:30:09 GMT

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.

Thanks

Robert

Re: Chart expression similar to SQL Subquery/ Excel Vlookup

Gysbert_Wassenaar — Wed, 25 Jan 2017 18:38:05 GMT

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.

Re: Chart expression similar to SQL Subquery/ Excel Vlookup

Anonymous — Fri, 10 Feb 2017 15:29:43 GMT

Thanks gwassenaar,

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.

Robert