Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
1,997 online
Announcements
QlikWorld May 10-12, Online and Free! REGISTER NOW

Data Analytics

Forums for Qlik Data Analytics 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

QlikWorld

This year’s go-to data event is full of inspiring speakers, informative sessions, ideas for up-leveling your data integration and analytics.

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.

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.

Qlik Resources

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

Events

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

Blogs

Hear directly from Qlik employees in our ten unique blogs.

About

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

Community Sitemap

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

Recent Discussions

  • No Boards Found
  • forum

    New to Qlik Sense

    GetFieldSelection in

    Hi.I use GetCurrentSelecton to get dynamically rolling months backwards according to the following code:If ([Period] <= GetFieldSelections (Period)and... Show More

    Hi.
    I use GetCurrentSelecton to get dynamically rolling months backwards according to the following code:
    If (
    [Period] <= GetFieldSelections (Period)
    and
    [Period]> GetFieldSelections (Period) -100
    ,Period
    )

    It works great as long as you only choose one period in the filter.

    Is it possible to make it so that if the user selects 202010, 202011 and 202012 in the filter, the function only returns the highest value (use 202012 as Period) or the lowest(use 202010 as Period)?
    I have tried to use Min(Period) and Max(Period) in the function but only gets errors.

    Show Less
  • forum

    QlikView Administration

    Extração de dados de um Painel

    Boa noite! Sou um mero usuário desta ferramenta e estou com uma demanda. A empresa onde trabalho utiliza um Painel desenvolvido em QV, neste painel el... Show More

    Boa noite!

     

    Sou um mero usuário desta ferramenta e estou com uma demanda. A empresa onde trabalho utiliza um Painel desenvolvido em QV, neste painel ela disponibiliza dados de produtividade de toda a empresa, eu preciso fazer a extração da produtividade de uma equipe especifica, porém atualmente eu teria de fazer várias consultas para gerar uma planilha. Eu gostaria de saber se há uma possibilidade de alterar os filtros e escolher apenas os integrantes de uma determinada equipe?

    Peço desculpas pela pergunta confusa.

    Show Less
  • forum

    Deployment & Management

    Upgrade from 3.2 to June 2017

    I recently upgraded from Qlik Sense 3.2 to the June 2017 version following the instructions here. The upgrade said it was successful but the QMC or Hu... Show More

    I recently upgraded from Qlik Sense 3.2 to the June 2017 version following the instructions here. 

    The upgrade said it was successful but the QMC or Hub will not open using the shortcuts. 

    The services are all running and I've tried from localhost and using the domain name but no luck.

    Am I missing something here?

    Show Less
  • forum

    New to Qlik Sense

    Need to create calendar or new table where Value field changes based on Modified...

    I have a dataset that I need to use to derive a calendar or expanded table for every day of the year for multiple calendar years.An example data table... Show More

    I have a dataset that I need to use to derive a calendar or expanded table for every day of the year for multiple calendar years.

    An example data table is shown below.

    IDValueModified Date
    141/1/2020
    165/27/2020
    2812/1/2019
    2121/1/2021

     

    For ID = 1, I need the 'Value' field to be 4 for everyday before 1/1/2020 until the 'Modified Date' of 5/27/2020, when the Value changes to 6.  Then, I need the Value to be 6 starting on 5/27/2020 and every day after that.  How would I create a calendar or new table for multiple different IDs with different Values and different Modified Dates?

     

    Show Less
  • forum

    QlikView App Dev

    Assist with Set Analysis and Dual Variable

    Hi therePlease find attached.The model is self explanatory. I'm trying to do a Set Analysis in the Blue Text box for the Current Fin Year (20/21) and ... Show More

    Hi there

    Please find attached.

    The model is self explanatory. I'm trying to do a Set Analysis in the Blue Text box for the Current Fin Year (20/21) and it should return 5.17, but it doesnt. I'm almost sure it is the syntax, because FY is Dual.

    1. From research I have done I got - the set comparison always compares against the text value of a dual. So I created a variable called vFY.

    2. The result that I am getting is not correct.  what is wrong with my Set Analysis?

    Much appreciated.

     

     

    Thank you.

    Show Less
  • forum

    App Development

    Dimension Logic

    Hi Team,I have this Graph, Where I am representing month wise Salary. I want only month from April to March. But I have the data till September. I hav... Show More

    Hi Team,

    I have this Graph, Where I am representing month wise Salary. I want only month from April to March. But I have the data till September.

    sona_sa_0-1620138102214.png

     

    I have used this dimension - =If([Recruitment Year Month]<>'Jan 2021' and [Recruitment Year Month]<>'Feb 2021' and [Recruitment Year Month]<>'Mar 2021',[Recruitment Year Month]).

    How I can increase till March 2022. If I do not have data for after Sep 2021.

    Thanks.

    Show Less
  • forum

    App Development

    Restrict data on all selections except one field selection

    Hi All, Below is my expression :  I want to restrict this value on month field selections but should work on YEAR selection. I tried restricting using... Show More

    Hi All,

     

    Below is my expression :  I want to restrict this value on month field selections but should work on YEAR selection. I tried restricting using MONTH= but it is not working

     

    (((sum({<ProjectFlag={'Y'},EXPENDITURE_FLAG={'Y'},PROJECT_START_MONTH={"<=$(=addmonths(monthend(max(CALDATE)),1))>=$(=yearstart(monthstart(max(CALDATE))))"},MONTH=>}[ACTUAL COST])//,month([EXPENDITURE DATE]))
    /
    sum({<ProjectFlag={'Y'},EXPENDITURE_FLAG={'Y'},baseline_flag={'Y'},PROJECT_START_MONTH={"<=$(=addmonths(monthend(max(CALDATE)),1))>=$(=yearstart(monthstart(max(CALDATE))))"},MONTH=>}[BUDGETED AMOUNT]))
    *
    sum({< ProjectFlag={'Y'},EXPENDITURE_FLAG={'Y'},PROJECT_START_MONTH={"<=$(=addmonths(monthend(max(CALDATE)),1))>=$(=yearstart(monthstart(max(CALDATE))))"},MONTH=>}[CONTRACTUAL AMOUNT]))
    -
    (sum({<ProjectFlag={'Y'},EXPENDITURE_FLAG={'Y'},PROJECT_START_MONTH={"<=$(=addmonths(monthend(max(CALDATE)),1))>=$(=yearstart(monthstart(max(CALDATE))))"},MONTH=>}[ACTUAL COST])))
    /
    ((sum({<ProjectFlag={'Y'},EXPENDITURE_FLAG={'Y'},PROJECT_START_MONTH={"<=$(=addmonths(monthend(max(CALDATE)),1))>=$(=yearstart(monthstart(max(CALDATE))))"},MONTH=>}[ACTUAL COST])//,month([EXPENDITURE DATE]))
    /
    sum({<ProjectFlag={'Y'},EXPENDITURE_FLAG={'Y'},baseline_flag={'Y'},PROJECT_START_MONTH={"<=$(=addmonths(monthend(max(CALDATE)),1))>=$(=yearstart(monthstart(max(CALDATE))))"},MONTH=>}[BUDGETED AMOUNT]))
    *
    sum({< ProjectFlag={'Y'},EXPENDITURE_FLAG={'Y'},PROJECT_START_MONTH={"<=$(=addmonths(monthend(max(CALDATE)),1))>=$(=yearstart(monthstart(max(CALDATE))))"},MONTH=>}[CONTRACTUAL AMOUNT]))

     

    Please help.

    Thank you.

    Show Less
  • forum

    App Development

    How to fetch a get a data for this scenario

    Hello all,I am facing problem in deriving the solution for below problemLoad dt_diff, sequence5  , 145, 290, 3180, 4270, 5I wanted a solution like thi... Show More

    Hello all,

    I am facing problem in deriving the solution for below problem

    Load 

    dt_diff, sequence

    5  , 1

    45, 2

    90, 3

    180, 4

    270, 5

    I wanted a solution like this  below

    dt_diff, sequence

    5  , 0

    45, 1

    90, 2

    180, 3

    270, 4

    Anything  less than dt_diff  45 should come under the sequence 0, then it should populate sequentially

    hope my question is clear

    any inputs appreciated

     

     

    Show Less
  • forum

    QlikView App Dev

    Calculations in script

    Hello all,I have already imported those fields as an example:Field_a9842 Year123456 My ouput should look like:Operation: If value (Field_a) >5 then va... Show More

    Hello all,

    I have already imported those fields as an example:

    Field_a
    9
    8
    4
    2

     

    Year
    1
    2
    3
    4
    5
    6

     

    My ouput should look like:

    Operation: If value (Field_a) >5 then value(Field_b)=value(Field_a)*2*Year else value(Field_b)=value(Field_a)*Year/2 

    NB: These operations should be performed in the script and not as a chart expression.

    Year/Field _b    
    13456
    2681012
    3...   
    4 ...  
    5  ... 
    6   ...

     

    Any help please?

    Thanks in advance

    Show Less
  • forum

    Qlik Compose for Data Warehouses

    Model is not valid error during creation of the Warehouse.

    Hi, When trying to create the WH. COmpose is throwing the following error. However, validate of the model does not show anything. Any, suggestions whe... Show More

    Hi,

     

    When trying to create the WH. COmpose is throwing the following error.

    ubanerjee_0-1618583349718.png

     

    However, validate of the model does not show anything.

    ubanerjee_1-1618583400129.png

     

    Any, suggestions where I should be looking at to debug this error message?

     

    Thanks,

     

     

    Show Less

Get Started On Community

Start Here Get Started On Community

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

Register for QlikWorld Today

Join QlikWorld to hear from Qlik CEO, Mike Capone on activating your data for impact. You’ll also have access over 100 breakout sessions covering data integration and analytics, tips for getting the most out of your data, and a view into what the next generation of BI holds.

May 10-12, 2021

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