Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
6,720 online
Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER

Find the forums for your Qlik data analytics products to ask a question, start a discussion, or review documentation.

Find the forums for your Qlik Data Integration products to ask a question, start a discussion, or review documentation.

Welcome to the Qlik Alerting Product Forum! Join in on the discussion around Qlik’s intelligent alerting solution for Qlik Sense! This is an open group to share and collaborate!

Participate in Qlik Technical Previews, submit ideas, and review documentation.

Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.

Learn about the Qlik Community. Explore 'How-To' documentation, ask questions, and engage in discussion around the community platform. This will also be the place where, from time to time, we will do some fun things.

Learn about upcoming Qlik related events, webinars and local meetups.

Join one of our Qlik Community Groups. Anyone can view content in Open Groups, but you must join to participate. Closed Groups require joining in order to view content and participate.

Hear directly from Qlik employees in our ten unique blogs. Check out the new Product Insight & Ideas Blog!

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

Recent Discussions

  • No Boards Found
  • forum

    Qlik Brasil

    Comparativo de Venda Por Períodos

    Bom dia Pessoal.Criei Uma Tabela para comparar como mesmos OS vendas Pará Clientes em periodos Distintos, minha Dimensão de Cliente E hierárquica de M... Show More

    Bom dia Pessoal.

    Criei Uma Tabela para comparar como mesmos OS vendas Pará Clientes em periodos Distintos, minha Dimensão de Cliente E hierárquica de MoDo Que Posso ir escavando uma analise Ate O Nível de Produto (Cliente> Grupo da Marca> Seguimento da Marca> PRODUTO) e para representar como vendas do Ano Atual eu utilizo um Seguinte Expressão: Sum ({$ <Ano = {$ (= (Max (Ano)))}>} [total]) e para analisar a Venda do ano utilizo eu anterior: Sum ({ $ <Ano = {$ (= (Max (Ano) -1))}>} [total]).Vale Lembrar Que Total E o Nome do Meu campo para Receita total. Tenho Uma Terceira Expressão Que Calcula a Variação de hum ano para o Outro e Todas ELAS me atendem Até Certo Ponto, o Problema ESTÁ justamente when Avanço UM NIVEL na Minha escavação, Quando seleciono UM CLIENTE that NAO TEVE de Venda há ANO Atual (2018) mas Teve nenhum ano anterior (2017) com intuito de enxergar oque deixamos de vender para Ele, como vendas fazê ano anterior Nesse Segundo Nível estao aparecendo como ano Atual. Uma Informação Adicional E that ISSO Só ocorre when a Venda do ano Atual ESTÁ zerada. Como solucionar Esse Problema? Abaixo Imagens that ilustram Melhor oque tentei explicar, junto as imagens que podem ser úteis para vossa analise e anexo de um modelo de dos dados que estou utilizando:

    Cliente 1.PNGCliente 2.PNGModelo 1.PNGModelo 2.PNGModelo 3.PNGModelo 4.PNG


    Show Less
  • forum

    Qlik Brasil

    Conversão de Texto p/ Número

    Olá,Estou trabalhando com arquivos txt de posição fixa e vem um campo com valor que preciso interpretar como número.Já tentei algumas soluções propost... Show More

    Olá,

    Estou trabalhando com arquivos txt de posição fixa e vem um campo com valor que preciso interpretar como número.

    Já tentei algumas soluções propostas em outros tópicos sem sucesso. A última sintaxe tentada foi:

    num#("@181:197", '#,##0.00') as Exec_Valor_Pedido,

    O resultado foi que os valores continuaram como texto:

    pedromsouza_0-1603742301939.png

    Não eliminou os zeros à esquerda.

     

    Alguma sugestão?

     

    Grato.

    Show Less
  • forum

    QlikView App Development

    AGGR Sum Function does not display for each Row

    Hello Qlik!I am trying to create an AGGR Summary table of the total representatives located by region by their department where they represent greater... Show More

    Hello Qlik!

    I am trying to create an AGGR Summary table of the total representatives located by region by their department where they represent greater than or equal to 50% of the entire organization department.

    For Example EU has 30 reps for distribution out of 37 total for the 'Deptlvl4' column.  

    Deptlvl2Deptlvl4RegionRepsGrand TotalT/F
    BuildDistributionAP237False
    BuildDistributionEU3037True
    BuildDistributionNA537False

     

    However I am unable to get Qlik to display/process the data correctly.  It will display 'Nulls' for 2 of the 3 rows.

    Qlikview Table (see attached for example)

    Deptlvl2Deptlvl4RegionRepsGrant TotalT/F
    BuildDistributionAP237FALSE
    BuildDistributionEU30-FALSE
    BuildDistributionNA5-FALSE

     

     

    Show Less
  • forum

    Qlik Sense SaaS & Multi-Cloud

    Auth0 auth for QS Server and Qlik Cloud - 2 accounts for the same user

    Hello,I use Qlik Sense Entreprise and Qlik Sense Cloud.Auth0 is used to authenticate he on premise server and the cloud.When I log to the cloud, my ac... Show More

    Hello,

    I use Qlik Sense Entreprise and Qlik Sense Cloud.
    Auth0 is used to authenticate he on premise server and the cloud.

    When I log to the cloud, my account is retrieved as auth0|xxxxxxxxxxxxxx
    When I log to the Qlik Sense server (to the appropriate Virtual Proxy) with this same user, my account is retrived as my email address.

    So there is no match between the cloud and the on premise server and 2 accounts for the same user. it's a problem for the user licence.

    Can somebody help me to use the same way for the 2 platforms?

    Maybe something to change in the virtual proxy?

     

    Regards

    Fab

    Show Less
  • forum

    Qlik Sense App Development

    Not equal <> is not working at script level varaible

    below expression is not working at script level.LET vWeek_End_Not <> date(max(week_ending)-7,'DD/MM/YYYY')
  • forum

    Qlik Sense App Development

    Quarter Year conversion creating dates with decimals

    Hi Everyone, In my app we have a date field that I am needing to convert to a Quarter Year formatso for a date of 2019 - 05 - 01 - 00:00:00 I am expec... Show More

    Hi Everyone, 

    In my app we have a date field that I am needing to convert to a Quarter Year format

    so for a date of 2019 - 05 - 01 - 00:00:00 

    I am expecting to get a value of Q2-2019

    However based on the expression I have, I am getting Q1.6666666666667 - 2019 

     

    The expression I am using: 

    if(isnull(DATEFIELD),null(),'Q'&Ceil(month(date(left(DATEFIELD,11),'MM)))/3&'-'&Date(left(DATEFIELD,11),'YYYY'))

     

    Is there something I am doing wrong in my expression. There are some values where I am getting whole numberd for the quarter dates, but most of the values seem to be having the quarter date in decimals. 

    Show Less
  • forum

    New to Qlik Sense

    Percentage on Y axis for a bar chart using Set Analysis and Total function

    load * Inline [Responsible Person, Phases, ValueTom, Phase 1, 30Tom, Phase 2, 20Tom, Phase 3, 50Jack, Phase 1, 10Jack, Phase 2, 20Jack, Phase 3, 10Jac... Show More

    load * Inline [

    Responsible Person, Phases, Value
    Tom, Phase 1, 30
    Tom, Phase 2, 20
    Tom, Phase 3, 50
    Jack, Phase 1, 10
    Jack, Phase 2, 20
    Jack, Phase 3, 10
    Jack, Phase 4, 25
    Kate, Phase 1, 10
    Kate, Phase 2, 10
    Kate, Phase 3, 50

    ]

    Hi guys,
    Here's a sample data that I have.
    I just want to consider sum(Phase 1 and Phase 2) and present the numbers in percentage (Y- Axis)


    I want to create a bar chart like this.
    IMG_3052.jpgHow can I do it?

     

     

     

     

     

     

     

     

    I believe we have to use Total function and Set Analysis.

    Also, in the real data set, I have around 100 phases and I just have to display 5 out of it.

    @Kush  @Taoufiq_Zarra 

    Thank you so much,

    N

    Show Less
  • forum

    Qlik Connectors Discussions

    Issue with Qlik Sense Businesss Cloud and MongoDB (Beta) connector

    Hi there, I was able to connect my local Qlik Sense instance to our MongoDB via ODBC connector and MongoDB BI Connector (see this page for full proced... Show More

    Hi there, I was able to connect my local Qlik Sense instance to our MongoDB via ODBC connector and MongoDB BI Connector (see this page for full procedure).

    No I want to bring our Qlik Sense app onto Qlik Sense on Cloud Services (Business version), but I can't get the connection to work...

    I supply the same parameters but the error I receive is

    ERROR [HY000][unixODBC][Qlik][MongoDBODBC](110) Error from MongoDB Client: No servers yet eligible for rescan (Error Code 13053)

    What does it mean? Should we change anything in MongoDB?

     

    Thanks in advance

    Show Less
  • forum

    Qlik Brasil

    Set Analysis no script com data

    Comunidade, boa noite. Gostaria de uma ajuda, tenho uma tabela fato de custo onde meu campo descrição tem mais de 3 mil pedidos registrados. Cada pedi... Show More

    Comunidade, boa noite. 

    Gostaria de uma ajuda, tenho uma tabela fato de custo onde meu campo descrição tem mais de 3 mil pedidos registrados. Cada pedido tem um codigo e sua descrição.

    Exemplo: Codigo do item:14 096 00076 descrição do item:  Alcool gel - frasco 200GR. 

    Bom, chegou uma lista pra mim onde preciso tirar 15 itens desse campo descrição, porém esses itens so podem ser retirados do mês de Junho até Outubro.  Coloquei uma Clausula Where no script para desconsiderar esses itens, mas ele restringiu esses itens do mês de Janeiro, Fevereiro e etc... So quero que retire esses itens de Junho até Outubro. Não sei se a melhor forma é fazer isso no script ou no próprio gráfico. 

    Qual sintese eu poderia usar para fazer essa operação? 

    Show Less
  • forum

    New to QlikView

    Cumulative count distinct

    Hi qlikers,I try to calculate a cumulative distinct count on 3 rolling day.The yellow column.i've tried a rangesum combinate with above function , but... Show More

    Hi qlikers,

    I try to calculate a cumulative distinct count on 3 rolling day.

    The yellow column.

    i've tried a rangesum combinate with above function , but result is a just a non distinct cumulative sum 😞

    Thanks by advance.

     

     

    Show Less

Top Participants

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements and other topics.

Blogs

Support Updates Blog

Important and useful support information about end-of-product support, new service releases, and general support topics.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.

Groups

Covid 19

We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2.

open to all

Groups

QlikView to Qlik Sense

Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.

open to all

Groups

Qlik Healthcare

This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.

750+ Members

Events

Data Revolution Virtual Summit

The new normal requires a new approach to data. Join this event to learn about the latest trends and approaches for accelerating value from your data.

October 27 - 29, 2020 Virtual Summit

Events

Events & Meetups

Virtual Meetups are now a possibility! With the impact of COVID-19, the Qlik Meetup network has expanded its support to include the ability to host your next Meetup online. Email QlikMeetups@qlik.com to get your virtual Meetup started!’

Events

Direct Relief Uses Qlik to Manage Its COVID-19 Supply Chain

Qlik can help you manage your supply chain risks during COVID‑19.The nonprofit organization, Direct Relief, uses Qlik’s Supply Chain solution to scale its delivery of medical supplies worldwide.

Available on Demand