Character's limit to write the Expresssion in Qliksense

[abhaysingh]

Hi Guys,

I am facing few new challenge in Qliksense while writing the Expressions in Qliksense

1= I am not able to write the lengthy expression, reason facing the Character limit issue. After one limit not able to write the expressions.

2= Variables not working properly

i.e.

a = Recent issue is , i have one condition ,

if( sum(Value) >  ( stock-  ( $(Variable1) - $(Variable2) ),1,0)

     this simple logic is not working, Reason i seen in this is  ($(Variable1) - $(Variable2) returning me Null.

Example2 = $(Stock)- ($(D1)  + $(D2)  + $(D3)  ) = output = null or invalid

$(Stock)- $(D1)  - $(D2)  - $(D3)   = output = Getting proper output, But according to me both condition should work.

b=

SET vTest = 1+2;

If I use $(vTest) it will return 3.

But if I use ($(vTest)) it will return Null.

Pls suggest.. Any input on this will be appreaciated

Reg..

Abhay

[marcus_sommer]

Better then using simple additions or subtractions from values is to use a range-function like rangesum() which has the advantage that invalid parameters will be treated as 0 and not returning NULL for the whole expression. Regarding to your variablen approach have a look here: Variables

- Marcus

[reddy-s]

Hi Abhay,

Have more complex expressions in the front end will reduce the performance of the application. Is it not possible to replicate the logic in the load script instead?

Thanks,

Sangram.

[abhaysingh]

No, actually all are need to be calculate on the front end by selections.