Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
fgirardin
Creator
Creator

Get the Total Qty bought per item

Hello !

I created a sales report that contains data from our ERP

It shows customer, item purchased, price, qty, ...

My table looks like this:

DATE     CUSTOMER     INVOICE N°     ITEM     QTY     UNIT PRICE     TOTAL

1               A                                               iA           5                 1                    5

2               B                                               iA           2                1                     2

3               A                                                iB          4                10                    40

4               B                                               iA          10               1                    10

I can select a specific customer, a specific date or a specific item and I get the sales for a specific date

I'd like to be able, when selecting a customer, to have the total qty bought for each item

So it would look like something like this:

CUSTOMER     ITEM     TOTAL QTY

A                         iA               5

A                         iB               4

B                         iA               12

Any help is appreciated.
Let me know if my question don't make sense !

Thank you

1 Solution

Accepted Solutions
Anil_Babu_Samineni

you don't need any thing here

Create straight table

Dim - CUSTOMER, ITEM

Measure - Sum(QTY)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

2 Replies
Anil_Babu_Samineni

you don't need any thing here

Create straight table

Dim - CUSTOMER, ITEM

Measure - Sum(QTY)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
devarasu07
Master II
Master II

Hi,

like this? if  not what is the logic to derive Total Qty?

=sum(QTY)/(UNIT_PRICE)