Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
jyothish8807
Master II
Master II

Custom Field

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

KC

Best Regards,
KC
6 Replies
anbu1984
Master III
Master III

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

ThornOfCrowns
Specialist II
Specialist II

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

jyothish8807
Master II
Master II
Author

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

KC

Best Regards,
KC
Not applicable

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,

jyothish8807
Master II
Master II
Author

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

KC

Best Regards,
KC
anbu1984
Master III
Master III

-Create a label for your first expression

-Use that label in your second expression