Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
abhaysingh
Specialist II
Specialist II

Character's limit to write the Expresssion in Qliksense

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

3 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

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
Master II
Master II

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
Specialist II
Specialist II
Author

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