Expression output as input

Anonymous — Thu, 30 Mar 2017 20:23:25 GMT

**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

Re: Expression output as input

Anil_Babu_Samineni — Fri, 31 Mar 2017 05:27:02 GMT

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')