topic Re: Custom Field in QlikView

Custom Field

jyothish8807 — Tue, 30 Sep 2014 08:51:24 GMT

Hello All,

I am stuck with a situation and need your help:

I have 4 fields say:

A,B,C,D

Out of this A & B are comming from the sheet.On the other hand C & D are custom field.The trick over here is:

C=A+B+D

D=B+C

How can i acheive this?How to create C & D which are interdepended.Iam trying to impliment this on a straight chart.

Regards

Re: Custom Field

anbu1984 — Tue, 30 Sep 2014 09:01:24 GMT

These calculations doesn't make sense. Can you explain with your real data

Re: Custom Field

ThornOfCrowns — Tue, 30 Sep 2014 09:03:53 GMT

Those sums are a mathmatical impossibility, what are you really trying to do?

Re: Custom Field

jyothish8807 — Tue, 30 Sep 2014 09:07:10 GMT

Sorry anbu cant share the real data.

Trick over here is:

Field C value is depended on Field D and Field D value is depended on value of C.

So i have to create two dependent Custom field.

Regards

Re: Custom Field

Tue, 30 Sep 2014 09:29:55 GMT

In your calculations, D is dependent on C and C is dependent on D. So, in order to do this calculation at least one value should be independent then you can add these custom fields using sum in calculated fields or expressions depending on the object,

Re: Custom Field

jyothish8807 — Tue, 30 Sep 2014 09:42:08 GMT

Thats what even iam thinking, but iam having a scenario like this.Really confused how to impliment this.

Can you let me know how to create a custom field in straight chart and use that field in any other field?

I mean how to use the custom field name?

Regards

Re: Custom Field

anbu1984 — Tue, 30 Sep 2014 09:52:17 GMT

-Create a label for your first expression

-Use that label in your second expression