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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to add compute field into a table

Hello,

i would add a compute field [EXIGENCE MERE] into a table but my result is empty

thanks for your help



LOAD

cat,

complexe

,

`id_project`

,

`id_req`

,

`id_req_parent`

,

origine

,

priority

,

reference

,

`req_description`

,

`req_name`

AS [exigence],

if

(fieldvalue('id_req_parent',NoOfRows('id_req_parent'))=0,[req_name] ,peek([req_name],fieldvalue('id_req_parent',NoOfRows('id_req_parent'))) ) AS [EXIGENCE MERE],

`req_type`

,

state

,

verif

,

version;

SQL

SELECT cat,

complexe,

`id_project`,

`id_req`,

`id_req_parent`,

origine,

priority,

reference,

`req_description`,

`req_name`,

`req_type`,

state,

verif,

version



FROM

`salome_pp_bdd`.REQUIREMENTS;







1 Reply
Not applicable
Author

You should just be able to add that field into your table expression.

First, you probably need to verify that the formula is working and you are getting data. You should create a Listbox for that field. If your formula is working, you should see data in that Listbox. If it is blank, you need to go back to your formula and figure out what is wrong.