Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 248,957 members
  • 7,427 online
  • 2,031,599 posts
  • 152,947 Solutions
Announcements
WEBINAR April 23, 2025: Iceberg Ahead: The Future of Open Lakehouses - REGISTER TODAY

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    Cannot convert timestamps to datetime

    Hello, I have a column in my data with what looks like timestamps in, but I'm struggling to convert these into meaningful date times in the load edito... Show More

    Hello,

    I have a column in my data with what looks like timestamps in, but I'm struggling to convert these into meaningful date times in the load editor. The data before the . is always 5 digits long but after the . there's a mixture of different length values - Could this be causing the issue?

    Some sample values include...

    45208.389583333
    45208.41875
    45208.640972222
    45205.33125
    45205.5
    45205.448611111

    If I add a duplicate column in the chart table with Timestamp(FIELD_NAME) the value converts correctly but if I try to do this in the load editor the value always stays as the timestamp value.

    Am I doing something wrong?

    Show Less
  • forum

    App Development

    Chart Exploration / how to get dimension list

    Hello, I would like to use the “Chart Exploration” feature of the new version of the “Straight Table” object. It works very well, I just have a questi... Show More

    Hello, I would like to use the “Chart Exploration” feature of the new version of the “Straight Table” object. It works very well, I just have a question: is it possible to
    1) allow users to swap columns but not to remove dimensions / measures
    2) otherwise, is there a simple way to retrieve the list of active dimensions? (my problem is that I have complex calculation functions with aggr requiring to know the list of dimensions used).

    Best regards

    Show Less
  • forum

    Visualization and Usability

    Working with categorical columns in Qlik sense.

    Hi All, Could someone please advise me on how to do the below mentioned one in Qlik sense .- I have a table with 10 columns in that two columns (colum... Show More

    Hi All,

    Could someone please advise me on how to do the below mentioned one in Qlik sense .

    - I have a table with 10 columns in that two columns (column1 , column 2 ) are having 10 categories each  and both columns are having same categories.
    And there is one more column called sales   which contains sales numbers. Also, I have created a variable input drop down box which contains values like name, year, and location.
    How can I create a table in Qlik sense with first column as drop-down box values and then horizontally two headers with Column 1 and Column 2 and then under that 10 categories and for each category how can I do summation of sales.

     

    Thanks in advance 🙂

    Show Less
  • forum

    Connectivity & Data Prep

    Connectivity between Office 365 SharePoint and Qlik Sense

    Hi, I'm using Qlik Sense May 2024 Version. I need to access the Office 365 SharePoint from Qlik Sense.  Kindly suggest how to create connections, what... Show More

    Hi, I'm using Qlik Sense May 2024 Version. I need to access the Office 365 SharePoint from Qlik Sense. 

    Kindly suggest how to create connections, what could be the Base URL and Prompt/Consent level etc. 

    Show Less
  • forum

    Visualization and Usability

    Sum - only if Sum greater - without if

    Hi,I have a table with data.Employees and I want to display only all employees who have more than 10:00.So I need the sum of datafield.az if the sum o... Show More

    Hi,

    I have a table with data.Employees and I want to display only all employees who have more than 10:00.

    So I need the sum of datafield.az if the sum of datafield.az it is greater than 10:00 (hh:mm).

    I can't use "if" because otherwise not only the dimensions of employees above 10:00 would stop, but also others.

    Can you help me, please?

    Show Less
  • forum

    Application Automation

    Writeback Automation Fails with "The required inputs were not received" Error (V...

    Hi everyone,I'm trying to set up a writeback automation in Qlik Cloud that takes user selections and writes a comment to a separate data store (like a... Show More

    Hi everyone,

    I'm trying to set up a writeback automation in Qlik Cloud that takes user selections and writes a comment to a separate data store (like a Google Sheet or SharePoint list). However, I'm encountering the following issue:

    "The required inputs were not received."

    Here's my current setup:

    • I have input fields bound to variables (e.g. vComment, vID, ...) that populate correctly based on user selection. The variables are dynamically updated when a row is selected in a Qlik table.

    • I created a button that triggers the automation. I enabled "Include selections" and "Execute in triggered mode."

    • In the automation, I use a "Copy Inputs" block to receive the variable values.

    • However, the automation fails immediately with the error above and shows no logs or steps executed.

    What I’ve tried:

    • Replacing dynamic expressions like =IDwith intermediary variables (vID2) and copying them into static ones (vID) using "Set Variable" actions before triggering the automation.

    • Ensured the button is correctly configured to execute the automation and that my selections yield a single row.

    Additional Information:

    • Other automations (e.g. reloading apps) work fine.

    • The app is published in Qlik Cloud.

    • I'm following this video https://www.youtube.com/watch?v=hYER2nGKctM&ab_channel=Qlik and I'm getting the error half way when I try to update (around 9min30 sec in the video).
    • Even with only these blocks, I get the error
      Dat_1-1745308831595.png

       

       

    Has anyone faced this before or knows how to fix the “required inputs not received” error when using dynamic variables and selections?

    Thanks in advance! 

    #Qlik Application Automation  

     

    @AfeefaTk 
    @PietMichielRappelet 

    Show Less
  • forum

    QlikView App Dev

    using month-year as dimension need to show previous 3 months data excluding curr...

    hello,I have requirement to show previous 3 months data excluding current month in table chart month-year as dimension.i am using below set expression... Show More

    hello,

    I have requirement to show previous 3 months data excluding current month in table chart month-year as dimension.

    i am using below set expression

    =Sum({1<DATE={">=$(=MonthStart(AddMonths(Max(DATE),-3)))<=$(=MonthEnd(AddMonths(Max(DATE),-1)))"}>}[SUBS_GROSS_ADD])

    it is working for text object respective of selection.but in table chart i have four aggregation fields based on moth-year dimension and only for one aggregation i have to show previous 3 months excluding current month so i am using above set expression for that but it is not working.it is giving month wise aggregation instead of previous 3 months results.how can i achieve this in table chart with dimension.

    please help on same.

    Thanks in advance.

    Show Less
  • forum

    Application Automation

    Stop Automation Block (Qlik Cloud Services)

    Hi all, For the stop automation block how do you get the block to parse the value of the current RunID?  The automation ID is static as I would just u... Show More

    Hi all,

    For the stop automation block how do you get the block to parse the value of the current RunID?  The automation ID is static as I would just use this automations' ID

    Essentially I want the current automation to end when a condition is met but I'm having trouble getting this value.

    Thanks

     

    rx98u5pq_0-1744729739629.png

     

    Show Less
  • forum

    App Development

    Set analysis sur un champ date

    Bonjour,  Je voudrais faire un set analysis qui me renvoi le nombre de vente réalisé par un opérateur depuis la dernière date possible.J'ai fais ce se... Show More

    Bonjour, 

     

    Je voudrais faire un set analysis qui me renvoi le nombre de vente réalisé par un opérateur depuis la dernière date possible.

    J'ai fais ce set  " =Sum({$<[TRL-DATMVT]={'=$(max(TRL-DATMVT)-1)'}>}[TRL-QTEUV]) " et le résultat me renvoi 0.

    Alors que je devrais avoir 179 

    Pouvez-vous m'aider svp ?

    sebios_0-1744980534593.png

     

    Show Less
  • forum

    Visualization and Usability

    How to connect to a database with "ReadOnly" option

    I have ReadOnly access to MsSql database. I am not able to connect using Qlik MsSql connector because by default Qlik has "ReadWrite" as connect optio... Show More

    I have ReadOnly access to MsSql database. I am not able to connect using Qlik MsSql connector because by default Qlik has "ReadWrite" as connect options.

    Is it possible to change "ReadWrite" to "Read" option in data load editor or in QMC --> data connection?

    I know I can ditch the Qlik MsSql connector and use ODBC connector and in Windows configure it by including "Application Intent" as "READONLY". But this would eventually result in our organisation using only windows ODBC drivers instead of any of the Qlik connectors.

    I think "QvxConnectOptions" type is responsible for this Qlik default behavior. Is it advisable to change that file? do you know where I can find this file related to mssql connector?

    If this is not possible, please let me know your opinion.

    Show Less
Leaderboard

Customer Story

Optimizing Food Relief with Qlik

Qlik empowers Foodbank Victoria with real-time data insights, optimizing food acquisition and distribution to deliver 25 million meals annually while reducing waste and costs across its statewide relief efforts.

Customer Story

Data-Driven Strategies Set To Fuel Growth

Qlik accelerates decision-making at Alpha Auto Group, enabling seamless data integration and automation across dealerships, cutting reporting times, and driving scalable business growth.

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!