New to QlikView

[dunnalahk123]

Hi,

i have 4 Fields out of that 2 field are Like Sales Product name and sales ID and 2 cal fields of numerator and Denominator.

So i want to write set analysis for Distinct  Sales Product name and Distinct sales ID of Sum of Numerator.

Note:Sales Product name & sales ID are not Unique fields.

Can some help me here how to write that.

Best Regards,

HK

[ramasaisaksoft]

Hi hari,

it is better if you share some sample data ,then our folks will understand easily as well as you will get solution ASAP.

[vinieme12]

How to get answers to your post?

Preparing examples for Upload - Reduction and Data Scrambling

[dunnalahk123]

Hi Sai,

i have attached app.

Thank You.

[vinieme12]

thanks for the app but you haven't specified expected output table??

can you make something in excel and post a snapshot of the expected output table?