topic Re: Agrupar Valores Repetidos in QlikView

Agrupar Valores Repetidos

Anonymous — Wed, 23 Nov 2016 19:54:07 GMT

Hi, there is how do that?

If(substringcount('001|002|003|004|005|006',STORE)>0,'Group1',If(substringcount('001|002|003',STORE)>0,'Group2',If(substringcount('004|005|006',STORE)>0,'Group3')))

Just Group1 appears -off course-, because first condition...Have any way to do for 001 belong Group1 and Group2 at the same time?

Thank you!!

Attached have a sample what i want...i want that sales of store1 com belong a group1 and group2.

Re: Agrupar Valores Repetidos

MarcoWedel — Wed, 23 Nov 2016 23:28:29 GMT

please post some sample data and your expected result.

thanks

regards

Marco

Re: Agrupar Valores Repetidos

Anonymous — Thu, 24 Nov 2016 11:25:40 GMT

I thought about what i asked, and now i conclude that is impossible, in script, i think.

But in pivot table, editing the expression, will be possible?

Re: Agrupar Valores Repetidos

MarcoWedel — Fri, 25 Nov 2016 00:03:42 GMT

Hi,

maybe one script solution could be:

SAMPLE:

load * inline

[PRODUCT,STORE,SALES

BEER,001, 10,7

MEAT,001, 30,5

BREAD,001, 50

BEER,002, 23,10

MEAT,002, 3,5

BREAD,002, 90

BEER,003, 40,8

MEAT,003, 35,5

BREAD,003, 30

BEER,004, 5,1

MEAT,004, 12,5

BREAD,004, 20

,];

tabStoreGroups:

LOAD * Inline [

STORE, GROUPS

001, GROUP1

002, GROUP1

003, GROUP1

001, GROUP2

003, GROUP2

002, GROUP3

];

hope this helps

regards

Marco

Re: Agrupar Valores Repetidos

Anonymous — Fri, 25 Nov 2016 10:26:33 GMT

Yes...thank you...

It was a good solution...
Thank you Marcos!

Re: Agrupar Valores Repetidos

MarcoWedel — Fri, 25 Nov 2016 22:28:30 GMT

you're welcome

glad it helped

regards

Marco