Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: Need to show dublicate count in pivot table

See attached qvw.


talk is cheap, supply exceeds demand
1 Reply

Re: Need to show dublicate count in pivot table

See attached qvw.


talk is cheap, supply exceeds demand
Community Browser