Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 217,743 members
  • 11,231 online
  • 1,995,677 posts
  • 149,565 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    Administering and Monitoring

    Talend 7.3.1 (Desktop software) - FIPS 140-2 Encryption

    Hi ,  We are using Talend enterprise version - Talend 7.3.1 (Desktop software) . We would like to implement FIPS 140-2.  Is this version FIPS 140-2 co... Show More

    Hi , 

    We are using Talend enterprise version - Talend 7.3.1 (Desktop software) . We would like to implement FIPS 140-2.  Is this version FIPS 140-2 compliant? If not please share the Talend version with FIPS 140-2 encryption.

    Any guidance would be appreciated.

    Thanks

    Show Less
  • forum

    New to Qlik Analytics

    Saving Data in excel file (.xlsx) from Data Load Editor

    Hello, I am trying to export data into excel file (with .xlsx) as extension. The file gets created but gives the error (attached below).  The script I... Show More

    Hello, 

    I am trying to export data into excel file (with .xlsx) as extension. The file gets created but gives the error (attached below). 

    The script I am using is: 

    STORE Output INTO [\\FolderPath\Output.xlsx];

    I also tried:

    STORE Output INTO [\\FolderPath\Output.xlsx] (txt);

    But neither of statements seems to work. When I save as .csv, the file gets saved properly. But, I need to save file as .xlsx.

    Is there a solution to this issue? Or does Qliksense not support .XLSX? 

    Thanks,
    Devraj

    Error.PNG

    Show Less
  • forum

    New to Qlik Analytics

    When I select on year-month filter bar char should not affect.

    Hi Everyone, so I have one filter year-month and one chart with ageing, So ageing chart should not affect when I click on year-month I have provided t... Show More

    Hi Everyone, so I have one filter year-month and one chart with ageing, So ageing chart should not affect when I click on year-month I have provided the expression But the problem is it is changing the sorting order of dimension that's the only problem, Otherwise it is working perfectly so How should I stop it, I have tried everything in properties.
    Expression used in measure: Sum({<[YEAR_MONTH]=, [BUCKETS]-={'-', null} >} [GEO_AVG_PRICE] * [GEO_QTY]) / 1000 
    without selection of year month order of chart

    Lucius_Artorius_Castus_0-1714028333250.png


    After selection of filter (order is reversed which should not happen):

    Lucius_Artorius_Castus_1-1714028386016.png

    Let me know how can I stop sorting change.
    Thanks,
    Lucious Arotorius Castus

    Show Less
  • forum

    App Development

    Bar chart question.

    Hello, Hive Mind, I need your help! I need a Barchart that allows me to format the color of the bars independently via different measures. My example ... Show More

    Hello, Hive Mind, I need your help! I need a Barchart that allows me to format the color of the bars independently via different measures. My example is displaying the productivity of a machine operator vs his goals for a shift. The goal will be a constant - set within the load script, and the customer wants it to be Green, while the other measure is the number of units produced, which needs to be red until it reaches the same value as the goal, at which time it should turn green.

    With the standard Barchart included with Qlik sense, I can use the color by Expression to do what is needed for the units produced, but cannot find a way to color the Goal bar a different color while the units produced is Red. 

    Anyone have an idea or seen an extension that will allow this?

    Show Less
  • forum

    Qlik NPrinting

    N Printing Display Images from Qlik Sense Straight Table

    Hello, We are displaying images of our products in a straight table using the image option released in August 2021. When we created a N Printing repor... Show More

    Hello,

    We are displaying images of our products in a straight table using the image option released in August 2021. When we created a N Printing report, the image field displays as the image path. Are images in tables supported in N Printing? 

    In the past, we used a QlikView connection and  used our product as a level and then added a report with images and a report with data. Is there a simpler way to do this?  If not, will this same approach work in Qlik Sense?

    Show Less
  • forum

    New to Qlik Analytics

    Is a Unique Key necessary?

    Is a Unique Key necessary for every table in the data model? My model doesn't but the calculations in the dashboard seems fine.
  • forum

    App Development

    QLik Sense - ODAG Error

    Hello, I want to develop the ODAG application, but when I load the script, the text "WHERE mixmatch([CustID],{"quote": "") " appears on the screen. Ca... Show More

    Hello,

    I want to develop the ODAG application, but when I load the script, the text "WHERE mixmatch([CustID],{"quote": "") " appears on the screen. Can you help me? I added the codes.

    Thanks,

    learnergirl_0-1714033114210.png

     

    Show Less
  • forum

    New to Qlik Analytics

    Qlik Button Help

    Hi All,I have 4 below conditions for each Filter panes=If(CNLevelOrder < 14, CNLevelSelect)=IF(CNLevelOrder<28 and CNLevelOrder>13, CNLevelSelect)=IF(... Show More

    Hi All,


    I have 4 below conditions for each Filter panes

    =If(CNLevelOrder < 14, CNLevelSelect)

    =IF(CNLevelOrder<28 and CNLevelOrder>13, CNLevelSelect)

    =IF(CNLevelOrder<40 AND CNLevelOrder>27, CNLevelSelect)

    =IF(CNLevelOrder>39,CNLevelSelect)

    The filterpanes will have CNSelect column values

    Now, I have to create 2 buttons for above filters , one button as Select All CN Level and other button as Deselect All CN Level

    if i click Select All CN Level button it should select all the values from 4 filter panes

    How can I do that?
    Please help


    Show Less
  • forum

    New to Qlik Analytics

    Accumulate and calculate running numbers from ingoing balance and running change...

    Hi, I'm working on financial KPI's and want to use the balance sheet as well as the P&L for analysis. The differences is that in the balance sheet you... Show More

    Hi,

    I'm working on financial KPI's and want to use the balance sheet as well as the P&L for analysis.

    The differences is that in the balance sheet you have an ingoing balance and then the changes during the month is booked and then you get an outgoing balance, in my dataset there is no ingoing balances available from the database from any tables that I've found.

    I want to to a rolling 12 months analysis on inventory turnover rate and need to be able to calculate averages for a twelve months period every month ending to get this KPI. 

    I've added the ingoing balance for 2021-05-01 manually and concatenated with the transaction data, from this I can get an outgoing balance every month with RangeSum and Above where I've set period of times to 100000, (maybe there is a smarter way) which gives me the outgoing balance every month.

    RangeSum(Above(Sum({<Sub_Group={'Inventory'}>}Amount),0,100000),)

    How do I use this? I need to bring the value from 2021-05-01 to 2024-03-31 for example to be able to get my outgoing balance for 2024-03-31, see example below.Qlikbild.png

    Is there a way to make a calculated field instead to use in set analysis or any other way that is more simple just shoot with ideas!

    Help much appreciated, thanks!

     

    Show Less
  • forum

    New to Qlik Analytics

    Multiple Single Select (Always one selected)

    In our system, there are two single select fields with a parent-child relationship. Selection of the parent with single unique child is not possible, ... Show More

    In our system, there are two single select fields with a parent-child relationship. Selection of the parent with single unique child is not possible, because that particular child selection is not possible as its unique and is not available for the currently selected parent and that particular parent selection  is not possible as it has only one child.Is there a solution that allows users to make this selections.

    And even if the selection is made possible by default , it creates a locked scenario where the user cannot alter the selection. This occurs because the parent has only one child, leaving no other options available. Is there a solution that allows users to make different selections in this scenario.

    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!