Discussion board where members can get started with QlikView.
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.
it is better if you share some sample data ,then our folks will understand easily as well as you will get solution ASAP.
How to get answers to your post?
Preparing examples for Upload - Reduction and Data Scrambling
i have attached app.
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?