Expression output as input

[Anonymous]

**Qliksense**

Hi,

requirement table

brand      +veNUM     -veNUM     +veLOSS     -veLOSS

Condition to calculate +ve and -ve is as:

sum(month_start_date={=max(month_start_date)} YTD*QTY)

-

sum(month_start_date={=max(month_start_date,-12)} YTD*QTY)

if >0 is +ve else -ve

We are able to get the +veNUM and -ve NUM but for +veLOSS and -ve LOSS facing issue

+veLOSS should be +veNUM against the brand divided by Overall(+veNUM) similar way for -veLOSS

when we are trying calculation is taking overall +ve and -ve both.

how to get the overall +veNUM and -Ve num separately at chart level

Thanks
Manish Madan

[Anil_Babu_Samineni]

Bit confusing over here, Would you provide sample. I am assuming you may need this

Create Variable for that operator then use If(Variable>0, '+ve','-ve')