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: 
mahieuphilippe
Creator
Creator

How to mix two dimension into a graphic table with formula set analysis

Hello everybody,

 

i find a solution to mix into my expression a formula with inside two dimension.

problem if i select only one of the two dimension,  the result is not correct 

 

this is my formula : 

 

=70.51*(273.15/101.325)* Sqrt(((10+101.325))* ((sum ({$<GROUP_NAME={'PHZ/Comb'},ITEM_NAME = {'pression (kPa)'}>}STATEMENT_VALUE))+101.325)

 


/((15+273.15)*(sum ({$<GROUP_NAME={'PHZ/Comb'},ITEM_NAME = {'Temp (°C)'}>}STATEMENT_VALUE)+273.15)))
*SQRT(mode ({$<GROUP_NAME={"Burner PB*"},ITEM_NAME = {'Primary air'}>}STATEMENT_VALUE)/1000)

 

the are two dimension   (group name   'Burner PB*'  and  group name ''PHZ/Comb'.

 

the result is  :

 

 

mahieuphilippe_0-1752133739856.png

 

i want to use only one dimension burner PB from 01 to 07 and to have the result of the second dimension 

because the result of my formula is not good  the part concerning the second dimension give '0'

 

mahieuphilippe_1-1752133894605.png

thanks in advance for your help   Ph

 

 

 

Labels (1)
0 Replies