Mapping accounts from different sources

Wed, 27 May 2009 07:29:27 GMT

Hello,

have created a P&L report in qlikview and now there will be incoming data from another company. I use intervalmatch and an excel template to group the verifications.

Example:

I have an account number 6000 that belongs to Marketing from Company A and Sales in Company B.

In the next step I do an intervalmatch that puts everything under 6000 under Marketing.

I have two different sources of excel files which I first concatenate. When, or before I do the concatenation I need to remap all 6000 accounts from Company B to a Sales account first so that when I do the final intervalmatch against the excel template the verifications will be grouped correctly.

Have tried some If( and also mapping loads but it doesn't really come out as expected.

Any help is useful.

Thx!

Mapping accounts from different sources

rwunderlich — Thu, 28 May 2009 11:49:47 GMT

Have you tried Extended IntervalMatch? That would allow you to qualify the match using Company also.

-Rob

topic Mapping accounts from different sources in QlikView

Mapping accounts from different sources

Mapping accounts from different sources