topic Re: Concatenate list of Customers below 28 days in QlikView

Concatenate list of Customers below 28 days

rustyfishbones — Thu, 14 Aug 2014 09:17:43 GMT

Hi All,

I have a list of Customers and I have an alert set up to email me when a Customer is below 28 Days, working fine.

In the Subject of the Email I then want to add the 5 Customer Names that meet the same Criteria as a Concatenated string separated by a ;

How can I achieve this

Re: Concatenate list of Customers below 28 days

tresB — Thu, 14 Aug 2014 09:20:11 GMT

Have you tried like:

=Concat( Distinct If(....), ';') ?

Re: Concatenate list of Customers below 28 days

Thu, 14 Aug 2014 09:22:56 GMT

How are you sending email? Through Qlikview Server or Macro in your Dashboard? If you are sending through your dashboard you could use Concat() function as mentioned above by tresesco.

Re: Concatenate list of Customers below 28 days

rustyfishbones — Thu, 14 Aug 2014 09:33:33 GMT

I have the following expression that sends the email when it return 1

=IF(MIN(AGGR(MIN([License Expiry Date]-TODAY()),[Customer 1])) <= 28,1,0)

then in the email i tried what you suggested with concat distinct but I could not get it working

I have 5 Customers that are less than the 28 days so I would like to show these names in the email subject

Regards

Re: Concatenate list of Customers below 28 days

Thu, 14 Aug 2014 09:42:37 GMT

Assuming you are using the Alert in the Tool menu for sending the mail, there is something called as mail subject. Using the Concat() function there should help you list the customer names.

Else have a variable which uses the Concat() function to get the list of customer names and use this variable in the mail subject.

If you can send the qvw we can try it out and send you back.

Regards,

Pramod K

Re: Concatenate list of Customers below 28 days

tresB — Thu, 14 Aug 2014 09:42:52 GMT

Try:

=Concat(AGGR(If(MIN([License Expiry Date]-TODAY())<= 28 ,[Customer 1]),[Customer 1]), ';')

Re: Concatenate list of Customers below 28 days

rustyfishbones — Thu, 14 Aug 2014 09:43:29 GMT

through Alerts, no macro, no server

Re: Concatenate list of Customers below 28 days

Thu, 14 Aug 2014 09:46:15 GMT

Reply from tresesco should work.

Re: Concatenate list of Customers below 28 days

rustyfishbones — Thu, 14 Aug 2014 11:40:35 GMT

Thanks guys works perfect