topic Re: set analysis(using an if statement) in QlikView

set analysis(using an if statement)

Thu, 19 Jun 2014 10:16:05 GMT

Hi,

Can some1 help me on this, my if statement seems to not be working

(Sum( {$<ScriptMonth={$(=concat('"' & CurrYearMonth & '"', ',' ))}>} if(vMeasures = 'SepPack','(Qty * SepPack)',$(vMeasures))))

if the measure is = 'SepPack' then the calculation is not correct

Thanks in Advance

alexandros17 — Thu, 19 Jun 2014 10:21:26 GMT

Try with the $ expansion:

(Sum( {$<ScriptMonth={$(=concat('"' & CurrYearMonth & '"', ',' ))}>} if($(vMeasures) = 'SepPack','(Qty * SepPack)',$(vMeasures))))

let me know

Thu, 19 Jun 2014 11:08:12 GMT

I tried with that but it still doesnt work

swuehl — Thu, 19 Jun 2014 11:14:06 GMT

Remove the single quotes around your THEN branch:

Sum(

{$<ScriptMonth={$(=concat('"' & CurrYearMonth & '"', ',' ))}>}

if(vMeasures = 'SepPack',

(Qty * SepPack) // removed single quotes here, you want the fields, not a literal

,$(vMeasures)

)

Thu, 19 Jun 2014 11:22:18 GMT

Hi,

I removed single quotes and its working, thanks