Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 157,670 members
  • 9,798 online
  • 1,708,995 posts
  • 128,230 Solutions
  • Welcome to Qlik Community

    FOR NEW MEMBERS

    Everything you need to make your Qlik Community experience valuable.

    SEARCH KNOWLEDGE BASE

    Explore official Support and member created content.

    ASK PRODUCT QUESTIONS

    Submit questions to product experts and participate in conversations.

    Analytics

    Forums for Qlik Analytic solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

    Data Integration

    Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources

    Qlik Gallery

    Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.

    Ideation

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

    Support

    Chat with us, search Knowledge, open a Case, read the latest Updates Blog, find Release Notes, and learn about our Programs.

    Events

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

    Groups

    Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.

    About

    Get started on Qlik Community, find How-To documents, and join general non-product related discussions.

    Blogs

    Hear directly from Qlik employees in our ten unique blogs.

    Qlik Resources

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

    Qlik Academic Program

    Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

    Community Sitemap

    Here you will find a list of all the Qlik Community forums.

    Recent Discussions

    • No Boards Found
    • forum

      New to Qlik Sense

      Need to create a month column with date filed

      Hi All I have Updated_Date column and I need to create Month column based on the date column. Updated_date Completed 5/2/2022 10 5/9/2022 15 ... Show More

      Hi All

      I have Updated_Date column and I need to create Month column based on the date column.

      Updated_date Completed
      5/2/2022 10
      5/9/2022 15
      5/16/2022 20
      5/23/2022 25
      5/30/2022 30
      6/6/2022 35
      6/13/2022 40
      6/20/2022 45
      6/27/2022 50

       

      Requirement like I need to create a "Month_A1" column with last date in the month which is available in Updated_date column for example "Month_A1"

      Base on Updated_date column I need to create Month_A1

      in Month_A1 fields like

      Month_A1
      May-2022
      Jun-2022

       

      Final results be like 

      Updated_date Completed Month_A1
      5/2/2022 10  
      5/9/2022 15  
      5/16/2022 20  
      5/23/2022 25  
      5/30/2022 30 May-2022
      6/6/2022 35  
      6/13/2022 40  
      6/20/2022 45  
      6/27/2022 50 Jun-2022

      If I select May-2022 in Month_A1 column I need to see only "Completed" as 30

      I need this month column created in Script and in front end filter as well.

      Thanks in advance.

      Show Less
    • forum

      App Development

      One Yes/no filter button for multiple conditional charts

      Hello Everyone, I want to create a single filter XYZ in the script. This will act like conditional button for different conditional charts. chart 1: S... Show More

      Hello Everyone,

      I want to create a single filter XYZ in the script. This will act like conditional button for different conditional charts.

      chart 1: Show employee name

      — If the filter XYZ is ‘YES’ then show the names of employees whose name length is more then 9 characters 

      — if the filter XYZ is ‘NO’ then show the names less than 9 characters

      chart 2: Show employee salary

      — if the same filter XYZ is selected ‘YES’ this chart should show all the salaries which are more than 50000

      – if the same filter XYZ is selected ‘NO’ the same chart should show less than 50000

      chart 3: Show employee city

      — if filter XYZ is ‘YES’ this chart should cities names starting with A,B,C

      — if filter XYZ is ‘NO’ this chart should show cities with D,E,F

      chart 4: show employee date of joining 

      — if filter XYZ is ‘YES’ this chart should show dates before 2019

      — if the filter XYZ is ‘NO’ this chart should show dates after 2019

      Show Less
    • forum

      New to Qlik Sense

      Set expression and wrong selections

      Hello everyone, I have been working on this problem for a few days now with no luck and hence reaching out to you all here. I have a bar chart with th... Show More

      Hello everyone,

      I have been working on this problem for a few days now with no luck and hence reaching out to you all here. I have a bar chart with the  bar measure as:

      Count(distinct {<[ProductCode]-={'Finance Spread'},[leasetype]={'L'}>+<[ProductCode]={'Finance Spread'},[leasetype]={'P'}>+<[ProductCode]-={'Finance Spread'},[leasetype]={'P'}>}[dealno])

      This results in the following chart

      sample1.png

      The issue is if I Select 'VSC' from the filter, 'Finance spread' Still stays in the selection. 

      To solve this, I tried to change the measure to (Added the '$' sign): 

      Count(distinct $ {<[ProductCode]-={'Finance Spread'},[leasetype]={'L'}>+<[ProductCode]={'Finance Spread'},[leasetype]={'P'}>+<[ProductCode]-={'Finance Spread'},[leasetype]={'P'}>}[dealno])

      Now this shows the correct selection but gives me the wrong count. 

       

      Is there any other way I could do this and get the correct count and selection?

      Any help is highly appreciated. 

       

      Thank you!

      Show Less
    • forum

      New to Qlik Sense

      wildmatch replace

      I am trying to replace an number within a data set but only when it meets a certain criteria. I am having to use 2 separate tables as the data is stor... Show More

      I am trying to replace an number within a data set but only when it meets a certain criteria. I am having to use 2 separate tables as the data is stored in independent areas.

      My script example is as below:

      Test:

       Load

      JobNo

      JobRef

      JobStart

      From 1st QVD

      outer join

      Load

      JobNo

      CompanyCode

      From 2nd QVD

      Jointable:
      Load
      If(WildMatch(JobRef,'*ABC*'),Replace(CompanyCode,'126','134'),
      If(WildMatch(JobRef,'*XYZ*'),Replace(CompanyCode,'126','125'),CompanyCode)) as NewCode
      Resident TEST

      I am trying to replace the codes where the job ref meets criteria of containing a value as these have been miss assigned but with a consistency in the ref allowing me to identify which need to go where. 

      When I run this and filter for job ref it returns every Code instead of just replacing the one one code. 

      Show Less
    • forum

      New to Qlik Sense

      Sorting for calculated dimension

      Hello Experts, I have a calulated dimension as below which I wanted to sort in a particular sort order  Expression : =if( aggr(sum(Sales),Admin_ID)/10... Show More

      Hello Experts,

      I have a calulated dimension as below which I wanted to sort in a particular sort order 

      Expression :

      =if( aggr(sum(Sales),Admin_ID)/1000000>=100 and aggr(sum(Sales),Admin_ID)/1000000<=500,'100M - 500M',

      IF(aggr(sum(Sales),Admin_ID)/1000000>=50 and aggr(sum(Sales),Admin_ID)/1000000<100,'50M-99.9M',

      IF(aggr(sum(Sales),Admin_ID)/1000000>=25 and aggr(sum(Sales),Admin_ID)/1000000<50,'25M-49.9M',

      IF(aggr(sum(Sales),Admin_ID)/1000000>=10 and aggr(sum(Sales),Admin_ID)/1000000<25,'10M-24.9M')
      )

      )
      )

      Sort otder I want is same as in Expression, but not sure how to write an expression for sorting.

      Thanks in advance.

      Show Less
    • forum

      Deployment & Management

      License Monitor - Error

      Hi, I have a problem with license monitor application. When I reload it, I get this error: ERROR: No license usage data found. Reload aborted. Please ... Show More

      Hi,

      I have a problem with license monitor application.

      When I reload it, I get this error:

      ERROR: No license usage data found. Reload aborted. Please verify that the following data connections are correct: ArchivedLogsFolder, ServerLogFolder.

      The connection string for ArchivedLogsFolder are:

       \\<FQDN>\<QlikShare>\ArchivedLogs

      The connection string for ServerLogFolder are:

      C:\ProgramData\Qlik\Sense\Log\

      How can I fix it?

      The version is Qlik Sense November 2020 Patch 6 - 13.102.13

      Show Less
    • forum

      Qlik Replicate

      How to add an endpoint without using the GUI

      We would like to automate the adding of endpoints to Qlik Replicate without having to use the GUI. The automation is required to be non-interactive si... Show More

      We would like to automate the adding of endpoints to Qlik Replicate without having to use the GUI. The automation is required to be non-interactive since it will run from a batch scheduler. I am aware that tasks can be imported outside of the GUI (via the JSON files) but cannot see how to create endpoints via an import.

      Is it possible to do this ?

      Thanks

      PC

       

      Show Less
    • forum

      New to Qlik Sense

      Filter empty value

      Hi colleagues,  Please help with Filter codes.I need to do a filter pane check:If Filter is not chosen, show sum on Key pane.I mean, I have filter wit... Show More

      Hi colleagues, 

      Please help with Filter codes.
      I need to do a filter pane check:
      If Filter is not chosen, show sum on Key pane.
      I mean, I have filter with dates (years and days). 

      And I have a Key pane with Clients sum.
      And i can't make that if filter is not chosen, Key pane must show “-” symbol, or something like “chose a period”. 

      Please help to realize the code.
      Thanks a lot 🙂

      Show Less
    • forum

      New to Qlik Sense

      Restar una medida de dos dimensiones diferentes

      Hola, Tengo un set de datos que se ve así: ID DATE 1 DATE 2 A 1 3 B 2 7 C 3 4 D 4 5   Donde el date1 es el día en el que un cliente entr... Show More

      Hola,

      Tengo un set de datos que se ve así:

      ID DATE 1 DATE 2
      A 1 3
      B 2 7
      C 3 4
      D 4 5

       

      Donde el date1 es el día en el que un cliente entra al negocio y el date2 es el día en el que sale.

      Quiero obtener la entrada de clientes neta por día (clientes que entrar menos los que salen).

      De momento tengo estos dos gráficos:

      Dimension: Date 1

      Medida: count(id)

      Franco2_0-1656342707765.png

      Dimension: DATE 2

      Medida: count(id)

      Franco2_1-1656342745937.png

       

      Lo que quiero es obtener la resta de lo que se muestra en estos dos gráficos, pero no se como debería programar la medida o dimensión ya que ambos tienen la misma medida pero diferentes dimensiones.

       

      Gracias de antemano!!!

       

      Show Less
    • forum

      App Development

      Merge of Blank/Empty values

      Hello Qlik Geeks,  I want to merge blank/empty values of a field RI to 'N' . I am using the below script to do that and it is not working. May I know ... Show More

      Hello Qlik Geeks, 

      I want to merge blank/empty values of a field RI to 'N' . I am using the below script to do that and it is not working. May I know what am i missing here ? Thank you in Advance

       

      If(Isnull(RI), 'N', RI) as RI

       

       

      CVR_1-1656341761035.png

      Thank you,

      CVR

       

      Show Less

    Get Started On Community

    Start Here Get Started On Community

    Top Participants

    Blogs

    Community News

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

    Blogs

    Qlik Academic Program Blog

    Read the latest blog around the Qlik Academic Program.

    Blogs

    Qlik Product Innovation Blog

    If you want to know what's new across all of the products in our growing Qlik product portfolio.

    Blogs

    Support Updates Blog

    Get the latest Support information about end-of-product support, new service releases, and general support topics.

    Blogs

    Qlik Design Blog

    Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.

    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

    Events and Webinars

    Qlik and Qlik Community Hosted Events

    Subscribe to our Events and Webinar page so you do not miss an event opportunity!

    choose and register

    Event

    Welcome to Qlik

    Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

    On-Demand

    Events

    Upcoming Events and Webinars

    There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

    Upcoming