Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
We have Qlik Sense server running in old domain. We have taken the repository data base backup and installed Qlik Sense server on new domain. After installation i applied the backup which we have taken from old server and restarted the Qlik server.
I executed all command which i have listed below.
cd "G:\Program Files\Qlik\Sense\Repository\PostgreSQL\14\bin" Run the following commands in order to drop and then create the database: Drop database (if one exists): dropdb.exe -h localhost -p 4432 -U postgres QSR Create temp database: .\createdb.exe -h localhost -p 4432 -U postgres -T template0 QSR Restore the database by running the following command: pg_restore.exe -h localhost -p 4432 -U postgres -d QSR "<Path>\QSR_backup.tar" Start the Qlik Sense Service Dispatcher. cd "G:\Program Files\Qlik\Sense\Repository\ Repository.exe -bootstrap -standalone -restorehostname |
After That when i am trying to open QMC its open but everything disabled
Could you please suggest me what need to do to enable everything.
Note: In the new domain server. user directory table name will be different.
Regarding,
Irshad Ahmad
I have a set of data that looks like this:
Name | Date | Action |
peter | 1/1/2025 | open |
paul | 1/1/2025 | close |
mary | 1/1/2025 | reject |
peter | 1/2/2025 | open |
paul | 1/3/2025 | close |
mary | 1/4/2025 | reject |
peter | 1/5/2025 | reject |
paul | 1/6/2025 | open |
mary | 1/7/2025 | close |
peter | 1/8/2025 | open |
paul | 1/9/2025 | close |
mary | 1/10/2025 | reject |
I want to have results that look like this:
Name | Date | Action | results |
peter | 1/1/2025 | open | 0 |
paul | 1/1/2025 | close | 0 |
mary | 1/1/2025 | reject | 0 |
peter | 1/2/2025 | open | 1 |
paul | 1/3/2025 | close | 2 |
mary | 1/4/2025 | reject | 3 |
peter | 1/5/2025 | reject | 0 |
paul | 1/6/2025 | open | 0 |
mary | 1/7/2025 | close | 0 |
peter | 1/8/2025 | open | 6 |
paul | 1/9/2025 | close | 6 |
mary | 1/10/2025 | reject | 6 |
I've been trying to do it with concatenated fields, nested IF statements and multiple variables and I'm having no luck getting the syntaxes correct to do so, and it is making the script way too complicated to be readable.
The results are just the number of days since the named person has performed a particular action.
I could probably do this in Excel or a Python/PowerShell script prior to loading the data but I'd really like to understand how it can be done with the data load script. In my real data I have about 500 Names and a dozen or so actions, but I don't believe that will matter to the solution.
Why in all of creation does this not work at all!?
https://qlik.dev/extend/create-custom-themes/custom-themes-basic-examples/#example---app-selections
It should not be this hard to set a global default for selected, alternative, excluded etc. The code samples from the above link do nothing. I know I'm testing updated files because I can see title text change. I refuse to edit every single filterpane.
From a CSS angle, the selection appears to use the class .RowColumn-S which I can override by winning on specificity but it feels like a hack especially since the docs are clearly stating that I should be able to do this in theme.json.
Please clear this up for me.
Hi team,
attached is my sample data which have fact and master calendar and below is my script and chart expression
Fact:
LOAD
Measurefield,
date(floor(num(Date))) as Date,
Fact_flag
FROM folder;
Dim_MC:
LOAD
date(floor(num(Date))) as Date,
WEEK(Date) AS Week,
YEAR(Date) AS Year,
MONTH(Date) AS Month,
DAY(Date) AS Day,
WEEKDAY(Date) AS Weekday,
'Q'& CEIL (MONTH( Date ) / 3 ) AS Quarter,
DATE(monthstart( Date ), 'MMM-YYYY') AS MonthYear,
WEEK(Date ) & '-'& YEAR (Date ) AS WeekYear
from folder;
bar chart dim and exp
dim as month year
exp as below
if(GetSelectedCount(Year)>=1 or GetSelectedCount(Quarter)>=1 or GetSelectedCount(MonthYear)>=1 or GetSelectedCount(Week)>=1 or GetSelectedCount(Date)>=1,
Sum({<Fact_flag={'fact_1'}>}Measurefield),
Sum({<Fact_flag={'fact_1'},
MonthYear = {">=$(=date(MonthStart(AddMonths(Today(), -12)),'MMM-YYYY'))<=$(=date(MonthEnd(AddMonths(Today(), -1)),'MMM-YYYY'))"}>}Measurefield)
)
i want to show the default 12 months rolling in my chart and i don't want to disable the data enabling -> include zero values, because if there is no data for that month it have show 0 for the month since i am using master calender
now wht is happening in bar chart it shows entire all months here, it have to show only 12 months data as per the if loop section
note i dont want to disable the data handling -->include zero values please help and support on this and also no calculated dim also
Hi Team,
PFA of my sample data and QVF, I want to show the rolling 6 months data as default with monthyear dim and if there is no data for the rolling months it has to show zero in the bar chart and if user select any timeframe monthyear dim has to be changed accordingly as per the selected timeframe example week or year or date, All these are achieved.
now the issue is if i add another dim in the chart and disable the include null value , i am not getting the zero value. bar chart has to show allways rolling 6 bars, if no data then it shd be zero and similarly pivot shd show the rolling 4 months.
Does anyone know if it's possible to customize the emails sent for Alerts? Specifically, I want to remove anything that mentions Qlik (images, text, sender name, etc.) and only keep the title of the alert and the data that caused it to trigger.
With the turn of the calendar, it's a great time to recap the exciting reporting updates from 2024 and look forward to 2025 and the continued expansion of reporting capabilities on Qlik Cloud Analytics.
We packed 2024 with enhancements in reporting capabilities, featuring sought-after additions to both enterprise reporting and interactive distributions.
Quick recap:
For details on the 2024 releases, check out the "What's New" section and filter on Analytics > Reporting and Alerting.
Reporting from Qlik Cloud Analytics on the help site should be your starting point for understanding the power and flexibility of reporting on Qlik Cloud Analytics. Take the time to review it in detail, it is very comprehensive!
Looking ahead to 2025*
Work is already underway on some exciting capabilities:
We are also investigating other areas of customer feedback, such as dynamic filter import, and dynamic filename definition. Please continue sharing your ideas on our community ideation portal - the status of reporting topics in ideation is up to date as of this post. Stay tuned and start planning for Qlik Connect!!!
*Disclaimer: This post includes Qlik® roadmaps statements to provide a general overview of our anticipated product direction as of the date hereof. Qlik undertakes no intention or obligation to update or revise any forward-looking statements contained herein, whether as a result of new information, future events or otherwise.
Does anyone know of a Qlik Cloud map extension, open source or paid, that can handle over 100K points? The built-in map seems to have a limit of about 4K points.
Hello,
Our company is in the process of moving to Qlik Cloud. We are in the process of migrating Nprinting reports to the cloud, mainly tabular reports, as they are based on Excel models.
On some reports, we are encountering migration problems. For example, we are applying a filter on a line graph for data from a specific week (filter CSL_Last_Week_Actual_Year on graph <wyEBjY>, screenshot below of Nprinting design).
When I export this Nprinting template to a tabular report template (with "Export Qlik Cloud reports" on Qlik Nprinting web console), I get an error because this functionality is not available in tabular reports : "Object filters are not supported. The following tags will not be filtered"
How can I apply a specific filter to a specific graph on Qlik Cloud Reporting? With tabular reports, Pixelperfect, automation, etc...
Thanks,
Florian
Attendees get two free certification exams included with their event registration (valued at $500).
Qlik Reporting Service received a significant upgrade with several new features!
Join us for expert guidance on thriving post-AI with After AI: Reinventing Data, Insights, and Action Amidst the Noise.
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 enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.
Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
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!