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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

fieldcontent as a new field

hello community,

I will try to discribe my problem in english:

I have a table with the fields

attr_value (project number)

rel_attr_id (ZE for budget € or ZM for budget mandays)

rel_value (the amount of the budget, in € or mandays, depending on rel_attr_id)

As i want to calculate the rates (budget euro / budget mandays) I need to have the fieldcontents of rel_attr_id as seperate fields, for example I sould end up with one table with the fields

attr_value:

Budget EUR

Budget Mandays.

hope you understand my problem,

regards

Astrid Hermann

1 Solution

Accepted Solutions
Not applicable
Author

Hi all,

i solved it quite simple:

if (rel_attr_id = 'ZM',rel_value)as budget_md,

if (rel_attr_id = 'ZE',rel_value)as budget_eur,



View solution in original post

1 Reply
Not applicable
Author

Hi all,

i solved it quite simple:

if (rel_attr_id = 'ZM',rel_value)as budget_md,

if (rel_attr_id = 'ZE',rel_value)as budget_eur,