Expressions

[rathnam_qv]

hi all,

i need to find

i. Total losses when Scenario=Actual

ii . Total losses when Scenario=Plan

iii.Actual as a % of planned

please help me to write quries for that

Thanks in advance

smiley

[Qlik__Vinodh]

Hi muni,

did u got the soluation for this ?

regards,

vinod

[#3]

if( Scenario=Actual, losses)

*********************************************************

if( Scenario=Planl, losses)

***************************************************

or try this

if( Scenario='Actual', losses)

*********************************************************

if( Scenario='Planl', losses)

[rathnam_qv]

no yar

can u help me plz...

Thanks in advance

smiley

[NavinReddy]

if(Scenario=Actual,1,Total(Losses))

try this

[er_mohit]

1)sum(Total {$<Scenario='Actual'}>}losses)

2)sum(Total {$<Scenario='Plan'}>}losses)

3)sum(if(Scenario='Plan',losses))/sum(if(Scenario='Plan',total losses)) or

try this way

sum( {$<Scenario='Plan'}>}losses)/sum(TOTAL<Scenario>losses)

//and for this in presentation tab Fixed to 2 and check on show %

or if you using straight table then simply write

sum(Total {$<Scenario='Plan'}>}losses)

or tick on expression total in expression tab

try this

sum(Total {$<field=>}losses)