Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day,
The previous Qlik Community thread refers: Export total straight table to Excel - Page 3 - Qlik Community - 1620552
Our company currently uses on prem QlikView and Qlik Sense, but plan to migrate to Qlik Sense SaaS in December 2024.
Currently QlikView allows one to dump a Straight Table and Pivot Table to Excel whilst retaining 1) totals and 2) column formatting (background and text colors, etc.).
On prem Qlik Sense also allows data exports from Tables and Pivots to Excel, but without retaining totals and column formatting. This is especially frustrating for troubleshooting purposes when this said data set could potentially contain "dislocated (erroneously unlinked) dimensions" which, as underlying rows, do not technically contribute to the measure totals.
Will this oversight be fixed in Qlik Sense SaaS?
This will address quite a crucial need in my industry.
Please confirm.
Thank you kindly.
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?
hi
in my app i have two line identical charts (duplicated)
the dimension is minutes, in the first line chart i use the continues scale is set to auto and the dimension values looks correct.
in the second line chart i use the custom option and the continues scale is checked, here the dimension values are not correct and unclear.
any ideas?
advanced thanks
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!