Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 235,458 members
  • 3,840 online
  • 2,019,088 posts
  • 151,663 Solutions
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    Dimensional Count Distinct

    hi to all and thank in advance for you time.   I have the following calculations   FieldA FieldB time   I need to     count( distinct  [id] ) cou... Show More

    hi to all and thank in advance for you time.

     

    I have the following calculations

     

    FieldA FieldB time   I need to
        count( distinct  [id] ) count (distinct total <[time]> [id])  ????
    ValueA   70 100 100
      TypeA 40 100 10
      TypeB 50 100 20
      TypeC 60 100 30
      TypeD 10 100 40
    ValueB   100 100 100
      TypeA 10 100 10
      TypeB 20 100 20
      TypeC 30 100 30
      TypeD 40 100 40

     

    I need to have the distinct total for any dimension I expand as in the example

     

    Thank u!

    Show Less
  • forum

    Move to SaaS

    Simplifying Qlik Sense Deployments & Migrations With Soterre 3.0

    Let’s talk about a problem we all know too well: getting deployments and migrations right in Qlik Sense. It’s one of those things that sounds simple, ... Show More

    Let’s talk about a problem we all know too well: getting deployments and migrations right in Qlik Sense. It’s one of those things that sounds simple, but once you start scaling, plans can go off the rails fast. Maybe you’ve dealt with the chaos of inconsistent deployments, struggled with managing multiple data sources, or felt the pain of moving everything to Qlik Cloud. If you’re nodding along, trust me, you're not alone.

    Now, imagine having a tool that actually makes this stuff easier — that’s where Soterre for Qlik steps in. Soterre 3.0 is like your secret weapon for cutting through the noise and chaos of complex Qlik operations. With its new deployment plans, you can kiss the headaches of manual processes goodbye. It gives you a clean, automated way to manage deployments across environments without worrying about mistakes that eat up your time.

    Making the jump to Qlik Cloud? Soterre’s got your back there, too. Instead of wrestling with clunky migrations and endless manual tweaks, the 3.0 release makes the process super smooth. It connects your existing data sources to the cloud with minimal effort. You can finally stop sweating the details and let Soterre handle the heavy lifting.

    One of the coolest parts? The live deployment wizard now syncs up with your ticketing system. That means you get better tracking and accountability built right into your workflow. And for those of us who like to test before we leap, the new simulation services let you see how things will run in Qlik SaaS before making anything official. It’s like having a safety net that ensures your changes work exactly as planned.

    With Soterre 3.0, you’re not just getting a tool—you’re getting a smoother, more reliable Qlik experience. It takes the stress out of deployment, automates your workflows, and helps your team focus on what really matters: delivering insights that make an impact. Ready to see what Soterre can do for you? Dive in and see how much easier your Qlik journey can be.

     

    Learn More 

    Show Less
  • forum

    Integration, Extension & APIs

    Extension for Multi Echelon Sankey Diagrams

    Does Qlik offer an extension for multi-echelon Sankey diagrams? I searched online and found that Qlik used to have a Trusted Extension Developer Progr... Show More

    Does Qlik offer an extension for multi-echelon Sankey diagrams? I searched online and found that Qlik used to have a Trusted Extension Developer Program which resided at Qlik Branch but it seems that this doesn't exist anymore. Where can I locate the trusted extensions? Are there any Sankey extensions that you would recommend?

    Show Less
  • forum

    New to Qlik Analytics

    Estoque sem Movimentação em 30, 60, 90 e acima de 90 dias

    Pessoal,      estou com dificuldade em ter um totalizador na expressão (criar uma expressão com o valor total, sem aparecer o produto) que eu possa sa... Show More

    Pessoal,

         estou com dificuldade em ter um totalizador na expressão (criar uma expressão com o valor total, sem aparecer o produto) que eu possa saber os valores de estoque sem movimentação, exemplo.

    30 dias                       60 dias                     90 dias                      Acima de 90 dias
    R$ 560.000,00           R$ 380.000,00         R$ 170.000,00          R$ 68.000,00

     

    O SQL é o seguinte:

    // ----------- Movimentos ---------- //
    LOAD *,
    YEAR(MOV_DATA_S) AS ANO_MOV,
        MONTH(MOV_DATA_S) AS MES_MOV,    
        DATE(MOV_DATA_S) AS DATA_MOV,
        DAY(MOV_DATA_S) AS DIA_MOV,     
        YEAR(IF(MOV_ORIGEM_S = 'NTC', MOV_DATA_S)) AS ANO_NTC,
        MONTH(IF(MOV_ORIGEM_S = 'NTC', MOV_DATA_S)) AS MES_NTC,
        DAY(IF(MOV_ORIGEM_S = 'NTC', MOV_DATA_S)) AS DIA_NTC, 
        YEAR(IF(MOV_ORIGEM_S = 'RQO', MOV_DATA_S)) AS ANO_CONS,
        MONTH(IF(MOV_ORIGEM_S = 'RQO', MOV_DATA_S)) AS MES_CONS,
        DAY(IF(MOV_ORIGEM_S = 'RQO', MOV_DATA_S)) AS DIA_CONS;
        
      
          
    SQL SELECT
    MAX(MOV_DATA) as MOV_DATA_S,
    MOV_PRO_CODIGO AS PRO_CODIGO_S,
    MOV_ORIGEM as MOV_ORIGEM_S
    FROM PRODUTOS_MOVIMENTOS_F WHERE MOV_FIL_CODIGO = '4' AND MOV_ORIGEM IN ('EPA','NTC','INV','RQO')
        
    GROUP BY MOV_DATA, MOV_PRO_CODIGO, MOV_ORIGEM;
        
        
       
     
     
    [Estoque_4]:
    SELECT PRODUTOS.PRO_CODIGO as PRO_CODIGO_S,
           PRODUTOS.PRO_RESUMO as PRO_RESUMO_S,
           PRODUTOS.PRO_CUSTOFISCAL as PRO_CUSTOFISCAL_S,   
           PRODUTOS.PRO_CUSTOCOMPRA as PRO_CUSTOCOMPRA_S,             
           PRODUTOS.PRO_SITUACAO as PRO_SITUACAO_S,
           PRODUTOS.PRO_TIPO as PRO_TIPO_S,
                   
           SUM(PMF.MOV_QUANTIDADE * PMF.MOV_TIPO) AS PRO_SALDO_S
      FROM PRODUTOS_MOVIMENTOS_F PMF
    INNER JOIN PRODUTOS ON (PMF.MOV_PRO_CODIGO = PRODUTOS.PRO_CODIGO)
      LEFT OUTER JOIN FILIAIS ON (PMF.MOV_FIL_CODIGO = FILIAIS.FIL_CODIGO)
    WHERE (PMF.MOV_DATA <= '31.12.2024')
       AND (PMF.MOV_FIL_CODIGO IN ('4'))    
    GROUP BY 1,2,3,4,5,6;
     
     
    SELECT
        PRODUTOS.PRO_CODIGO AS PRO_CODIGO_S,
        
    (SELECT CUSTO_MP_PA_REAL.FISCAL FROM CUSTO_MP_PA_REAL (PRO_CODIGO)) AS CUSTO_FISCAL_FICHA
    FROM PRODUTOS WHERE PRO_TIPO IN ('PE','BN');
     
     
     

     

     

    Show Less
  • forum

    New to Qlik Analytics

    showing legend and color by expression

    hello  could you please advise me I'm Tring to us bar chart graph and i want to show legend on the same time color by expression, i used drilldown in ... Show More

    hello 

    could you please advise me I'm Tring to us bar chart graph and i want to show legend on the same time color by expression, i used drilldown in my graph 

    thank you 

    Show Less
  • forum

    App Development

    How to get auto generated countryAliases.qvd and countryGeo.qvd in managed space...

    Hi, I have some data that includes countries and cities and when I used the data manager in my app it creates the files countryAliases.qvd and country... Show More

    Hi,

    I have some data that includes countries and cities and when I used the data manager in my app it creates the files countryAliases.qvd and countryGeo.qvd in the same space as the app. In this case a shared space which I use to develop and improve my app.
    All this is good and the maps look nice.

    Now I need to publish my app and when I reload it through API it complains that it doesn't have access to the files located in the shared space, which it shouldn't.

    Can I get the app to create the files in the managed space somehow?

    If not, can they be copied easily between spaces and tenants somehow? 

    Kind regards
    Johan

    Show Less
  • forum

    App Development

    Export horizontally straight table into excel

    Hi, I'm not very experienced in QlikView and I need help to export a  Horizontally straight table into excel keeping the horizontal data.  If I send t... Show More

    Hi, I'm not very experienced in QlikView and I need help to export a  Horizontally straight table into excel keeping the horizontal data. 

    If I send this table to excel

    paolojolly_0-1730365827821.png

    by clicking XL button, on Chart caption I get

    paolojolly_1-1730365900715.png

    I can export to Excel and open the Paste Special dialog box, then select Transpose.... but my boss doesn't want to this way.

    I cannot change chart type into pivot because I have a more complex chart that will use this solution.

    Can someone help me?

    Thanks

     

     

    Show Less
  • forum

    App Development

    Find the next equal value

    Hello all, I would like to be given the next date when the key plant will be the same again. The key is clear, there are other movements in this examp... Show More

    Hello all,

    I would like to be given the next date when the key plant will be the same again.

    The key is clear, there are other movements in this example that are not considered here at the moment.

    Just6_0-1730730797677.png

    Here are all the movements.

    Just6_1-1730730910554.png

     

    Thanks and Regards

    JD!

     

    Show Less
  • forum

    App Development

    Qlik SaaS - Display user name in an app

    HI Everyone  In Qlik SaaS does anyone have any idea how I can display the name of the user in Qlik SaaS. I'm creating a welcome screen in-app and want... Show More

    HI Everyone 

    In Qlik SaaS does anyone have any idea how I can display the name of the user in Qlik SaaS. I'm creating a welcome screen in-app and want their first name (ideally). 

    I tried setting a variable LET vUser = OsUser; but this just return the user ID rather than the name. 

    Can someone offer some help on this? 

     

    Thanks

    Stuart

    Show Less
  • forum

    Qlik AutoML

    Qlik AutoML Preprocessing Explained

    Hello Qlik Community, Have you ever wondered what is behind Qlik AutoML processing tasks (Imputation of nulls, encoding categorical features, etc.)? W... Show More

    Hello Qlik Community,

    Have you ever wondered what is behind Qlik AutoML processing tasks (Imputation of nulls, encoding categorical features, etc.)? Well, a lot of people do. That's why I wrote this article. I hope you like it.

    Qlik AutoML Preprocessing Explained

     

    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!