Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Identify store v2

Hi all,

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

Thank for your help.

Judikael.


1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Try Straight table..

Dimension = Store

Expression = COUNT(Distinct Month)

or

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

Hope this helps..

View solution in original post

4 Replies
swuehl
MVP
MVP

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

Not applicable

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
MVP
MVP

Try Straight table..

Dimension = Store

Expression = COUNT(Distinct Month)

or

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

Hope this helps..

View solution in original post

Not applicable

Hi Manish,

It works well.

Thanks.