Grouping Data

Tue, 06 Aug 2013 21:19:19 GMT

Hi ,

I need to implement the below scenario in qlikview. Can anyone please help ?

from the first table, I need to group the records based on client count column.

then if the sourcesystem='Bermuda' then the programtype and markedcode values should overide based on the Sourcessystem=US records

There should not be any change to the US sourcesystem records .

I have given the before and after sample data below .

Can anyone please help me in this ?

Thanks

Re: Grouping Data

Gysbert_Wassenaar — Wed, 07 Aug 2013 11:42:48 GMT

Try something like below. The inline load is just an example. You can replace it with a from ...somewhere.... to load the date from a file or database.

Before:

LOAD *, RowNo() as rowid INLINE [

sourcesystem, client count, marketed, program_type, premium

US, A, N, LS, 100

US, B, N, GC, 200

Bermuda, A, Y, NA, 100

US, B, N, GC, 200

Bermuda, B, Y, NA, 100

];

After:

load rowid, sourcesystem, [client count], premium

Resident Before;

join

load distinct [client count], marketed, program_type

resident Before where sourcesystem = 'US';

drop table Before;

topic Re: Grouping Data in QlikView

Grouping Data

Re: Grouping Data