Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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:
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.
!
Okay so have managed to resolve the issue by defining the variable within the formula.... works fine now!
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.