Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 

Need to show dublicate count in pivot table

I need to show the dublicate count in the pivot table. please see the below screen shot.

Base Table
Orgcust_nameNumberCondition
10Cust11234Fixed
10Cust11234Discount
10Cust10000.49Fixed
10Cust100000Discount
10Cust101-4050Discount
10Cust10158Discount
10Cust1017Discount
10Cust10170BDiscount
10Cust10182Fixed
10Cust10182Discount
10Cust10189ADiscount
10Cust102186.0250Fixed
10Cust1-02267Fixed
10Cust1026002Discount
10Cust102739.0250Fixed
10Cust1-0281Discount
10Cust1-0283Discount
10Cust1-0284Discount
10Cust103Discount
10Cust103Fixed

Out put should be like the below. if the Number is dublicate, i need to show the total count in Discount and Fixed.

Count
Orgcust_nameNumberDiscountFixed
10Cust10322
10Cust1123422
10Cust10000.491
10Cust1000001
10Cust101-40501
10Cust101581
10Cust10171
10Cust10170B1
10Cust1018222
10Cust10189A1
10Cust102186.02501
10Cust1-022671
10Cust10260021
10Cust102739.02501
10Cust1-02811
10Cust1-02831
10Cust1-02841

Thank you.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
MVP & Luminary
MVP & Luminary

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post