topic Re: Identify store in QlikView

Identify store

Fri, 14 Mar 2014 23:02:56 GMT

Hi all,

How can identify if store are repeat in the current period for example : ST1,ST5.

And how can I count them ?

Thanks for your help.

Judikael,

Re: Identify store

Anonymous — Fri, 14 Mar 2014 23:09:01 GMT

Hi, what do you want to do when you've identified those? You just want to count the duplicated ones in the table?

Re: Identify store

Fri, 14 Mar 2014 23:26:02 GMT

Hi Oscar,

Yes. count duplicated ones in the table and which store are duplicated.

Re: Identify store

MK_QSL — Fri, 14 Mar 2014 23:30:19 GMT

Temp:

LOAD * INLINE [

Year, Month, Store, NBR

2014, janv, ST1, 20

2014, fevr, ST2, 18

2014, mars, ST1, 16

2014, avr, ST4, 10

2014, mai, ST5, 25

2014, juin, ST3, 10

2014, juil, ST7, 20

2014, aout, ST5, 16

2014, sept, ST9, 1

2014, oct, ST10, 9

2014, nov, ST11, 1

2014, dec, ST12, 1

];

FINAL:

Load

IF(Store = Previous(Store), 1, 0) as Flag

Resident Temp

Order By Store;

Drop Table Temp;

Now Create a Text Box with Expression = SUM(Flag) or SUM({<Flag = {1}>}Flag)

UPDATE : To get the distinct Duplicated Store.. use below in Text Box..

=COUNT({<Flag = {1}>}DISTINCT Store)

To find the Store Name...

=Concat({<Flag = {1}>}DISTINCT Store, ', ')

Re: Identify store

Anonymous — Fri, 14 Mar 2014 23:30:49 GMT

Please see if the attached is what you are looking for.

I've added a calculated dimension using aggr function. Let me know if you ahve any question.

Kind regards,

Re: Identify store

Sat, 15 Mar 2014 00:17:48 GMT

Thanks OM!!

Exactly what I mean.

Many thanks again.