topic Re: IF Statement error in QlikView

IF Statement error

alec1982 — Thu, 21 Jun 2012 15:14:26 GMT

Hi,

I am using the following IF query to show data in a chart expression.

='' & Num(

Sum([Sales]

/ if((GetFieldSelections(PSF) = 1), [FieldB], 1)

)

/ if((GetFieldSelections(_BTActiveCurrency) = '$USD'), 1, $(varBTExecSummaryUsdPerGbp))

/if(GetFieldSelections(_BTUnitOfMeasure) <> 'SQF', 0.09290304, 1)

, if((GetFieldSelections(PSF) = 1), '#,##0.##', '#,##0'))

I want to make some changes and I got confused..

Now if the (PSF) = 1 it calculate Sum([Sales] / [FieldB]

How can i make it to calculate :

if the (PSF) = 1 then just take [FieldB] as expression otherwisw keep the above method.

Thxs for your help

CELAMBARASAN — Thu, 21 Jun 2012 15:41:53 GMT

Hi,

Check with it

='' & Num(

Sum([Sales]

/ if((GetFieldSelections(PSF) = 1), [FieldB],

if((GetFieldSelections(_BTActiveCurrency) = '$USD'), $(varBTExecSummaryUsdPerGbp,

if(GetFieldSelections(_BTUnitOfMeasure) <> 'SQF', 0.09290304, 1))), '#,##0.##', '#,##0'))

Can you explain me what your trying to do?

Celambarasan

alec1982 — Thu, 21 Jun 2012 15:49:35 GMT

hi,

Thanks for the replay..

on the second and third line of the expression you have

Sum([Sales]

/ if((GetFieldSelections(PSF) = 1), [FieldB],

What i want to do is if the if((GetFieldSelections(PSF) =1 then use FieldB as expression by itself ...

So if it is = 1 I dont need it to calculate Sum(Sales) / by [FieldB]

Regards,

CELAMBARASAN — Thu, 21 Jun 2012 20:00:11 GMT

Hi,

='' & Num(

if((GetFieldSelections(PSF) = 1), [FieldB],

Sum([Sales])

/ if((GetFieldSelections(_BTActiveCurrency) = '$USD'), $(varBTExecSummaryUsdPerGbp,

if(GetFieldSelections(_BTUnitOfMeasure) <> 'SQF', 0.09290304, 1)), '#,##0.##', '#,##0'))

You mean like this?