Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 217,110 members
  • 6,185 online
  • 1,994,700 posts
  • 149,477 Solutions

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    day numbers

    Hi, Below is the master calander we are using and the fiscal start month is = 7. Here I want o calculate the daynumber starting month July every year.... Show More

    Hi, Below is the master calander we are using and the fiscal start month is = 7.

    Here I want o calculate the daynumber starting month July every year.

     

     

    Datefield:
    LOAD date($(varMinDate)+IterNo()-1) AS DateNum_Fisacal
    AUTOGENERATE (1)
    WHILE $(varMinDate)+IterNo()-1<= $(varMaxDate);
    Set vFM = 7 ; // First month of fiscal year

    Calendar:

    Load * ,Dual(fYear-1 &'/'& fYear, fYear) as FYear, // Dual fiscal year
    Dual(Month_F2, fMonth) as FMonth; // Dual fiscal month

    Load *,Year_F2 + If(Month_F2>=$(vFM), 1, 0) as fYear, // Numeric fiscal year

    Mod(Month_F2-$(vFM), 12)+1 as fMonth; // Numeric fiscal month

    Load Year(DateNum_Fisacal) as Year_F2, // Your standard master calendar

    Month(DateNum_Fisacal) as Month_F2,

    DateNum_Fisacal

    Resident Datefield;

    Show Less
  • forum

    App Development

    Users to Reload the Application from the Sheet

    I have an Application, In that a button is given to reload the data from the Sheet. Is there any possibility that the reload can be the done from the ... Show More

    I have an Application, In that a button is given to reload the data from the Sheet. Is there any possibility that the reload can be the done from the user end after publishing and giving access to the users to that dashboard.

    Qsadmin_0-1713433624238.png

     

    Thanks in Advance.

    Show Less
  • forum

    Move to SaaS

    Difference between Can view and has restricted view for analyzer entitlment in a...

    Hello everyone, With the new release: - A user with analyzer entitlement and has restricted view role in a managed space can export data - A A user wi... Show More

    Hello everyone,

    With the new release:

    - A user with analyzer entitlement and has restricted view role in a managed space can export data

    - A A user with analyzer entitlement and can view role in a managed space can export data and ... ??

     

    Could you help me with the second statement ?

    Thank you

    Show Less
  • forum

    Deployment & Management

    chr(304) error )=

    Hello, I am writing from Turkey. When do you plan to solve the capital "i" letter chr(304) problem?
  • forum

    Deployment & Management

    Can't export certificate to .PFX file

    Hi,  According this Backup guide https://help.qlik.com/en-US/sense-admin/February2024/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QS... Show More

    Hi, 

    According this Backup guide

    https://help.qlik.com/en-US/sense-admin/February2024/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Backing-up-certificates.htm

    I should select the option "Personal information exchange"  but I can't select it.

    Is it necessary to use this option if I want use Qlik sense to be activated on another server (same version) ?
    If I choose first option for example (.CER), will it change anything?

    * Qlik sense version - May21  

    Thanks.
    I have not found specific information about this elsewhere

    adimiz123_0-1713430732583.png

     

     

    Show Less
  • forum

    App Development

    Task scheduling custom option

    Hello, I need some help scheduling a task to start running : - on the last day of the month - and run every 5minutes The app take about 1 minutes to ... Show More

    Hello,

    I need some help scheduling a task to start running :

    - on the last day of the month

    - and run every 5minutes

    The app take about 1 minutes to run but is setup to pick different load each time until all the last load 

    Thank you

    Show Less
  • forum

    App Development

    NL Insight issue . Unable to connect to Qlik Sense Engine. Possible causes : Too...

    Hi, We have upgraded Qlik Sense from Feb-2022 to Feb-2024 patch 2 and faced below issue while testing the new component NL insights . checked the max... Show More

    Hi,

    We have upgraded Qlik Sense from Feb-2022 to Feb-2024 patch 2 and faced below issue while testing the new component NL insights .

    1. checked the max connections in postgres-sql conf file which is fine 
    2. checked web socket connection , working fine.

    diwakarreddy_0-1713429341323.png

     

    Can anyone please help on the issue.

    Regards,

    Diwakar

     

     

    Show Less
  • forum

    App Development

    Change default title of duplicated sheets

    Hello, In our enviroment some users can duplicate sheets from published apps, but all duplicated sheets have the same title ( with increment at the en... Show More

    Hello,

    In our enviroment some users can duplicate sheets from published apps, but all duplicated sheets have the same title ( with increment at the end ) and it's difficult to identify my own duplicated sheet.

    It's there a file or something that can be modified to include the owner in sheet title ? 

    I have QlikSense Enterprise - Nov 2023 

    Thanks, 

     

    Show Less
  • forum

    Qlik Compose for Data Lakes

    HOW TO LOAD DATA FROM QVD FILES TO GOOGLE SHEETS

    I have source records from Qlik saved as QVD files. I also have google sheets which is used as a backend DB   What can i do to extract/load/export dat... Show More

    I have source records from Qlik saved as QVD files.

    I also have google sheets which is used as a backend DB

     

    What can i do to extract/load/export data from those QVD files to Google Sheets without lost of records.

     

    Also each time a new records is saved into the QVD files, it should also automatically load the updates into the google sheets

    Show Less
  • forum

    New to Qlik Analytics

    Concat using Distinct

    Replace (Concat(distinct KPI,''),',', ' * ')
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!