topic how to use if condition here in QlikView

how to use if condition here

Mon, 02 Jun 2014 18:03:51 GMT

I am taking two expressions in one field

'I: '& sum({<LineId={'25'},Number={'I*'}>} Units)

&' '

&' F: '& sum({<LineId={'25'},Number={'F*'}>} Units)

My result in table is

I: 0 F: 3

now i should not show I: 0 because it is having 0 value.

can anyone help me in writing this expression

thanks in advance.

its_anandrjs — Mon, 02 Jun 2014 18:13:47 GMT

You can try with

if( sum({<LineId={'25'},Number={'I*'}>} Units) = 0 ,' '&F: '& sum({<LineId={'25'},Number={'F*'}>} Units),

'I: '& sum({<LineId={'25'},Number={'I*'}>} Units)&' '&' F: '& sum({<LineId={'25'},Number={'F*'}>} Units)

if( sum({<LineId={'25'},Number={'I*'}>} Units) = 0 ,F: '& sum({<LineId={'25'},Number={'F*'}>} Units),

'I: '& sum({<LineId={'25'},Number={'I*'}>} Units)&' '&' F: '& sum({<LineId={'25'},Number={'F*'}>} Units)

Anonymous — Mon, 02 Jun 2014 20:03:54 GMT

Here's the expression if the same rule applies to F:

=IF(sum({<LineId={'25'},Number={'I*'}>} Units) <> 0,

IF(sum({<LineId={'25'},Number={'F*'}>} Units) <> 0,

'I: '& sum({<LineId={'25'},Number={'I*'}>} Units) & ' F: '& sum({<LineId={'25'},Number={'F*'}>} Units),

'I: '& sum({<LineId={'25'},Number={'I*'}>} Units)

)

IF(sum({<LineId={'25'},Number={'F*'}>} Units) <> 0,

'F: '& sum({<LineId={'25'},Number={'F*'}>} Units),

null()

)