Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

Stock Store and Stock DC

hic‌,

Could you please help me in this issue?

I have a Table with Stock Store and Stock Distribution Center.

Each distribution center supplies a group of stores.

When I put in a pivot table the sum(StockStore) seems ok, but the sum(StockDC) comes with duplicate values.

Is there any way there I can have only 1 value of this field.

Key is:

CODCD (ehich is the DC)

STORELOCATION (which is the store),

SKU(which is the product)

Date (date of position of the stock)

1 Reply
Champion III
Champion III

Did you try like

= Sum(DISTINCT StockDC)