topic Re: Question about Loop & Reduce in QlikView

Question about Loop & Reduce

hobanwashburne — Tue, 27 Oct 2015 15:25:53 GMT

How do I distribute the same reduced document to multiple people?

For instance: In the following both Steve and Joe are to receive the document for Industry B

I created the following table in the script

Industry, UserName

A, Bob

B, Steve

B, Joe

C, Nick

D, Ed

If I loop and reduce on Industry and make the document name Dashboard %Industry% won't the document Dashboard B that is distributed to Steve be overwritten by Dashboard B that is distributed to Joe?

Re: Question about Loop & Reduce

Tue, 27 Oct 2015 15:35:10 GMT

Create concatenated field in the data model & use the new field on Loop & Reduce

Script: Industry&'_'&UserName AS LoopReduceField

QEMC: Dashboard %LoopReduceField%

Re: Question about Loop & Reduce

Tue, 27 Oct 2015 15:38:13 GMT

Yes, It will over write dashboards.

If possible create a composite key based on Industry ID & User ID & Make sure it is unique. so that you won't run into any dashboard over write issues.

Thanks

Brad.