topic Re: Need Script Help. in QlikView

Need Script Help.

sona_sa — Sun, 24 May 2015 12:08:53 GMT

Hi,

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.

Thanks.

Re: Need Script Help.

petter — Sun, 24 May 2015 12:23:42 GMT

What is SRD and SPD?

Re: Need Script Help.

sona_sa — Sun, 24 May 2015 12:32:58 GMT

Sir, SRD is SRD Code and channel distributor . and SPD is SPD code who is the reporter person for SRD. SRD is repoting to each SPD. One SRD has one SPD but One SPD has multiple SRD..

Thnaks for ask, I have not mentioned this.

Re: Need Script Help.

sona_sa — Sun, 24 May 2015 15:03:52 GMT

I hope u got my point.

Re: Need Script Help.

sona_sa — Mon, 25 May 2015 04:06:56 GMT

Do u have any doubts please let me know, So I can explain more, SPD is first level and SRD is second level.

Re: Need Script Help.

sona_sa — Mon, 25 May 2015 07:42:29 GMT

Hi petter, plz help me on this.

Re: Need Script Help.

petter — Mon, 25 May 2015 08:29:13 GMT

Could you explain a little bit better what you mean by:

Want SRD wise SPD --> Delear Price

What kind of calculation do you want to do?

Re: Need Script Help.

sona_sa — Mon, 25 May 2015 10:20:48 GMT

Sir I want SPD wise SRD Dealr price or stock qty.

Re: Need Script Help.

sona_sa — Mon, 25 May 2015 10:52:10 GMT

Hi petter, If any doubts u have please revert me. So I can reply for the same.

Re: Need Script Help.

sona_sa — Mon, 25 May 2015 11:54:58 GMT

Do u have any doubts, please revert me.

Re: Need Script Help.

sona_sa — Mon, 25 May 2015 15:48:13 GMT

What happen do u have any solution for the same or not.

Re: Need Script Help.

pratap6699 — Mon, 25 May 2015 19:13:54 GMT

there is no SRD SPD fields are there...how to analyse those fields

Re: Need Script Help.

Anonymous — Mon, 25 May 2015 22:26:32 GMT

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.

Re: Need Script Help.

sona_sa — Tue, 26 May 2015 09:36:58 GMT

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.