Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 249,599 members
  • 5,360 online
  • 2,032,067 posts
  • 152,989 Solutions

Welcome to Qlik Community

Recent Discussions

  • No Boards Found
  • forum

    App Development

    Set analysis on concatenated fact data

    Hi,I have fact data that needs to be concatenated and because of several reasons I cannot join the columns. So for the example below I would like to c... Show More

    Hi,

    I have fact data that needs to be concatenated and because of several reasons I cannot join the columns. So for the example below I would like to calculate with Set analysis the number of issues per Category, but it should calculate as follows:

    for Category A : 2 (Issue X and Y) + 1 (Issue linked through Order M)

    I believe it is possible with P function in Set analysis, but I cannot succeed with it.. appreciate any help

    justalkak_0-1745333593849.png

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Qlik Replicate

    Qlik Replicate Source IBM DB2 for iSeries port connection

    Hi,I have a connection source in replicate using IBM DB2 for iSeries, and use these connection properties with IP address,Is posible configure the IP ... Show More

    Hi,
    I have a connection source in replicate using IBM DB2 for iSeries, and use these connection properties with IP address,
    Is posible configure the IP address and especified a port number to connection?

    thanks,

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Application Automation

    Why is the 'Open File' block deemed third party?

    I am using the 'Open File' block to pull a file from an app's content library (via HTTP), and automations is deeming this a third-party block?I've tri... Show More

    I am using the 'Open File' block to pull a file from an app's content library (via HTTP), and automations is deeming this a third-party block?

    I've tried with the Raw API Request block using
    apps/{APP_ID}/media/files/{FILENAME}.png
    as the path, but it returns nothing. I'm assuming because per the API docs, it's expecting the --o tag, which I can't add in the block?

    Is there a better way to do this?
    Maybe a dev request to have 'Qlik Cloud Services' added to the connector options in the Open File block?

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    Styling New Straight Table With Custom Theme

    Within the "New" Straight Table, is it possible to use a custom theme (within the JSON file) to set default styling on the Header, Dimension Values, M... Show More

    Within the "New" Straight Table, is it possible to use a custom theme (within the JSON file) to set default styling on the Header, Dimension Values, Measure Values, Total Row, etc.?

    I was able to deduce that the object's reference is sn-table and am able to customize the "Main" section (Headers, footers, etc.) but I haven't been able to locate any documentation for the rest of the Styling options.

    I imagine the format would be something like this, but no combinations/arrangement that I've tried seem to work

    "sn-table": {
    "dimension":{
    "values":{
    "fontSize":"16px",
    "color":"#FFFFFF",
    "background":"#326F91"
    }
    }
    }

     

    Any assistance would be much appreciated. Thanks in advance!

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Application Automation

    Is it possible to schedule Qlik Cloud Monitoring Apps Installer?

    I am using the Qlik Cloud Monitoring Apps Installer automation to install new versions of the various monitoring Apps.  I wanted to add a schedule to ... Show More

    I am using the Qlik Cloud Monitoring Apps Installer automation to install new versions of the various monitoring Apps.  

    I wanted to add a schedule to this automation, but since the automation requires Input, when I add schedule details, it fails with the message I have attached as pic

    I am also very new to this, so it's probably something fundamental that I am missing. Has anyone done this successfully?  If yes, any/all guidance would be truly appreciated. 

    Thank you

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Japan

    円グラフに頻度と%の両方を同時に表示する方法

    お世話になっております。現在、Qlik Senseで円グラフを作成しており、「頻度(count)」または「割合(%)」のどちらか一方しか表示できない状況です(マウスオーバーすれば両方見られます)。これを、頻度と割合の両方を同時にラベルとして表示する方法はありますでしょうか?理想としては、以下のような... Show More

    お世話になっております。
    現在、Qlik Senseで円グラフを作成しており、「頻度(count)」または「割合(%)」のどちらか一方しか表示できない状況です(マウスオーバーすれば両方見られます)。
    これを、頻度と割合の両方を同時にラベルとして表示する方法はありますでしょうか?

    理想としては、以下のような形式で改行を入れて表示したいと考えております:

    xx
    (xx.x%)
     

    ラベルの表示位置やグラフの形(円グラフ or ドーナツグラフ)については特にこだわりはありません。表示位置も、円の内側でも外側でも構いません。

    なお、countを使ってグラフを作成していますが、
    たとえば以下のような数式で対応できるかどうかも検討しています:

    count([xxx]) & count()/sum() & "%)"

    もし他に適切な方法や推奨されるやり方がありましたら、ご教示いただけますと幸いです。
    どうぞよろしくお願いいたします。

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    Limiting Denominator to only dates where numerator has a value

    Need some help with a formula. We have a dashboard that shows KPIs for sales and transactions data by discount code. On this dashboard the users can f... Show More

    Need some help with a formula. 

    We have a dashboard that shows KPIs for sales and transactions data by discount code. On this dashboard the users can filter through different discounts and see information such as sales, transactions, unique customers, etc. They also want to see discounted sales as a % of total sales on the days where there was a transaction with that discount code used.

    This is where I'm having some trouble. If we just look at calculating the denominator, I need a formula that takes every transaction in the days that there was a transaction for the selected discount codes.

    Here's an example of what I'd want:

    Date Discount Code Transaction ID Sales

    4/24/2025,   Discount-A,   111,    $10

    4/24/2025,   N/A,               112,   $15

    4/23/2025,   Discount-A,   113,    $12

    4/23/2025,   N/A,               114,    $11

    4/22/2025,   N/A,               115,    $9

     

    This is what I've tried as a formula for the denominator:

    IF(GetSelectedCount([Discount Code])>=1,
    sum({$<[Discount Code]=>}Sales)
    )

    For this I would want the sum of sales for 4/23/2025 and 4/24/2025, excluding the sales from 4/22/2025. So the total should be $48. The formula actually gives me a value of $57. I was thinking I need something like:

    Only({<SUM(Sales)>={1}>} Date)

    in the set analysis. That should work because this KPI has a condition to only show if a selection is made in the discount filter. When no selection is made all the KPIs on the page are blank (intended).

    Any ideas on this?

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Talend Cloud

    Talend jobs getting failed while running in TMC

     Hi teamI am not able to run the jobs in TMC as I am getting the following error:There was an error with the engine. Contact an infrastructure adminis... Show More

     

    Hi team

    I am not able to run the jobs in TMC as I am getting the following error:
    There was an error with the engine. Contact an infrastructure administrator to review the status of the engine.

    The jobs were running fine without any issues till last day. Please let me know how this issue can be rectified.

    Thanks

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Qlik NPrinting

    NPrinting Server : .net 4.8 installation error

    Hi All, I'm setting up new Server for NPrinting as my old server was on Windows 2016. I'm trying to install .net 4.8 in new Server,it doesn't have Npr... Show More

    Hi All,

    I'm setting up new Server for NPrinting as my old server was on Windows 2016.

    I'm trying to install .net 4.8 in new Server,it doesn't have Nprinting Server/Engine installed.

    I'm getting error while installing the .net framework 4.8 for windows 2019 server

     Error message: 0x80092004 -can not find object or property

    Can anyone suggest what could be the issue?

    Error is attached.

    Thanks in advance

    Qlik NPrinting  

     

     
    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Application Automation

    Export all the variables with automation

    Hi,I would like to export all my variables in the app to Excel file. How can I do with the automation in Qlik cloud ?   Opens in new windowPDF Downloa... Show More

    Hi,

    I would like to export all my variables in the app to Excel file. 

    How can I do with the automation in Qlik cloud ? 

     

     
    Opens in new window
    PDF Download
    Word Download
    Excel Download
    PowerPoint Download
    Document Download
     

     

     
    Opens in new window
    PDF Download
    Word Download
    Excel Download
    PowerPoint Download
    Document Download
     
    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Weekly 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.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!