Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

dunnalahk123
Contributor II

Help in Set Analysis

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

4 Replies
ramasaisaksoft
Valued Contributor III

Re: Help in Set Analysis

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
Esteemed Contributor II

Re: Help in Set Analysis

dunnalahk123
Contributor II

Re: Help in Set Analysis

Hi Sai,

i have attached app.

Thank You.

vinieme12
Esteemed Contributor II

Re: Help in Set Analysis

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?