topic Re: Identify store v2 in QlikView

Identify store v2

Sun, 16 Mar 2014 16:16:40 GMT

Hi all,

How can I obtain a straight table with the number of duplicated stores ?

Thank for your help.

Judikael.

swuehl — Sun, 16 Mar 2014 16:24:57 GMT

Duplicated in what context? Or how do you get e.g. the number 7 for store A01?

Sun, 16 Mar 2014 16:31:29 GMT

When I select store A00, I see nov, oct, sept, aout, juil and juin so 6 for A00.

I want to obtain the list of duplicated store by year or by month if there are duplicated by month in the straight table .

MK_QSL — Sun, 16 Mar 2014 16:37:34 GMT

Try Straight table..

Dimension = Store

Expression = COUNT(Distinct Month)

COUNT(DISTINCT {<NbrStore = {'>0'}>} Month)

Hope this helps..

Sun, 16 Mar 2014 18:48:13 GMT

Hi Manish,

It works well.

Thanks.