Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
mmonfort
Creator
Creator

Qlik Sense variables built in desktop client do not appear to work on server version

Hi guys

I have a Qlik Sense application built on my own desktop and it contains the following simple chart (see scatter plot on left)

qlik sense working version.PNG

the scatter plot measure is defined as follows:

avg({<[Month Year]={'$(vMaxMonthYear)'}, Period=>} Sales)/100

Where MaxMonthYear is a variable defined as:

=Date(addmonths(max(Period), 0), 'MMM-YYYY');

Anyway, this works fine on the desktop version and yet when I upload to a new server I have set up on AWS, the chart does not render... it looks like this instead:

Qlik sense variable server not owrking.PNG

Any ideas as to why this would be the case? I have tried to follow the instructions of other who had problems with variables by resetting the browser cache and restarting the server. These did not fix my problem.

!

2 Replies
mmonfort
Creator
Creator
Author

Okay so have managed to resolve the issue by defining the variable within the formula.... works fine now!

Anonymous
Not applicable

Hi. What do you mean you defined the variable within the formula?

I guess you meant you replaced the variable with the expression.

Instead of  avg({<[Month Year]={'$(vMaxMonthYear)'}, Period=>} Sales)/100

You used something like avg({<[Month Year]={'$(Date(addmonths(max(Period), 0), 'MMM-YYYY'))'}, Period=>} Sales)/100

I have the same problem. My variables disappeared when I migrated to Sense (Server). And there is no GUI in Edit mode as in desktop (not one I've found).

Is there no such GUI in Sense (server) to add/edit variables?

Regards.