topic Re: Expressions in QlikView

Expressions

rathnam_qv — Mon, 08 Jul 2013 08:28:47 GMT

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

Re: Expressions

Qlik__Vinodh — Mon, 08 Jul 2013 08:43:03 GMT

Hi muni,

did u got the soluation for this ?

regards,

vinod

Re: Expressions

Mon, 08 Jul 2013 08:48:07 GMT

if( Scenario=Actual, losses)

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

if( Scenario=Planl, losses)

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

or try this

if( Scenario='Actual', losses)

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

if( Scenario='Planl', losses)

Re: Expressions

rathnam_qv — Mon, 08 Jul 2013 08:50:58 GMT

no yar

can u help me plz...

Thanks in advance

smiley

Re: Expressions

NavinReddy — Mon, 08 Jul 2013 08:54:51 GMT

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

try this

Re: Expressions

er_mohit — Mon, 08 Jul 2013 08:57:21 GMT

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)