Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
rassanbekov
Partner
Partner

Supplier provided service once

Hello all! Please help to construct a straight table with dimensions of supplier and service and expression of sum of purchases for those suppliers who provided service only once.  The table has been attached.

Labels (2)
1 Reply
rahulpawarb
Specialist III
Specialist III

May be this:

SCRIPT:

SupplierService:
LOAD Supplier,
Service,
[sum(Сумма)]
FROM
[C:\Users\u953550\Downloads\Supplier Service.xlsx]
(ooxml, embedded labels, table is Sheet1);

SupplierServicedOnce:
LOAD *
WHERE Flag = 1;
LOAD Supplier,
COUNT(Service) AS Flag
Resident SupplierService
Group By Supplier;

 

CHART:

//Dimension

Supplier

//Expression

Count({<Flag={1}>}Service)