Why would a measure expression works in Qliksense desktop but not in Qliksense enterprise?

[ol_dev]

Hi,

I am trying to use an expression to calculate the value of a measure. The value appears correct in Qliksense desktop locally, but when deployed to server environment it shows 0. The expression makes comparison to variables which stores data values, which looks like the one below: 

Count({<IsFlagged={1}, BaseDate={">=$(vStartDate) <=$(vEndDate)"}>} ServiceID)

Is there a reason why such expression works perfectly fine in Qliksense Desktop but not in Qliksense Enterprise server environment? And how can I fix the issue? Thanks. 

[lennart_mo]

Hi @ol_dev,

in my experience this should work. Could you please take a look, at what the grey section on the bottom of the expression editor resolves your expression to? 

This is what it looks like for me:

Best regards

Lennart

[marcus_sommer]

It's not a matter of the measure else of the underlying data. A different environment may contain another data-set in regard to the included columns/rows as well as the numbers might now strings and vice versa and/or having a different formatting which could prevent the expected results - and this may happens in any stage of the ETL. Therefore take at first a look on the data itself.

[hanna_choi]

Hello @ol_dev 

Would you to check the date variable values returned on the desktop and the date variable values returned on the server?

[robert_mika]

Check and compare the Main section(the first page in Load script) in both environments ,this(among some others) maybe the reason.

As the initial variable maybe set up in different way.