Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 238,853 members
  • 4,237 online
  • 2,021,597 posts
  • 152,010 Solutions
Announcements
Global Transformation Awards! Applications are now open. Submit Entry

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    How to do Monthly data with calculations in the table

    Hi All, Requirement: I know how to do calculations  but I need help how to input/handle data like monthly associated with (P Release date) and calcula... Show More

    Hi All,

    Requirement: I know how to do calculations  but I need help how to input/handle data like monthly associated with (P Release date) and calculate monthly data in the table. (do i need any counter or loop or group by with resident load in script) ? 

    I have a huge data (P Release Date) from 2019 to current but here I am using inline table (sample data) to understand the requirements.

    Inline Table (data):

    main:
    load * inline [
    P Release Date, Deleted On, PO Release Date
    12/21/2022, -, 1/18/2023
    12/23/2022, 2/27/2023, -
    12/27/2022, -, -
    1/4/2023, 1/24/2023, -
    1/4/2023, -, 1/17/2023
    1/4/2023, -, 2/28/2023
    1/4/2023, -, 11/30/2023
    1/6/2023, -, 2/9/2023
    1/6/2023, -, 2/16/2024
    1/11/2023, 5/10/2023, -
    1/17/2023, 3/17/2023, -
    1/17/2023, -, 4/11/2023
    2/2/2023, -, 2/7/2023
    2/2/2023, -, 6/21/2023
    2/6/2023, 6/6/2023, -
    2/15/2023, 9/11/2023, -
    2/15/2023, -, 3/14/2024
    3/2/2023, -, 5/3/2023
    3/2/2023, -, 8/16/2023
    3/2/2023, -, 9/22/2023
    3/6/2023, -, 1/2/2024
    3/30/2023, 4/11/2023, -
    3/30/2023, 6/7/2023, -
    3/30/2023, 8/7/2023, -
    3/30/2023, -, 4/20/2023
    3/30/2023, -, 8/29/2023
    ];

    Output Result (in the table):

     

    Calculation 1

    Calculation 2

    Calculation 3

    Calculation 4

    Total of calculation 1,2,3, and 4

    Jan 2023

    0

    1

    1

    0

    2

    Feb 2023

    1

    4

    3

    0

    8

    Mar 2023

    1

    3

    4

    0

    8

     

    Calculated Columns 1, 2. 3, 4, and 5.

    Calculation 1 :

    P Release Date is before start of month

    Deleted On is blank

    PO Release Date is blank

     

    Calculation 2 :

    P Release Date is before start of month

    Deleted On is blank

    PO Release date is after start of month

     

    Calculation 3 :

    P Release Date is before start of month

    Deleted On is after start of month

    PO Release Date is blank

     

    Calculation 4 :

    P Release Date is before start of month

    Deleted On is after start of month

    PO Release Date is after start of month

     

    Calculation 5 :

    Add 1, 2, 3, and 4.

    Thanks in advance.

    Sara.

     

    Show Less
  • forum

    Deployment & Management

    Qlik.com Products page seems to have stopped working

    I am trying to log into the Qlik Product Downloads page, but I get an error: I've tried 2 accounts and see the same issue with both. Is anyone else h... Show More

    I am trying to log into the Qlik Product Downloads page, but I get an error:

    Drummer_0-1734169409883.png

    I've tried 2 accounts and see the same issue with both.

    Is anyone else having the same problem? Wanted to get an upgrade done OOO, but looks like I'll have to do it one evening next week instead as there's no support until Monday (so the chat bot informed me).

    https://community.qlik.com/t5/Download-Qlik-Products/tkb-p/Downloads

    Show Less
  • forum

    New to Qlik Analytics

    Tips on Using Qlik for Event Planning Projects

    I’m new to Qlik and currently working on an event project where I need to track data like guest lists, custom pahare (glasses) orders, and engraving r... Show More

    I’m new to Qlik and currently working on an event project where I need to track data like guest lists, custom pahare (glasses) orders, and engraving requests in real-time. I’m hoping to use Qlik to analyze this data and make everything run smoothly.

    Any advice on:

    1. Setting up data models for event-based projects?
    2. How to visualize custom orders or real-time data using Qlik?
    3. Any beginner tips for making the most of Qlik’s features for organizing large-scale events?
    Show Less
  • forum

    Deployment & Management

    Auto assign to Basic user in QLik Cloud Capacity Based

    Hi,Would like to ask if how to automatically assign the new users as basic users.the tenant of our client is using Google SAML as IDP and they don't w... Show More

    Hi,

    Would like to ask if how to automatically assign the new users as basic users.

    the tenant of our client is using Google SAML as IDP and they don't want to manually assign every time there is a new user logged in.

    Thank you.

    Show Less
  • forum

    Design and Development

    Publish to TMC succeeds but nothing is there

    Hey, We've just upgraded to Studio v8 and have republished all our existing jobs. They have all published and ran in the cloud successfully except for... Show More

    Hey, We've just upgraded to Studio v8 and have republished all our existing jobs. They have all published and ran in the cloud successfully except for 1 job. For this job, the publish process completes with the success message but there is nothing in TMC or on the server so it hasn't worked, however, there are no errors or warnings anywhere. Furthermore this job runs fine locally in studio and i can do a build to my local machine again, without any errors so something is going wrong on the journey to the cloud.

     

    Any ideas?

    Studio 8 R2024-11v2

     

    Thanks

     

    Show Less
  • forum

    Move to SaaS

    Error while running the Qlik Sense to SaaS Migration Capacity App

    I keep facing the below error when reloading the Qlik Sense to SaaS Migration Capacity App. Did anyone faced this issue ?    The following error occur... Show More
    I keep facing the below error when reloading the Qlik Sense to SaaS Migration Capacity App.
    Did anyone faced this issue ? 
     
    The following error occurred:
    Exists for \\QlikServer\Repository\Trace failed: boost::filesystem::status: The specified network name is no longer available [system:64]: "\\ServerName\Shared\ArchivedLogs\QlikServerName\Repository\Trace": unknown error
     
    The error occurred here:
    FOR EACH SubDirectory IN DirList( Root & '\*' )
     
    And it hangs and stays there for long time without reload completion.
    SessionLoad << QlikServerName_Session_Engine_2024-12-14T05.31.24Z Lines fetched: 5,013
     
    Show Less
  • forum

    Move to SaaS

    Getting error at qlik user me -q in Qlik Saas Migration power shell script scrip...

    Anyone faced the below error while migrating Qlik Apps to Cloud using CLI ? qlik : At Folderpasth\7_migrateapps.ps1:9 char:14+ $cliuserid = qlik user ... Show More

    Anyone faced the below error while migrating Qlik Apps to Cloud using CLI ?

    qlik :
    At Folderpasth\7_migrateapps.ps1:9 char:14
    + $cliuserid = qlik user me -q
    + ~~~~~~~~~~~~~~~
    + CategoryInfo : NotSpecified: (:String) [], RemoteException
    + FullyQualifiedErrorId : NativeCommandError

    Show Less
  • forum

    App Development

    Binary Loads in Qlik Sense

    Hi I need to do a binary load from a Qlik Sense App to another QS app but the Qlik help isn't really helping me much.The issue I have is that the apps... Show More

    Hi 

    I need to do a binary load from a Qlik Sense App to another QS app but the Qlik help isn't really helping me much.

    The issue I have is that the apps stored in Qlik Sense don't appear to be stored as QVF's on our server, they seem to be stored as .FILE

    QS1.jpg

     

    So When I try to create a connection to the file, the format is not recognised. I seem to remember that when you export these files, they convert to QVF's? I can do this and save somewhere but then how would this exported file get refreshed so that my binary load is always getting latest data?

     

    What am I missing?

     

    Thanks

    Show Less
  • forum

    Qlik Replicate

    different schemas with the same table's names in the one replication task

    I have this situation that I have few schemas with the same table names in every schemas and when I am adding these tables names are changed to table_... Show More

    I have this situation that I have few schemas with the same table names in every schemas and when I am adding these tables names are changed to table_name_1 and it is replicating with the same name with "_1" which is different name like in the source. I would like to handle it somehow. In old qlik every table was represanted like schema.table_name and it was not any issue when few schemas had the same table names.

    Show Less
  • forum

    Qlik Replicate

    Filter the number of records in each table

    How can I filter a number of records from each table when replicating a database? For example, the database has 10 thousand tables and each table has ... Show More

    How can I filter a number of records from each table when replicating a database? For example, the database has 10 thousand tables and each table has 1 million records. I would like to replicate only 100 records from each table.

    Show Less
X
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!