Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 222,507 members
  • 3,315 online
  • 2,003,366 posts
  • 150,241 Solutions
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER

Welcome to Qlik Community

Recent Discussions

  • forum

    Deployment & Management

    Upgrade Qliksense Fails

    Hello, i tried to upgrade qliksense february 2024 to may 2024 by it's failed. In the log we can see : "MSI (s) (4C:68) [20:11:58:266]: Executing op: C... Show More

    Hello,

    i tried to upgrade qliksense february 2024 to may 2024 by it's failed.

    In the log we can see :

    "MSI (s) (4C:68) [20:11:58:266]: Executing op: CustomActionSchedule(Action=CA_StartDatabase,ActionType=3137,Source=BinaryData,Target=CAQuietExec,CustomActionData="C:\Windows\SysWOW64\net.exe" start "QlikSenseRepositoryDatabase")
    MSI (s) (4C:D0) [20:11:58:268]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI1A1.tmp, Entrypoint: CAQuietExec
    MSI (s) (4C:FC) [20:11:58:269]: Generating random cookie.
    MSI (s) (4C:FC) [20:11:58:280]: Created Custom Action Server with PID 10896 (0x2A90).
    MSI (s) (4C:EC) [20:11:58:368]: Running as a service.
    MSI (s) (4C:EC) [20:11:58:372]: Hello, I'm your 32bit Elevated Non-remapped custom action server.
    CAQuietExec: The service name is invalid."

     

    The service QlikSenseRepositoryDatabase does not exist anymore because i use postgresql-x64-14

    How i can fix that ?

    Thank for your help

    Show Less
  • forum

    New to Qlik Analytics

    Free Qliksense tool

    Hi Qlikies, I want to know if there is any Qliksense tool (which is free for endless time) on which I can practice on my local machine. Qliksense Clou... Show More

    Hi Qlikies,

    I want to know if there is any Qliksense tool (which is free for endless time) on which I can practice on my local machine. Qliksense Cloud trial is free for just 30 days. Please help.

    Thanks

    Show Less
  • forum

    App Development

    How to create two filter panes than inverse options

    I want to create two filter panes that have the same values in each, but when one value is selected in pane one, it is removed from pane 2. The goal i... Show More

    I want to create two filter panes that have the same values in each, but when one value is selected in pane one, it is removed from pane 2. The goal is to be able to compare the selections in a line graph referencing the individual filter panes. 

    The images below show the functionality I'm looking for. I have this somewhat working using a "match" table where I compare the selections of the first filter pane and then limit the selections of the second, but for some reason selecting anything in the second table makes everything selected in the first.

    LOAD * INLINE [
    GROUPMATCH;GROUP B
    !;!
    Community;Tertiary
    Community;Quaternary
    Tertiary;Community
    Tertiary;Quaternary
    Quaternary;Community
    Quaternary;Tertiary
    Community, Tertiary;Quaternary
    Community, Quaternary;Tertiary
    Tertiary, Quaternary;Community
    Community, Tertiary, Quaternary;!
    ](delimiter is ';';

    lutzcc_0-1718377174322.png

     

     

    I'm hoping there is an easier way to accomplish this!

    Show Less
  • forum

    New to Qlik Analytics

    Security

    How to Apply Row level security in Qlik?
  • forum

    New to Qlik Analytics

    Excluding filter selection not working with AGGR

    Hi I have two expressions first case i need ignore CalendarYearQuarter selection as filter below expression works fine sum({$<CalendarYearQuarter =,St... Show More

    Hi I have two expressions first case

    i need ignore CalendarYearQuarter selection as filter below expression works fine

    sum({$<CalendarYearQuarter =,StartDateQuarterName = {'$(=QuarterName(today()))'},TableName ={'Stage1Date'}, Mapped={'AE OB'},[Type.Opportunity] ={'New business'},[POC_Opportunity.Opportunity]={'0'},[WOCRecord.Opportunity]={'0'}>} ImpliedRevenueP1)

     

    in below case i am calculating % in denominator i need to use AGGR function this case it is not working any help?

    sum({$<CalendarYearQuarter =,StartDateQuarterName = {'$(=QuarterName(today()))'},TableName ={'Stage1Date'}, Mapped={'AE OB'},[Type.Opportunity] ={'New business'},[POC_Opportunity.Opportunity]={'0'},[WOCRecord.Opportunity]={'0'}>} ImpliedRevenueP1)
    /
    sum(aggr(max({$<CalendarYearQuarter =,StartDateQuarterName = {'$(=QuarterName(today()))'}>} AE_TARGET),InitialQBRTeam_rep,InitialCreatedByUserName_Rep,StartDateQuarterName))

    Show Less
  • forum

    New to Qlik Analytics

    Upgrade to Qlik Sense May 2024 from Qlik Sense Apr 2020

    Hi All, Currently, the client is using the Qlik Sense April 2020. Now I need to upgrade it to the Qlik Sense May 2024. What are the measures I have to... Show More

    Hi All,

    Currently, the client is using the Qlik Sense April 2020. Now I need to upgrade it to the Qlik Sense May 2024. What are the measures I have to go through to upgrade the version ?

    Show Less
  • forum

    Qlik Replicate

    S3 writing failing

    Hello Team   Our task is configured with S3 as target and the process is working fine during the full load but the incremental load is throwing the be... Show More

    Hello Team

     

    Our task is configured with S3 as target and the process is working fine during the full load but the incremental load is throwing the below error.

    We have following version installed - May 2024 (2024.5.0.144).

    Error:

    Failed to create destination directory 'tfsdl-ccg-ods-test/landing/attrep_apply_exceptions/'.
    Failed to upload empty file to bucket 'tfsdl-ccg-ods-test' as 'landing/attrep_apply_exceptions/', status = 4 (FAILED)
    SlowDown: Please reduce your request rate.

     

    I have also placed the error image.

     

    Show Less
  • forum

    Connectivity & Data Prep

    Few fields in MongoDB database table not visible.

    Hi Everyone, I have a MongoDB connection in Qlik Sense Enterprise and I am accessing a table from that database. However, I can only access 17 fields ... Show More

    Hi Everyone,

    I have a MongoDB connection in Qlik Sense Enterprise and I am accessing a table from that database. However, I can only access 17 fields in that table, and 2 fields are missing.

    The MongoDB team has ingested those fields on their end, and they are visible in their database, but they are not visible in the Qlik MongoDB table.

    We have two connections: one for the PRODUCTION server and one for the DEV server. This issue is occurring in the PRODUCTION server but not in the DEV server.

    What could be the cause of this issue?

    Thanks & Regards,

    Rajat

    Show Less
  • forum

    Deployment & Management

    Qlik Sense server May 2024 setup failure on "Qlik Sense Service Dispatcher" psql...

    Hi, We have a blocking setup error of Qlik Sense server May 2024 on our single node recovery server (luckily we test on it before upgrading developmen... Show More

    Hi,

    We have a blocking setup error of Qlik Sense server May 2024 on our single node recovery server (luckily we test on it before upgrading development then production servers).

    As we had multiple setup failures (with and without QPI tool), even trying to go back to our August 2022 version after full de-installation, the support adviced us to restore the machine, which is very costly so I am here for some help !

    Here is is the error log part and attached the full setup logs :

    CAQuietExec: DataPrepService configuration started.
    CAQuietExec: WARNING: Skiping the database initialization. No superuser or password specified.
    CAQuietExec: Creating schema 'dataprep_service'.
    CAQuietExec: Error executing database command "SELECT 1 FROM information_schema.schemata WHERE schema_name = 'dataprep_service'":
    CAQuietExec: psql: error: connection to server at "localhost" (127.0.0.1), port 4432 failed: fe_sendauth: no password supplied
    CAQuietExec: At C:\Program Files\Qlik\Sense\DataPrepService\install\install-utils\Postgres.ps1:109 char:9
    CAQuietExec: + throw "Error executing database command "" ...
    CAQuietExec: + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    CAQuietExec: + CategoryInfo : OperationStopped: (:) , Exception
    CAQuietExec: + FullyQualifiedErrorId : Error executing database command "SELECT 1 FROM information_schema.schemata WHERE schema
    CAQuietExec: _name = 'dataprep_service'": psql: error: connection to server at "localhost" (127.0.0.1), port 4432 failed: fe_se
    CAQuietExec: ndauth: no password supplied
    CAQuietExec:
    CAQuietExec: Error 0x80070001: Command line returned an error.
    CAQuietExec: Error 0x80070001: QuietExec Failed
    CAQuietExec: Error 0x80070001: Failed in ExecCommon method
    CustomAction CA_SetupDPS returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)

     

    Thanks for your help.

    Show Less
  • forum

    QlikView Administration

    Potential Issues With Removing QlikView Mounted Folder

    Hi, I'm looking to remove 2 of the 4 servers from our QlikView system. I've moved all the dashboards from the servers to be decommissioned and moved a... Show More

    Hi,

    I'm looking to remove 2 of the 4 servers from our QlikView system. I've moved all the dashboards from the servers to be decommissioned and moved all the associated NPrinting connection strings. I know I still have tasks that are referencing the old servers but these are old and should not be in use.

    I'm hoping that I can just go into the QMC and delete the two mounted folders for the servers I'm decommissioning and any references to them will just be removed from the tasks and anywhere else in the QMC. Has anyone done this? Is there anything in particular I should be concerned about?

    Thanks,

    Scott

    Show Less
Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

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.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!