topic Re: Help with Expression in QlikView

Help with Expression

Anonymous — Mon, 10 Nov 2014 21:58:18 GMT

Hi,

Not sure if this is possible; I am trying to create a conditional expression to sum the values based on the Product_Unit.

So if Product_Unit='CBM', sum CBMUnit, else sum OtherUnit.

Is this possible?

sum({$<Product_Unit={CBM}>} CMBUnit)

thanks

Derrell

Mon, 10 Nov 2014 23:00:03 GMT

try this:

sum({$<Product_Unit={'CBM'}>} CMBUnit)

Anonymous — Tue, 11 Nov 2014 00:17:04 GMT

Sum(Pick(WildMatch(Product_Unit, 'CBM')+1, OtherUnit, CBMUnit))

Anonymous — Tue, 11 Nov 2014 01:30:41 GMT

Try this:(it happened for me and below worked)

=(if(Product_unit='CBM', Sum({<Product_unit={'CBM'}>} CBM_unit),Sum(Other_unit)))

This will work.

if not try this.

=(if(Product_unit='CBM', Sum({<Product_unit={'CBM'}>} Total <Product_unit> CBM_unit),Sum(Total <Product_unit> Other_unit)))

Hope this helps.

Regards,

Chinna

jagan — Tue, 11 Nov 2014 02:08:48 GMT

Hi,

Try like this using two Sum()

=Sum({<Product_Unit={'CBM'}>} CMBUnit) + Sum({<Product_Unit-={'CBM'}>} OtherUnit)

Note : The above expression is shown as syntax error near -=, but it works ignore that error.

Regards,

Jagan.

jagan — Tue, 11 Nov 2014 02:10:32 GMT

or you can just simply give

Sum(CBMUnit + OtherUnit)

because if Product_Unit=CBM you have the other Unit as 0 and vice versa. So this also works.

Regards,

jagan.

Tue, 11 Nov 2014 03:07:23 GMT

HI,

This should be work.

Sum(CBMUnit + OtherUnit)

Priyantha