I stuck one place, I did data model but my output is not coming, I Want SRD wise SPD --> Delear Price.. Please let me help on the same. Find the qvd and QVW for the same.
looking at what you've provided, it seems that SRD and SPD has no link with one another, what exactly are you trying to achieve? what you do mean by "SRD wise SPD" ? what does "wise" mean?
what i suggest you do is try creatng a "pivot table" using the chart function, select "seller_HQFlag" and "SellerCode" as the dimension and "sum(DealerPrice)" as the expression. would this be something you are looking for?
ignore all your other load fields for now, just use the fields from your DB. and understand how your data is structured.
Sir, I heard there is nothing impossible in QlikView. We can make a composite key for linking, If possible please do it. Otherwise I will do from my side. Thnaks for analysis.
