Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
JGMDataAnalysis
Creator III
Creator III

$Field and Derive Fields

Hi everyone! 

Is there a way to list all derived fields from a particular table?

With the third set modifier I can ignore the selections made on any of the fields in the "ConsumosServicios" table, with the exception of derived fields, which unfortunately are not included in $Field.

Count(
	  {<
        [Flag_Activo_TrxServicio] = {1}
       ,[Flag_SinConsumo_TrxServicio] = {1}
       ,$(='[' & Concat({1<$Table = {ConsumosServicios}>} $Field, '], [') & ']')
      >}
        Distinct [Número Línea]
)

 

2 Replies
marcus_sommer

I don't know if there is a possibility to identify and fetch these derived fields. I'm not sure if there is a real benefit in the easiness to create them, their readability, their impact on the performance and the use within the UI - against regular created fields. Therefore I suggest to consider to adjust the approach.

- Marcus

JGMDataAnalysis
Creator III
Creator III
Author

Thank you very much @marcus_sommer.