Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
settu_periasamy
Master III
Master III

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
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

See attached qvw.


talk is cheap, supply exceeds demand