Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 215,349 members
  • 4,638 online
  • 1,991,701 posts
  • 149,206 Solutions
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    Combining if into set analysis

    Hi all, below is a snapshot of my data which starts in Jan 1st 2023.  I wish find total using set analysis with the following criteria: 1. If(Actual >... Show More

    Hi all, below is a snapshot of my data which starts in Jan 1st 2023.  I wish find total using set analysis with the following criteria:

    1. If(Actual > Planned, Actual, Planned) and

    2. Between Monday and Friday.  Therefore, the correct total planned would be 11.

    I don't wish to create a new variable or using the load editor.

     

    Jobid Date Day Planned Widgets Actual Widgets if Actual > Planned,Actual,Planned
    1 18-Mar-24 Mon 0 1 1
    2 19-Mar-24 Tue 2 2 2
    3 20-Mar-24 Wed 2 1 2
    4 21-Mar-24 Thu 1 1 1
    5 21-Mar-24 Thu 0 1 1
    6 22-Mar-24 Fri 2 2 2
    7 22-Mar-24 Fri 2 2 2
    8 23-Mar-24 Sat 2 2 2
    9 24-Mar-24 Sun 2 2 2
          13 14 15
               
        Mon to Fri 9 10 11

     

     

    Show Less
  • forum

    Qlik Cloud Data Integration

    Can't install Qlik Sense Entensions on Qlik Cloud

    The extensions used in qlik sense on premise can't install on Qlik Cloud. It shows a message like "Invalid File". The extension is this:   Can anyone... Show More

    The extensions used in qlik sense on premise can't install on Qlik Cloud. It shows a message like "Invalid File". The extension is this:

    ironwill_1-1711571885079.png

     

    Can anyone help me please?

    Regards,

    Show Less
  • forum

    Move to SaaS

    qlik qrs export command giving error when --exportScope all flag is added

    Hi,   We are migrating from Qlik Sense Windows to Cloud. When running the migration scipt for migrating apps, it gives error. Tried each line in qlik ... Show More

    Hi,

     

    We are migrating from Qlik Sense Windows to Cloud.

    When running the migration scipt for migrating apps, it gives error. Tried each line in qlik cli. The line that fails is

             qlik qrs app export create $appid --skipdata $SS --exportScope all --output-file $exportAppFile

             Error: 400 - Bad Request (empty response)

    But when i run the command without the --exportScope all option in qlik-cli it works.

            qlik qrs app export create $appid --skipdata $SS  --output-file $exportAppFile

     

    Are there any permissions or setup that i am missing?

     

    Thanks,

    Anuradha

     

     

     

     

     

    Show Less
  • forum

    Connectivity & Data Prep

    Error noFileSize for QVD from a SFTP connector

    Loading a QVD file from a SFTP connector (not from webconnector) occurs an error: noFileSize Any file format doesn't have an error when loading.I tri... Show More

    Loading a QVD file from a SFTP connector (not from webconnector) occurs an error: noFileSize

    t_donnet_0-1711638845891.png

    Any file format doesn't have an error when loading.
    I tried to load with an other QVD, the same issue persist.

    Antivirus doesn't scan the SFTP folder.
    There is not file access restrictions, antivirus software locking the file, or resource bottlenecks

    Any idea to fix it?

     

     

    Show Less
  • forum

    Move to SaaS

    qlik app import is failing with 403

    Hi, When i try to import a .qvf from local to Qlik Cloud after setting the context. Getting the following error. What setting/permissions should i che... Show More

    Hi,

    When i try to import a .qvf from local to Qlik Cloud after setting the context.

    Getting the following error. What setting/permissions should i check

    qlik app import -f .\Data\QlikSense\Apps\2729801f-8296-4c20-803c-82008ef68322.qvf --spaceId 66057f9caede839bf606a915
    Sending Request 2s 2.50 MiB / 2.50 MiB [==================================================================================================================================================] 100.00% 1.15 MiB/s 2s
    Error: 403 - Forbidden (empty response)

     

    Thanks,

    Anuradha

     

    Show Less
  • forum

    Deployment & Management

    Error Message when opening visualisation

    I am able to; open QlikSense, see all Apps in the Qlik Sense Hub see all sheets and load data for all the Apps.  However when I try to access the sh... Show More

    I am able to;

    • open QlikSense,
    • see all Apps in the Qlik Sense Hub
    • see all sheets
    • and load data for all the Apps. 

    However when I try to access the sheet it's self I get the following message displayed

    An error occured

    and then a refresh button

    A vague message with no explanation as to what I should be looking for.

    Does anyone have any suggestions?

     

     

     

     

    Show Less
  • forum

    Connectivity & Data Prep

    Qlik Sense-Service now connection Issue

    Hi Team,   We are currently on Qlik Sense Nov 2023 SR5 version.    I am configuring the Qlik ServiceNow connector and I am running into an issue. Issu... Show More

    Hi Team,

     

    We are currently on Qlik Sense Nov 2023 SR5 version. 

     

    I am configuring the Qlik ServiceNow connector and I am running into an issue. Issue is that I am just seeing the "sys_id_value" field for all the tables.

     

    Tables I have tried to access so far are sc_req_item, sc_request, dmn_demand, pm_project tables. From my knowledge, the username has access to the tables.

     

    @MTO  @DJK  Has anyone run into a similar issue? 

     

    Create a ServiceNow connection | Qlik Connectors Help

    #ServiceNow

    Qlik Sense Business 

     

    Thanks in advance! 

     

     

    Regards,

    Sujeet

    Show Less
  • forum

    New to Qlik Analytics

    IF Statements Help

    I'm currently working on the data load using IF statements below but keep getting an error for line 3 & 4. Can someone help point out what I'm doing w... Show More

    I'm currently working on the data load using IF statements below but keep getting an error for line 3 & 4. Can someone help point out what I'm doing wrong? I've included the sample data attached for reference of what I want as an outcome. Thank you in advance.

    1: date(CREATED_DATE, 'MM/DD/YYYY') as [Date Opened],

    2: STATUS_C as [Status],

    3: if([STATUS_C]= 'Closed', 'Closed','Open') as [Status Flag],

    4: If ([STATUS_C] ='Open',today()-Created Date as [Days Aged from Open Date],

    5: If ([STATUS_C] ='Open',If( [Days Aged] >= 0 and [Days Aged] < 90, replace( class([Days Aged],30),'<= x <','-') & ' Days', If( [Days Aged] >= 90, '90 Days+'))) as [Open Timeframe],

    kimdiep503_0-1711473433831.png

     

    Show Less
  • forum

    New to Qlik Analytics

    Bucketing Sales activity per month

    Hi there, I'm looking for a way to show sales activity done in the first month.  Currently this is only possible for the Current month as there is nex... Show More

    Hi there,

    I'm looking for a way to show sales activity done in the first month. 

    Currently this is only possible for the Current month as there is next month activity.

    How do I call on a specific activity date in a bucket?

    The metrics I (think) need to use are:

    [Revenue]

    [start date](in days eg. 01/01/2024, 02/01/2024, etc)

     

    So I want the following:

    Jan 2023 showing Month 1 revenue

    Feb 2023 showing Month 1 revenue

    March 2023 showing Month 1 revenue

    etc. etc.

    Is there a way to do this?

    Thanks

    Robert

    Show Less
  • forum

    New to Qlik Analytics

    Understanding Associations

    Hi, I have 2 tables which have some common fields. Now I want to add filters on those common fields and then when I select the filter values, both the... Show More

    Hi,

    I have 2 tables which have some common fields. Now I want to add filters on those common fields and then when I select the filter values, both the table visuals in my dashboard should show relevant data - something as below.

    Qlik.jpg

    To achieve this functionality, in data manager if I associate both tables by month_id then it will work fine when I make a selection in month filter alone. But if I make a selection in County filter alone (say I select Japan), then the flow would be  -

    1. from table_1 filters for Japan
    2. identifies corresponding months - which would be 202301, 202302
    3. looks for information related to these 2 months in table_2
    4. fetches first 4 records from table_2 which would be incorrect as it fetched USA too from 202301 and 202302 but not Japan from 2023

    I tried to create new filed concatenating both month_id and country fields. Then associated 2 tables based on this new field, but would still have the same issue as above.

    Joining tables will not be an option because in my actual data there are 3 more dimensions in table_1 which are not in table_2 and I have 5 more dimensions in table_2 that are not in table_1. In that case, joining by those 2 common dimensions (month_id & country) will multiply and create many unwanted rows. Moreover, joining fact tables is not ideal either.

    Appreciate any assistance on how to achieve this. Thanks!

    Show Less
Leaderboard

Customer Story

Qlik Data Integration & Qlik Replicate story

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.

Customer Story

Building a Collaborative Analytics Space

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.

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!