Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 173,211 members
  • 2,395 online
  • 1,793,040 posts
  • 137,109 Solutions
Announcements
You can succeed best and quickest by helping others to succeed. Join the conversation.

Welcome to Qlik Community

Recent Discussions

  • forum

    Connectivity & Data Prep

    Apache hive connection not showing

    Hi All, Currently we upgraded our Qliksense to May 2023 and after upgrading the Qliksense the Apache hive connection is not showing in New connection ... Show More

    Hi All,

    Currently we upgraded our Qliksense to May 2023 and after upgrading the Qliksense the Apache hive connection is not showing in New connection tab.

    Please let me know is there any upgradation problem or Qlik removes the Apache hive connection. If they removes so how I can connect with Apache hive.

    Thanks in advance.

    Show Less
  • forum

    Qlik Cloud Data Integration

    Requirement to use Data Movement Gateway when using MSSQL as source

    Is it an absolute requirement to have a Data Movement gateway when using MSSQL server as source in QCDI? If the SQL Server is hosted in say Azure, why... Show More

    Is it an absolute requirement to have a Data Movement gateway when using MSSQL server as source in QCDI? If the SQL Server is hosted in say Azure, why is there a need for a Gateway if the server is available to Qlik Cloud?

    I get it for onprem servers, but cloud ones? I mean, there's no "Azure SQL Server" connector in QCDI, and no option for a "native" connection to an SQL Server (if available remotely).

    I'm suspecting it has to do with the way QCDI wants to read from the database - either log or CDC based, but I don't fully understand why the Gateway can but not QCDI natively.

    Show Less
  • forum

    Qlik NPrinting

    nprinting nov 2018 entity tags error...

    I installed 2018 Nov Nprinting(VMware) and installed 2018 Nov qlik sense in the other window server.but... I got error...What is the problem...???The ... Show More

    I installed 2018 Nov Nprinting(VMware) and installed 2018 Nov qlik sense in the other window server.

    but... I got error...

    What is the problem...???

    The customer bought Nprinting license... So.. I must find this error's solution

    Please help me....

    np_error.PNG

    Show Less
  • forum

    App Development

    How to retrieve user role group upon user login, assign the value to a variable ...

    Hi, My apps contains of hundreds of users where users are grouped using custom properties (named as strGroups) that setup in QMC to control how each g... Show More

    Hi,

    My apps contains of hundreds of users where users are grouped using custom properties (named as strGroups) that setup in QMC to control how each group of the user can access to app/objects in apps.

    In my sheet, I have navigation button,  login user with strGroups = 'A' will see the button enabled but the same button will be disabled if login user is from other strGroups .

    I have defined a variable in my load script to assign default value strGroups = 'A' but how to get the actual user group based on login user who access to my app?

     

     

     

     

     

     

     

    Show Less
  • forum

    Security & Governance

    Multi-Factor Authentication (MFA)

    Hi, i use QlikCloud. Is it possible to use MFA on single Qlik-Apps/reports?Do you know, which apps i can use for that?Thx 🙂
  • forum

    QlikView App Dev

    Month-over-Month variance table

    Hi, I am trying to create a table chart that has months with 'MMM' format as dimension and Total Sales, Sales Last Month and Variance as expressions. ... Show More

    Hi, I am trying to create a table chart that has months with 'MMM' format as dimension and Total Sales, Sales Last Month and Variance as expressions. The desired result will look something like this:

    Month Total Sales Sales Last Month Variance
    Jan 100 - 0
    Feb 150 100 50
    Mar 120 150 -30
    Apr 100 120 -20

     

    I have tried using Above() function for this case, it worked but is very limited in flexibility. The table will not worked if users made a selection like month. I have tried with expressions like:

    SUM({$<Month = {"$(=Max(Month-1)"}>} sales) 

    for the 'Sales Last Month' expression but instead of displaying previous month's sales, it just returns me the same values as in the 'Total Sales' column. I have looked at a lot of posts in this community but still can't find a solution for it. Can I know how can I create a table as above without using Above() function so it can still display the correct values if users made selections on month? Or is that possible?

    Show Less
  • forum

    Qlik Application Automation

    Section Access Issue

    Hello Community, I am Created 1  dashboard & i want to create the section access. In Raw DATA i have column 'Destination Country' so i change as UNIT ... Show More

    Hello Community,

    I am Created 1  dashboard & i want to create the section access.

    In Raw DATA i have column 'Destination Country' so i change as UNIT

    [Destination Country],
    if(WildMatch([Destination Country],'*Thailand*'),'Thailand',
    if(WildMatch([Destination Country], '*Indonesia*'),'Indonesia',
    if(WildMatch([Destination Country], '*Singapore*'),'Singapore',
    if(WildMatch([Destination Country], '*Vietnam*'),'Vietnam',
    if(WildMatch([Destination Country],'*Malaysia*'),'Malaysia',
    if(WildMatch([Destination Country], '*Cambodia*'),'Cambodia',
    if(WildMatch([Destination Country], '*Laos*'),'Laos',
    if(WildMatch([Destination Country],'*Myanmar*'),'Myanmar',
    if(WildMatch([Destination Country],'*China*'),'China','Non-AT Countries'))))))))) as [UNIT],

    I have Column UNIT in this there is multiple country please find below 

    inam_0-1695363499510.png

    i am created section access but its not working please find below ( here work only user id and password for example HAMD open the application user id and password working properly but In UNIT show all Country instead of Thailand)

    inam_1-1695363684120.png

    and i am also created below but its not work

    inam_2-1695364143896.png

     

    Please Help me how I solve this Section access i just want to show HAMD Thailand ,kHNIN Singapore & CHILVERICC Laos.

     

     

    Show Less
  • forum

    Move to SaaS

    Totals text is not clear on charts in QlikSense cloud

    Hi,  I have recently started using Qlik sense cloud and we are using Qliksense November 2022 Patch 7 version of the app. When try to get the totals on... Show More

    Hi, 

    I have recently started using Qlik sense cloud and we are using Qliksense November 2022 Patch 7 version of the app. When try to get the totals on top of a bar chart. The text for the total is not clearly visible. Sometimes it is not even readable. I've never faced this issue before but this has been the case ever since we moved to the cloud. 

    Is there anything I can do to fix this? Please see the attached screenshot

    Thanks in advance

     

    Qlik Sense Business Qlik Cloud 

    Show Less
  • forum

    New to Qlik Sense

    Sum skript table and sql varchar change tot date

      Hi It's sql table varchar     Hi It's sql table varchar This working Sum( {<MonthYear={'$(=MaxString(MonthYear))'}>} QC_EvaluationResult)but there... Show More

     

    Hi

    It's sql table varchar

     

     




    Hi

    It's sql table varchar

    kkarlste_3-1695617173417.png



    This working Sum( {<MonthYear={'$(=MaxString(MonthYear))'}>} QC_EvaluationResult)
    but there will be no years and months for the columns
    Month year is varchar sql table. How do I change the script to varchar to date.
    If after this the formula could sum the values ​​per month

    kkarlste_0-1695616877676.png

     

     

    Show Less
  • forum

    App Development

    Modify the QLIK Logo in Left top of an application

    Hello, How I can change the QLIK logo which is in the top left of a screen application please ?   The style image not working  Thanks a lot for your... Show More

    Hello,

    How I can change the QLIK logo which is in the top left of a screen application please ?

     

    Bruno_D2BI_0-1693334252430.png

    The style image not working

    Bruno_D2BI_1-1693334283839.png

     Thanks a lot for your help.

    Regards,

    Bruno

    Show Less
Leaderboard

Customer Story

New Data Integration Customer Story + Video

Real-time Responses Delight Burgan Bank's Customers.

Customer Story

Talking Analytics to the Frontier

Alaska’s Northrim Bank wins the SBA Lender of the Year award, using Qlik to target unique local needs.

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!