Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 215,348 members
  • 5,076 online
  • 1,991,693 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

    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
  • forum

    Qlik Replicate

    TSWP Files

    Can I manually apply tswp files from terminal ?
  • forum

    App Development

    Calculating variation of a value between current and previous month

    Good afternoon,I created two variables on my qlik app, one that identifies the current month, and one that identifies the previous month. Now I wish t... Show More

    Good afternoon,

    I created two variables on my qlik app, one that identifies the current month, and one that identifies the previous month. Now I wish to calculate the difference in detections between each month, I was trying to use the following expression but got an error:
    =Sum({<'$(=vCurrentYearMonth)'>} Detections) - Sum({<'$(=vPreviousMaxMonth)'>} Detections)
    Any suggestions?
    Detections is a defined measure in my app.

    Show Less
  • forum

    Qlik Reporting Service

    Searching for data for the last month

    Hi, I'm a bit new to qlik and am building a report template. I have created a filter which has a search expression as follows: = (DueDate >= Date('01/... Show More

    Hi,

    I'm a bit new to qlik and am building a report template. I have created a filter which has a search expression as follows:

    = (DueDate >= Date('01/02/2024') AND DueDate <= Date('29/02/2024'))

    Is there a way to make this dynamic so that I don't have to hardcode the previous month like above etc?

     

    Thanks for any help!

    Show Less
  • forum

    New to Qlik Analytics

    Reload an ODAG App, is it possible?

    Hi, Is it possible to reload an app generated on-demand?Example: You generate the app then reload the script, is that possible? Qlik Sense Enterprise ... Show More

    Hi, Is it possible to reload an app generated on-demand?
    Example: You generate the app then reload the script, is that possible?

    Qlik Sense Enterprise on Windows 

    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

    Will my version of qlik sense enterprise be supported by Windows Server 2022

    I tried finding a support document but I am just wondering if Qlik Sense April 2019 qliksenseserver 13.2.1 is supported by Windows Server 2022.   We u... Show More

    I tried finding a support document but I am just wondering if Qlik Sense April 2019 qliksenseserver 13.2.1 is supported by Windows Server 2022.   We upgrading from Windows Server 2022

    Thanks

    Show Less
  • forum

    App Development

    Null values in If Statements

    Hi all, I'm using the following calculated dimension to compare two columns that contain quite a few nulls. =IF(IF(ISNULL([t1.col]), 'Val', [t1.col])=... Show More

    Hi all,

    I'm using the following calculated dimension to compare two columns that contain quite a few nulls.

    =IF(
    IF(ISNULL([t1.col]), 'Val', [t1.col])
    =
    IF(ISNULL([t2.col]), 'Val', [t2.col]),
    0,
    1)

    The columns are basically both the same and as a result, I'm getting a lot of NULL values where both columns contain null values but I want the expression to print 0 if the two values are equal (and I'd consider them to be equal if they are both null).

    I've tried this method, and I've also tried using ALT, as well as LEN(t1.col)<1 but neither of these has corrected the issue.

    I found this article:

    https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Scripting/null-value-handling.htm

    which says that comparing any two null values with any relational operator will result in a null value. But I thought I could circumvent this issue by converting all of my null values into text, however this doesn't seem to work.

    Any help on this would be appreciated, I've tried pulling out each side of the operator in order to confirm that this code:

    IF(ISNULL([t1.col]), 'Val', [t1.col])

    will in fact convert null values into text and it seems to be working just fine but for some reason the if statement still doesn't work.

    Thanks in advance for the help!

    Show Less
  • forum

    Qlik Reporting Service

    Saas Reporting - Report Task failed to send

    Hi, I did all the steps for qlik cloud reporting, and I get an error message when running the report, how do I find the reason?    when editing I get... Show More

    Hi,

    I did all the steps for qlik cloud reporting,

    and I get an error message when running the report, how do I find the reason?

    ester_pr_0-1703136675008.png

     

     when editing I get

    ester_pr_1-1703136675059.png

     

    view

    ester_pr_2-1703136675187.png

     

    1. The email was checked and correct, I also tried a different email and still the same error

    2. the filter is the exact name, and i tried without a filter

    3.  there is an email setup on the server that works properly and sends emails and subscriptions

    what should I do?

     

    Ester

    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!