topic Re: expression in QlikView

expression

rathnam_qv — Mon, 08 Jul 2013 05:48:51 GMT

Hi all,

if Scenario=Actual, i need to find total losses

help me,

Thanks in advance

smiley

tresB — Mon, 08 Jul 2013 05:55:05 GMT

Try:

Sum( { <Scenario ={ 'Actual'}>} loss)

Or,

Sum ( If(Scenario=Actual), loss)

er_mohit — Mon, 08 Jul 2013 06:12:46 GMT

Sum(total {$ <Scenario ={ 'Actual'}>} loss)

sum( if(Scenario='Actual',total loss))

rathnam_qv — Mon, 08 Jul 2013 06:52:26 GMT

and i have Balance and Calculated Balance values. now can u tel me how can i write expression for that

Thanks in advance

smiley

rathnam_qv — Mon, 08 Jul 2013 06:53:50 GMT

tel me if it possible with set analysis as well

Thanks

smiley