Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
We updated our Qlik Sense enterprise server to the Feb Tech Preview and our QSense services are not starting up.
After running the update we got the following message:
And when trying to start the repository service we get the below error:
We attempted to change the registry setting in the server and also change the location of the postgres DB and this did not fix our issue
Your assistance would be highly appreciated
Kind regards,
Justin
I am trying to calculate the sum of the debits for the current month using the formula below. I'm not sure what I'm doing wrong here because I get only 0s with this formula.
sum({$<GL_Month={"=$(=Date(Floor(MonthStart(Max(ActualsDate))),'MMM-YYYY'))"}>}Accounted_Debit)
I want to calculate the value for the previous month as well.
GL_Month is the month column that is derived in the script with the following formula :
Date(MonthStart("ActualsDate"), 'MMM-YYYY') as GL_Month,
Hi There,I have n number of columns in the table and I would like to apply rank function on below variables based on latest survey date where i can filter out rank = 1.
Appreciate your advice.
Something similar to SQL Query.
rank() over (partition by COUNTRY, STATE order by survery_date desc)
from table
where rank = 1
Dear All,
We have a dashboard where all these calcs which you see are KPI's. The reason to use KPI is to see the up or down arrow with color to see performance. But while we load the page, it is taking too much time.
Please suggest what is the best way to represent same data with optimized sheet loading.
thanks in advance.
I have a QVD load that contains duplicate records because of an identifier. So, instead of having duplicate records, I want to create an identifier that is Yes or No for a specific string. As an example below, you can see the Secondary Key column contains extra strings _ RE and _NA, and these are duplicate records, so I want to have the result as a second table with a column indicator as the RE Identifier.
I appreciate your help on this.
Actual Table
Primary key | Seondary key | col3 | col4 | col5 | col6 | col7 |
ABC123 | B479238 | SOME VALUES | SOME VALUES | SOME VALUES | SOME VALUES | SOME VALUES |
ABC123 | B479238_RE | SOME VALUES | SOME VALUES | SOME VALUES | SOME VALUES | SOME VALUES |
ABC1234 | B130636 | SOME VALUES | SOME VALUES | SOME VALUES | SOME VALUES | SOME VALUES |
ABC1234 | B130636_RE | SOME VALUES | SOME VALUES | SOME VALUES | SOME VALUES | SOME VALUES |
ABC12345 | B280476 | SOME VALUES | SOME VALUES | SOME VALUES | SOME VALUES | SOME VALUES |
Expected table:
Primary key | Seondary key | col3 | col4 | col5 | col6 | col7 | RE Identifier |
ABC123 | B479238 | SOME VALUES | SOME VALUES | SOME VALUES | SOME VALUES | SOME VALUES | Yes |
ABC1234 | B130636 | SOME VALUES | SOME VALUES | SOME VALUES | SOME VALUES | SOME VALUES | Yes |
ABC12345 | B280476 | SOME VALUES | SOME VALUES | SOME VALUES | SOME VALUES | SOME VALUES | No |
Hi Everyone,
I have multiple KPI objects in my sheet. when I am loading this app it takes sometime to load the numbers. is there any way we can improve the loading. (Currently the data is loaded from a QVD).
thanks in advance.
Hi all,
Could you recommend me any articles or corses (now a qlikhelp), or sort of roadmap how to get these knowledge?
just read and try everything on qmc?
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!