Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
2,082 online
Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY

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

Qlik Academic Program

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

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.

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.

Support

Access Support programs, Knowledge Base, Updates blog, and Release Notes.

Community Sitemap

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

Recent Discussions

  • No Boards Found
  • forum

    App Development

    Suma acumulada por fecha / acumulated sum by date

    Hola  a todos!!Quiero realizar un filtro acumulado de tal forma que, al seleccionar un dia de un mes y año determinado, la información que entregue el... Show More

    Hola  a todos!!

    Quiero realizar un filtro acumulado de tal forma que, al seleccionar un dia de un mes y año determinado, la información que entregue el dash sean desde el 01/01   hasta esa fecha. por ejemplo, si selecciono 06/01 en el filtro, los resultados que entregue un gráfico de barras serán los valores acumulados de las fechas  01/01, 02/03, 04/01, 05/01, 06/01. 

    ¿Existe alguna opción por defecto? ¿Alguna extensión que me pueda ayudar? ¿set análisis? ya intente RangeSum(Above(sum(TOTAL),0,RowNo())) y no me sirve (al seleccionar una fecha, me da el valor asociado a ese día en particular y no el acumulado)

     Gracias!!!!

    Hello everyone !

     I want created a acumulated sum by date. for example, if select one date (06/01), the result in the screen is the sum acumulated of  01/01, 02/03, 04/01, 05/01, 06/01. 

    exist a option by default ? extension? set analist? i try with RangeSum(Above(sum(TOTAL),0,RowNo()))  but It's not what I need.

     

    Thanks!!!!

    Show Less
  • forum

    New to Qlik Sense

    Web connector to sharepoint site

    Hi All,I am trying to connect to sharepoint site using web connector.  But I am getting below error when authenticating the site:There was a problem a... Show More

    Hi All,

    I am trying to connect to sharepoint site using web connector.  But I am getting below error when authenticating the site:

    There was a problem authenticating with the connector, further information is listed below:

    error = invalid_request
    error_description = AADSTS90027: We are unable to issue tokens from this API version on the MSA tenant. Please contact the application vendor as they need to use version 2.0 of the protocol to support this.
    Trace ID: 910ab797-d7a2-4a96-8cb7-f6e010909100
    Correlation ID: 78b6f0aa-164e-419d-b116-b58ab9b9711d
    Timestamp: 2021-07-23 22:27:00Z

    Any idea what this means?

    Thank you!

     

     

    Show Less
  • forum

    New to Qlik Sense

    users moving from cub reporting tool to Qlik Sense

    Hello,Interested in some guidance for a user considering moving from a cube reporting tool to qlk sense. In the cube reporting tool they can dynamical... Show More

    Hello,

    Interested in some guidance for a user considering moving from a cube reporting tool to qlk sense.

     

    In the cube reporting tool they can dynamically build their own reports using pre-defined Dimensions and Measures and then export to excel.

    Thank You,

     

    Michael

    Show Less
  • forum

    Deployment & Management

    Qlikview 12.60 problems with print to pdf

    We have upgraded from Qlikview Server April 2019 SR4 to Qlikview May 2021 (12.60).  The PDF-Xchange printer driver is no longer installed with Qlikvie... Show More

    We have upgraded from Qlikview Server April 2019 SR4 to Qlikview May 2021 (12.60).  The PDF-Xchange printer driver is no longer installed with Qlikview 12.60. The printer Qlikview now uses is 'Microsoft Print to PDF'.

    After the upgrade Qlikview Reports (RP objects)  that print to PDF are either 20 times the size of the files that used to get generated by the PDF-Xchange printer, or the PDF files are corrupted and you can't even open them.  This occurs in Server and Desktop.

    However, if you choose the PDF-Exchange printer in Desktop the reports are produced as they were - just fine.  It appears that there is no way of changing the printer to 'PDF-Xchange' in Qlikview Server. I have changed the printer in Publisher to 'PDF-Exchange' but that does not seem to feed through to Qlikview Server in Access Point.

    Any assistance, or fixes, would be appreciated.

    Show Less
  • forum

    New to Qlik Sense

    count

    Hi,I want to count how many visits took place between 07:00 - 15:00 I have been using the following expression :=Count({$<Time={">=07:00<=15:00)"}>} V... Show More

    Hi,

    I want to count how many visits took place between 07:00 - 15:00 

    I have been using the following expression :

    =Count({$<Time={">=07:00<=15:00)"}>} Visit)

    but it keeps coming up with all the visit and not just between 07:00-15:00

    Thanks,

    Sharbel

     

     

     

    Show Less
  • forum

    New to Qlik Sense

    Qlik Sense - Leverage Rest Api using .Net SDK or enigma.js?

    As the title implies, I'm trying to add some features that are currently unavailable through the hub/QMC but are using the API.Are there pros/cons to ... Show More

    As the title implies, I'm trying to add some features that are currently unavailable through the hub/QMC but are using the API.

    Are there pros/cons to using either the .net sdk or enigma.js? Is one more maintained than the other?

    I'm much more familiar with .Net as I used to use it before I moved to full time BI Developer.

     

    Any input is appreciated.

    Show Less
  • forum

    New to Qlik Sense

    IterNo

    l would like to generate dates between two dates . That is, [Start Date] and [End Date]. But when I run the code below it runs with out end. Below is ... Show More

    l would like to generate dates between two dates . That is, [Start Date] and [End Date]. But when I run the code below it runs with out end. Below is the code. I would like to know what am doing wrong. Thanks for your suggestions

     

    [HR Status DatesTmp]:
    Load *,
    Date([Start Date] + IterNo() - 1 ) as [Status Date]
    Resident [Applicant]
    While IterNo() <= Date([Start Date]) - Date([End Date]) + 1 ;

    Show Less
  • forum

    App Development

    Date is not appearing as date field in datepicker

    Hello all,i want to use the datepicker, but nothing is appearing as datefield. start and endate are saved like this in the database: 2021-07-13 11:03:... Show More

    Hello all,

    i want to use the datepicker, but nothing is appearing as datefield. 

    start and endate are saved like this in the database: 2021-07-13 11:03:58

    I'm loading my data like this in Qlik: 

    LOAD id,
    username,
    Date(enddate) as EndDate,
    Date(startdate) As StartData,
    interval(enddate-startdate) as Duration;

    [runs]:
    SELECT id,
    startdate,
    enddate,
    username,
    FROM `database`.runs;

    Unfortunately there is no value to select in the datepicker. i guess the startdate and endate are not recognized as date.

    Can someone help me?

    Show Less
  • forum

    App Development

    Options to make visualizations load fast

    Hello there!I am using the following expression as a measure while designing a bar graph.The result is as expected but the visualization is taking som... Show More

    Hello there!

    I am using the following expression as a measure while designing a bar graph.

    The result is as expected but the visualization is taking some time to load up on selections(understandable as there are many conditions in the expression). Is there any other simple/effective way to achieve this so that the performance wouldn't be low.

     

    My expression:

     


    if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
    ,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
    ='Students with Disabilities',
    if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},[SWD Status]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
    Count({<[Type]={'Current'},[School Year]={'2020-2021'},[SWD Status]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

    if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
    ,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
    ='At-Risk',
    if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},[At-Risk]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
    Count({<[Type]={'Current'},[School Year]={'2020-2021'},[At-Risk]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

    if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
    ,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
    ='English Learner',
    if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},[English Learner Status]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
    Count({<[Type]={'Current'},[School Year]={'2020-2021'},[English Learner Status]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

    if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
    ,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
    ='CFSA',
    if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},CFSA={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
    Count({<[Type]={'Current'},[School Year]={'2020-2021'},CFSA={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

    if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
    ,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
    ='Homeless',
    if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},[Homeless Status]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
    Count({<[Type]={'Current'},[School Year]={'2020-2021'},[Homeless Status]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

    if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
    ,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
    ='Military Connected',
    if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},[Military Connected Status]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
    Count({<[Type]={'Current'},[School Year]={'2020-2021'},[Military Connected Status]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

    if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
    ,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
    ='Migrant Status',
    if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},[Migrant Status]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
    Count({<[Type]={'Current'},[School Year]={'2020-2021'},[Migrant Status]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

    if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
    ,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
    ='Gender(Male)',
    if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},Gender={'Male'}>} distinct USI)
    /Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
    Count({<[Type]={'Current'},[School Year]={'2020-2021'},Gender={'Male'}>} distinct USI)
    /Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

    if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
    ,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
    ='Gender(Female)',
    if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},Gender={'Female'}>} distinct USI)
    /Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
    Count({<[Type]={'Current'},[School Year]={'2020-2021'},Gender={'Female'}>} distinct USI)
    /Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

    if(getselectedcount([School Year])=0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
    ,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
    ='Gender(Non-binary)',
    if(Count({<[Type]={'Current'},[School Year]={'2020-2021'},Gender={'Non-binary'}>} distinct USI)
    /Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)<0.001,'<0.1%',
    Count({<[Type]={'Current'},[School Year]={'2020-2021'},Gender={'Non-binary'}>} distinct USI)
    /Count({<[Type]={'Current'},[School Year]={'2020-2021'}>} distinct USI)),

     

     

    if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
    ,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
    ='Students with Disabilities',
    if(Count({<[Type]={'Current'},[SWD Status]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
    Count({<[Type]={'Current'},[SWD Status]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'}>} distinct USI)),
    if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
    ,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
    ='At-Risk',
    if(Count({<[Type]={'Current'},[At-Risk]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
    Count({<[Type]={'Current'},[At-Risk]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'}>} distinct USI)),
    if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
    ,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
    ='English Learner',
    if(Count({<[Type]={'Current'},[English Learner Status]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
    Count({<[Type]={'Current'},[English Learner Status]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'}>} distinct USI)),
    if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
    ,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
    ='CFSA',
    if(Count({<[Type]={'Current'},[CFSA]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
    Count({<[Type]={'Current'},[CFSA]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'}>} distinct USI)),
    if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
    ,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
    ='Homeless',
    if(Count({<[Type]={'Current'},[Homeless Status]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
    Count({<[Type]={'Current'},[Homeless Status]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'}>} distinct USI)),
    if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
    ,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
    ='Military Connected',
    if(Count({<[Type]={'Current'},[Military Connected Status]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
    Count({<[Type]={'Current'},[Military Connected Status]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'}>} distinct USI)),
    if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
    ,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
    ='Migrant Status',
    if(Count({<[Type]={'Current'},[Migrant Status]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
    Count({<[Type]={'Current'},[Migrant Status]={'YES'}>} distinct USI)
    /Count({<[Type]={'Current'}>} distinct USI)),
    if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
    ,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
    ='Gender(Male)',
    if(Count({<[Type]={'Current'},Gender={'Male'}>} distinct USI)
    /Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
    Count({<[Type]={'Current'},Gender={'Male'}>} distinct USI)
    /Count({<[Type]={'Current'}>} distinct USI)),
    if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
    ,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
    ='Gender(Female)',
    if(Count({<[Type]={'Current'},Gender={'Female'}>} distinct USI)
    /Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
    Count({<[Type]={'Current'},Gender={'Female'}>} distinct USI)
    /Count({<[Type]={'Current'}>} distinct USI)),
    if(getselectedcount([School Year])<>0 and valuelist('At-Risk','CFSA','English Learner','Homeless','Migrant Status','Military Connected','Students with Disabilities'
    ,'Gender(Male)','Gender(Female)','Gender(Non-binary)')
    ='Gender(Non-binary)',
    if(Count({<[Type]={'Current'},Gender={'Non-binary'}>} distinct USI)
    /Count({<[Type]={'Current'}>} distinct USI)<0.001,'<0.1%',
    Count({<[Type]={'Current'},Gender={'Non-binary'}>} distinct USI)
    /Count({<[Type]={'Current'}>} distinct USI))


    ))))))))))
    ))))))))))

    Thanks,

    Sai.

     

    Show Less
  • forum

    QlikView App Dev

    Weighted average - Sales vs. Budget

    Hi People,Which is the best way to calculate the weighted average percentage of the following?Thanks in advance!   

Get Started On Community

Start Here Get Started On Community

Top Participants

Blogs

Product Innovation Blog

Learn about what's new across all of the products in our growing Qlik product portfolio.

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.

German Group

Deutsche User Group

German speaking - This group makes it easier to collaborate in your local language.

Request to join

Brazil Group

Brazil

This group for Brazil users. All discussions are in Portuguese.

open to all

Industry Group

Public Sector Group

This is a open Group for the Public Sector

All are welcome

Events

Espresso Webinars - From Data Integration to Analytics in Action

These webinars get straight to the point, they are strong, short, and with immediate effect – like an espresso.

Upcoming and On-Demand

Events

Talk to Experts Tuesday

You’ve got questions? We’ve got answers! Talk to Experts is a live Q&A Webinar series! Join and ask your questions about Qlik Sense Enterprise, Client Managed.

June 29, 2021 10AM EST

Events

Cloud Data and Analytics Tour

Ready to steer your business towards data-informed growth? Our Cloud Data & Analytics Tour is the perfect place to start your journey.

Choose your Region