topic Re: Expression in chart in QlikView

Expression in chart

carolin01 — Mon, 17 Mar 2014 10:33:17 GMT

Hi,

For the expression in my chart I use a variable:

=$(=vCalcYTDYear1)

This variable includes the following formula:

sum({$<FYear = {$(vChooseYear1)}, OrderPhase_Desc = {$(vOrderPhaseDesc)}>}NettAmount$(vCurrency))

As dimension in my chart I use a cyclic group which has got three fields: SoldToBusinessPartner, Product, CCCode. I would like to see the sum per dimension of my cyclic group only if the sum is larger then 0. Could anybody help me to adjust my formula or better implement it so that I can proceed to use the variable? I would like to do this as I already use a dimension limit for that formula that reduces data to X% relative to the total along the first values in sort order but for some reason Qlik View still keeps negative values which should not be included.

Best regards,

Carolin

Re: Expression in chart

its_anandrjs — Mon, 17 Mar 2014 10:39:43 GMT

Hi,

You mean to say that Sum of NettAmount if sum is larger then 0 if then put expression like this

if(sum({$<FYear = {$(vChooseYear1)}, OrderPhase_Desc = {$(vOrderPhaseDesc)}>}NettAmount$(vCurrency)) > 0,

sum({$<FYear = {$(vChooseYear1)}, OrderPhase_Desc = {$(vOrderPhaseDesc)}>}NettAmount$(vCurrency)) , 0 )

Hope this helps

Thanks & Regards

Re: Expression in chart

carolin01 — Mon, 17 Mar 2014 10:51:12 GMT

Hi,

Perfect, thank you - if I see that then it´s easy to understand but still hard for me to have the correct idea by myself .

Best regards,

Carolin