Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
1,203 online
Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event 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

QlikWorld

This forum will provide you with event highlights and related content to get you energized and ready for QlikWorld Online.

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

    App Development

    QlikSense Load automatically every time user starts application

    How can I force the execution of the script, make it run automatically every time a user opens the QlikSense app.
  • forum

    QlikView App Dev

    how to create 2 tables from single table data visually

    Hello,           could someone help on the following,I have a table ,col1            col2         flag11                  AA             112          ... Show More

    Hello,

               could someone help on the following,

    I have a table ,

    col1            col2         flag

    11                  AA             1

    12                   AB            0

    13                   AC             1

    14                   AD             0

    The actual number of rows and columns 100+

    I need to show 2 different views(table chart) in a single sheet,

    Current:

    col1            col2         flag

    11                  AA             1

    13                   AC             1

    Previous:

    col1            col2         flag

    12                   AB            0

    14                   AD             0

    Please take into consideration, I don't want to create 2 separate tables in script due to other required views. is it possible to put a condition that will be applicable for the whole table.

    Show Less
  • forum

    QlikView App Dev

    Concat All Date befor Year

    Hay All Lats Say That Ihave Table With Fields Dates And The Year Of That DatesHoe Can I Calculate in table ObjectAny date that was before that YearLik... Show More

    Hay All 

    Lats Say That Ihave 

    Table With Fields Dates And The Year Of That Dates

    Hoe Can I Calculate in table Object

    Any date that was before that Year

    Like This For Example

    YearDate before Year
    2018 
    20191/1/2018,1/2/2018,1/3/2018,1/4/2018,1/5/2018,1/6/2018,1/7/2018,1/8/2018,1/9/2018,1/10/2018,1/11/2018,1/12/2018,1/13/2018,1/14/2018,1/15/2018,1/16/2018,1/17/2018,1/18/2018,1/19/2018,1/20/2018,1/21/2018,1/22/2018,1/23/2018,1/24/2018,1/25/2018,1/26/2018,1/27/2018,1/28/2018,1/29/2018,1/30/2018,1/31/2018,2/1/2018,2/2/2018,2/3/2018,2/4/2018,2/5/2018,2/6/2018,2/7/2018,2/8/2018,2/9/2018,2/10/2018,2/11/2018,2/12/2018,2/13/2018,2/14/2018,2/15/2018,2/16/2018,2/17/2018,2/18/2018,2/19/2018,2/20/2018,2/21/2018,2/22/2018,2/23/2018,2/24/2018,2/25/2018,2/26/2018,2/27/2018,2/28/2018,3/1/2018,3/2/2018,3/3/2018,3/4/2018,3/5/2018,3/6/2018,3/7/2018,3/8/2018,3/9/2018,3/10/2018,3/11/2018,3/12/2018,3/13/2018,3/14/2018,3/15/2018,3/16/2018,3/17/2018,3/18/2018,3/19/2018,3/20/2018,3/21/2018,3/22/2018,3/23/2018,3/24/2018,3/25/2018,3/26/2018,3/27/2018,3/28/2018,3/29/2018,3/30/2018,3/31/2018,4/1/2018,4/2/2018,4/3/2018,4/4/2018,4/5/2018,4/6/2018,4/7/2018,4/8/2018,4/9/2018,4/10/2018,4/11/2018,4/12/2018,4/13/2018,4/14/2018,4/15/2018,4/16/2018,4/17/2018,4/18/2018,4/19/2018,4/20/2018,4/21/2018,4/22/2018,4/23/2018,4/24/2018,4/25/2018,4/26/2018,4/27/2018,4/28/2018,4/29/2018,4/30/2018,5/1/2018,5/2/2018,5/3/2018,5/4/2018,5/5/2018,5/6/2018,5/7/2018,5/8/2018,5/9/2018,5/10/2018,5/11/2018,5/12/2018,5/13/2018,5/14/2018,5/15/2018,5/16/2018,5/17/2018,5/18/2018,5/19/2018,5/20/2018,5/21/2018,5/22/2018,5/23/2018,5/24/2018,5/25/2018,5/26/2018,5/27/2018,5/28/2018,5/29/2018,5/30/2018,5/31/2018,6/1/2018,6/2/2018,6/3/2018,6/4/2018,6/5/2018,6/6/2018,6/7/2018,6/8/2018,6/9/2018,6/10/2018,6/11/2018,6/12/2018,6/13/2018,6/14/2018,6/15/2018,6/16/2018,6/17/2018,6/18/2018,6/19/2018,6/20/2018,6/21/2018,6/22/2018,6/23/2018,6/24/2018,6/25/2018,6/26/2018,6/27/2018,6/28/2018,6/29/2018,6/30/2018,7/1/2018,7/2/2018,7/3/2018,7/4/2018,7/5/2018,7/6/2018,7/7/2018,7/8/2018,7/9/2018,7/10/2018,7/11/2018,7/12/2018,7/13/2018,7/14/2018,7/15/2018,7/16/2018,7/17/2018,7/18/2018,7/19/2018,7/20/2018,7/21/2018,7/22/2018,7/23/2018,7/24/2018,7/25/2018,7/26/2018,7/27/2018,7/28/2018,7/29/2018,7/30/2018,7/31/2018,8/1/2018,8/2/2018,8/3/2018,8/4/2018,8/5/2018,8/6/2018,8/7/2018,8/8/2018,8/9/2018,8/10/2018,8/11/2018,8/12/2018,8/13/2018,8/14/2018,8/15/2018,8/16/2018,8/17/2018,8/18/2018,8/19/2018,8/20/2018,8/21/2018,8/22/2018,8/23/2018,8/24/2018,8/25/2018,8/26/2018,8/27/2018,8/28/2018,8/29/2018,8/30/2018,8/31/2018,9/1/2018,9/2/2018,9/3/2018,9/4/2018,9/5/2018,9/6/2018,9/7/2018,9/8/2018,9/9/2018,9/10/2018,9/11/2018,9/12/2018,9/13/2018,9/14/2018,9/15/2018,9/16/2018,9/17/2018,9/18/2018,9/19/2018,9/20/2018,9/21/2018,9/22/2018,9/23/2018,9/24/2018,9/25/2018,9/26/2018,9/27/2018,9/28/2018,9/29/2018,9/30/2018,10/1/2018,10/2/2018,10/3/2018,10/4/2018,10/5/2018,10/6/2018,10/7/2018,10/8/2018,10/9/2018,10/10/2018,10/11/2018,10/12/2018,10/13/2018,10/14/2018,10/15/2018,10/16/2018,10/17/2018,10/18/2018,10/19/2018,10/20/2018,10/21/2018,10/22/2018,10/23/2018,10/24/2018,10/25/2018,10/26/2018,10/27/2018,10/28/2018,10/29/2018,10/30/2018,10/31/2018,11/1/2018,11/2/2018,11/3/2018,11/4/2018,11/5/2018,11/6/2018,11/7/2018,11/8/2018,11/9/2018,11/10/2018,11/11/2018,11/12/2018,11/13/2018,11/14/2018,11/15/2018,11/16/2018,11/17/2018,11/18/2018,11/19/2018,11/20/2018,11/21/2018,11/22/2018,11/23/2018,11/24/2018,11/25/2018,11/26/2018,11/27/2018,11/28/2018,11/29/2018,11/30/2018,12/1/2018,12/2/2018,12/3/2018,12/4/2018,12/5/2018,12/6/2018,12/7/2018,12/8/2018,12/9/2018,12/10/2018,12/11/2018,12/12/2018,12/13/2018,12/14/2018,12/15/2018,12/16/2018,12/17/2018,12/18/2018,12/19/2018,12/20/2018,12/21/2018,12/22/2018,12/23/2018,12/24/2018,12/25/2018,12/26/2018,12/27/2018,12/28/2018,12/29/2018,12/30/2018,12/31/2018
    20201/1/2018,1/2/2018,1/3/2018,1/4/2018,1/5/2018,1/6/2018,1/7/2018,1/8/2018,1/9/2018,1/10/2018,1/11/2018,1/12/2018,1/13/2018,1/14/2018,1/15/2018,1/16/2018,1/17/2018,1/18/2018,1/19/2018,1/20/2018,1/21/2018,1/22/2018,1/23/2018,1/24/2018,1/25/2018,1/26/2018,1/27/2018,1/28/2018,1/29/2018,1/30/2018,1/31/2018,2/1/2018,2/2/2018,2/3/2018,2/4/2018,2/5/2018,2/6/2018,2/7/2018,2/8/2018,2/9/2018,2/10/2018,2/11/2018,2/12/2018,2/13/2018,2/14/2018,2/15/2018,2/16/2018,2/17/2018,2/18/2018,2/19/2018,2/20/2018,2/21/2018,2/22/2018,2/23/2018,2/24/2018,2/25/2018,2/26/2018,2/27/2018,2/28/2018,3/1/2018,3/2/2018,3/3/2018,3/4/2018,3/5/2018,3/6/2018,3/7/2018,3/8/2018,3/9/2018,3/10/2018,3/11/2018,3/12/2018,3/13/2018,3/14/2018,3/15/2018,3/16/2018,3/17/2018,3/18/2018,3/19/2018,3/20/2018,3/21/2018,3/22/2018,3/23/2018,3/24/2018,3/25/2018,3/26/2018,3/27/2018,3/28/2018,3/29/2018,3/30/2018,3/31/2018,4/1/2018,4/2/2018,4/3/2018,4/4/2018,4/5/2018,4/6/2018,4/7/2018,4/8/2018,4/9/2018,4/10/2018,4/11/2018,4/12/2018,4/13/2018,4/14/2018,4/15/2018,4/16/2018,4/17/2018,4/18/2018,4/19/2018,4/20/2018,4/21/2018,4/22/2018,4/23/2018,4/24/2018,4/25/2018,4/26/2018,4/27/2018,4/28/2018,4/29/2018,4/30/2018,5/1/2018,5/2/2018,5/3/2018,5/4/2018,5/5/2018,5/6/2018,5/7/2018,5/8/2018,5/9/2018,5/10/2018,5/11/2018,5/12/2018,5/13/2018,5/14/2018,5/15/2018,5/16/2018,5/17/2018,5/18/2018,5/19/2018,5/20/2018,5/21/2018,5/22/2018,5/23/2018,5/24/2018,5/25/2018,5/26/2018,5/27/2018,5/28/2018,5/29/2018,5/30/2018,5/31/2018,6/1/2018,6/2/2018,6/3/2018,6/4/2018,6/5/2018,6/6/2018,6/7/2018,6/8/2018,6/9/2018,6/10/2018,6/11/2018,6/12/2018,6/13/2018,6/14/2018,6/15/2018,6/16/2018,6/17/2018,6/18/2018,6/19/2018,6/20/2018,6/21/2018,6/22/2018,6/23/2018,6/24/2018,6/25/2018,6/26/2018,6/27/2018,6/28/2018,6/29/2018,6/30/2018,7/1/2018,7/2/2018,7/3/2018,7/4/2018,7/5/2018,7/6/2018,7/7/2018,7/8/2018,7/9/2018,7/10/2018,7/11/2018,7/12/2018,7/13/2018,7/14/2018,7/15/2018,7/16/2018,7/17/2018,7/18/2018,7/19/2018,7/20/2018,7/21/2018,7/22/2018,7/23/2018,7/24/2018,7/25/2018,7/26/2018,7/27/2018,7/28/2018,7/29/2018,7/30/2018,7/31/2018,8/1/2018,8/2/2018,8/3/2018,8/4/2018,8/5/2018,8/6/2018,8/7/2018,8/8/2018,8/9/2018,8/10/2018,8/11/2018,8/12/2018,8/13/2018,8/14/2018,8/15/2018,8/16/2018,8/17/2018,8/18/2018,8/19/2018,8/20/2018,8/21/2018,8/22/2018,8/23/2018,8/24/2018,8/25/2018,8/26/2018,8/27/2018,8/28/2018,8/29/2018,8/30/2018,8/31/2018,9/1/2018,9/2/2018,9/3/2018,9/4/2018,9/5/2018,9/6/2018,9/7/2018,9/8/2018,9/9/2018,9/10/2018,9/11/2018,9/12/2018,9/13/2018,9/14/2018,9/15/2018,9/16/2018,9/17/2018,9/18/2018,9/19/2018,9/20/2018,9/21/2018,9/22/2018,9/23/2018,9/24/2018,9/25/2018,9/26/2018,9/27/2018,9/28/2018,9/29/2018,9/30/2018,10/1/2018,10/2/2018,10/3/2018,10/4/2018,10/5/2018,10/6/2018,10/7/2018,10/8/2018,10/9/2018,10/10/2018,10/11/2018,10/12/2018,10/13/2018,10/14/2018,10/15/2018,10/16/2018,10/17/2018,10/18/2018,10/19/2018,10/20/2018,10/21/2018,10/22/2018,10/23/2018,10/24/2018,10/25/2018,10/26/2018,10/27/2018,10/28/2018,10/29/2018,10/30/2018,10/31/2018,11/1/2018,11/2/2018,11/3/2018,11/4/2018,11/5/2018,11/6/2018,11/7/2018,11/8/2018,11/9/2018,11/10/2018,11/11/2018,11/12/2018,11/13/2018,11/14/2018,11/15/2018,11/16/2018,11/17/2018,11/18/2018,11/19/2018,11/20/2018,11/21/2018,11/22/2018,11/23/2018,11/24/2018,11/25/2018,11/26/2018,11/27/2018,11/28/2018,11/29/2018,11/30/2018,12/1/2018,12/2/2018,12/3/2018,12/4/2018,12/5/2018,12/6/2018,12/7/2018,12/8/2018,12/9/2018,12/10/2018,12/11/2018,12/12/2018,12/13/2018,12/14/2018,12/15/2018,12/16/2018,12/17/2018,12/18/2018,12/19/2018,12/20/2018,12/21/2018,12/22/2018,12/23/2018,12/24/2018,12/25/2018,12/26/2018,12/27/2018,12/28/2018,12/29/2018,12/30/2018,12/31/2018,1/1/2019,1/2/2019,1/3/2019,1/4/2019,1/5/2019,1/6/2019,1/7/2019,1/8/2019,1/9/2019,1/10/2019,1/11/2019,1/12/2019,1/13/2019,1/14/2019,1/15/2019,1/16/2019,1/17/2019,1/18/2019,1/19/2019,1/20/2019,1/21/2019,1/22/2019,1/23/2019,1/24/2019,1/25/2019,1/26/2019,1/27/2019,1/28/2019,1/29/2019,1/30/2019,1/31/2019,2/1/2019,2/2/2019,2/3/2019,2/4/2019,2/5/2019,2/6/2019,2/7/2019,2/8/2019,2/9/2019,2/10/2019,2/11/2019,2/12/2019,2/13/2019,2/14/2019,2/15/2019,2/16/2019,2/17/2019,2/18/2019,2/19/2019,2/20/2019,2/21/2019,2/22/2019,2/23/2019,2/24/2019,2/25/2019,2/26/2019,2/27/2019,2/28/2019,3/1/2019,3/2/2019,3/3/2019,3/4/2019,3/5/2019,3/6/2019,3/7/2019,3/8/2019,3/9/2019,3/10/2019,3/11/2019,3/12/2019,3/13/2019,3/14/2019,3/15/2019,3/16/2019,3/17/2019,3/18/2019,3/19/2019,3/20/2019,3/21/2019,3/22/2019,3/23/2019,3/24/2019,3/25/2019,3/26/2019,3/27/2019,3/28/2019,3/29/2019,3/30/2019,3/31/2019,4/1/2019,4/2/2019,4/3/2019,4/4/2019,4/5/2019,4/6/2019,4/7/2019,4/8/2019,4/9/2019,4/10/2019,4/11/2019,4/12/2019,4/13/2019,4/14/2019,4/15/2019,4/16/2019,4/17/2019,4/18/2019,4/19/2019,4/20/2019,4/21/2019,4/22/2019,4/23/2019,4/24/2019,4/25/2019,4/26/2019,4/27/2019,4/28/2019,4/29/2019,4/30/2019,5/1/2019,5/2/2019,5/3/2019,5/4/2019,5/5/2019,5/6/2019,5/7/2019,5/8/2019,5/9/2019,5/10/2019,5/11/2019,5/12/2019,5/13/2019,5/14/2019,5/15/2019,5/16/2019,5/17/2019,5/18/2019,5/19/2019,5/20/2019,5/21/2019,5/22/2019,5/23/2019,5/24/2019,5/25/2019,5/26/2019,5/27/2019,5/28/2019,5/29/2019,5/30/2019,5/31/2019,6/1/2019,6/2/2019,6/3/2019,6/4/2019,6/5/2019,6/6/2019,6/7/2019,6/8/2019,6/9/2019,6/10/2019,6/11/2019,6/12/2019,6/13/2019,6/14/2019,6/15/2019,6/16/2019,6/17/2019,6/18/2019,6/19/2019,6/20/2019,6/21/2019,6/22/2019,6/23/2019,6/24/2019,6/25/2019,6/26/2019,6/27/2019,6/28/2019,6/29/2019,6/30/2019,7/1/2019,7/2/2019,7/3/2019,7/4/2019,7/5/2019,7/6/2019,7/7/2019,7/8/2019,7/9/2019,7/10/2019,7/11/2019,7/12/2019,7/13/2019,7/14/2019,7/15/2019,7/16/2019,7/17/2019,7/18/2019,7/19/2019,7/20/2019,7/21/2019,7/22/2019,7/23/2019,7/24/2019,7/25/2019,7/26/2019,7/27/2019,7/28/2019,7/29/2019,7/30/2019,7/31/2019,8/1/2019,8/2/2019,8/3/2019,8/4/2019,8/5/2019,8/6/2019,8/7/2019,8/8/2019,8/9/2019,8/10/2019,8/11/2019,8/12/2019,8/13/2019,8/14/2019,8/15/2019,8/16/2019,8/17/2019,8/18/2019,8/19/2019,8/20/2019,8/21/2019,8/22/2019,8/23/2019,8/24/2019,8/25/2019,8/26/2019,8/27/2019,8/28/2019,8/29/2019,8/30/2019,8/31/2019,9/1/2019,9/2/2019,9/3/2019,9/4/2019,9/5/2019,9/6/2019,9/7/2019,9/8/2019,9/9/2019,9/10/2019,9/11/2019,9/12/2019,9/13/2019,9/14/2019,9/15/2019,9/16/2019,9/17/2019,9/18/2019,9/19/2019,9/20/2019,9/21/2019,9/22/2019,9/23/2019,9/24/2019,9/25/2019,9/26/2019,9/27/2019,9/28/2019,9/29/2019,9/30/2019,10/1/2019,10/2/2019,10/3/2019,10/4/2019,10/5/2019,10/6/2019,10/7/2019,10/8/2019,10/9/2019,10/10/2019,10/11/2019,10/12/2019,10/13/2019,10/14/2019,10/15/2019,10/16/2019,10/17/2019,10/18/2019,10/19/2019,10/20/2019,10/21/2019,10/22/2019,10/23/2019,10/24/2019,10/25/2019,10/26/2019,10/27/2019,10/28/2019,10/29/2019,10/30/2019,10/31/2019,11/1/2019,11/2/2019,11/3/2019,11/4/2019,11/5/2019,11/6/2019,11/7/2019,11/8/2019,11/9/2019,11/10/2019,11/11/2019,11/12/2019,11/13/2019,11/14/2019,11/15/2019,11/16/2019,11/17/2019,11/18/2019,11/19/2019,11/20/2019,11/21/2019,11/22/2019,11/23/2019,11/24/2019,11/25/2019,11/26/2019,11/27/2019,11/28/2019,11/29/2019,11/30/2019,12/1/2019,12/2/2019,12/3/2019,12/4/2019,12/5/2019,12/6/2019,12/7/2019,12/8/2019,12/9/2019,12/10/2019,12/11/2019,12/12/2019,12/13/2019,12/14/2019,12/15/2019,12/16/2019,12/17/2019,12/18/2019,12/19/2019,12/20/2019,12/21/2019,12/22/2019,12/23/2019,12/24/2019,12/25/2019,12/26/2019,12/27/2019,12/28/2019,12/29/2019,12/30/2019,12/31/2019

     

    Attached QV File

    Pls Send Me the set analisys

    Show Less
  • forum

    QlikView App Dev

    Budgets and Actuals - indicating difference in script

    hi allPlease find attached very simple spreadsheet and modelso what I have here is data regarding Messaging and Rates. The messaging data is Actuals O... Show More

    hi all

    Please find attached very simple spreadsheet and model

    so what I have here is data regarding Messaging and Rates. The messaging data is Actuals Only, where-as the Rates contains budgeted values (future dated) as well.

    What I want to achieve in the script, is to set some sort of indicator, lets call it "Actual" in the record for each Type, because as you can see in the simple chart, if I just subtract 1 month, for both of these metrics, both expressions are incorrectly dated, due to the fact that budgets are future dated.

    In my script, when I read both Types, I need to:

    1. " Test"  the Period to see if its future dated - if it is, make indicator Actuals (e.g.) = 0.

    2. If the Period is past, make indicator Actuals = 1.

    3. In the Expression of the chart create something like this (For messaging, for 1 Month Back)...

    =sum ({<Type = {'Message'},Period = {'$(vRepPeriod_1)'}>}Volume)

    where

    vRepPeriod_1 = only({<PeriodID={"$(=Max({<Actuals={'1'}>}PeriodID)-1)"},FY=>}Period)..

    4. The  result needs to be correct for both Messaging and Rates.

    I hope I am explaining this ok. The whole reason for this is that Actual data and Budgeted data should appear on one chart...at the same time. If I didnt need to take the future data into consideration, I could just do max(Period)-1 in both expressions for 1 month ago....(please note - I cannot use Period as a dimension in my charts - that would have been an easy win.....- I have set descriptions that I "force" in there with ValueLists)

    Please may you give me some guidance? I am not sure if I should build (and how) the logic about the "Actuals" indicator in the calendar, or in each table's read....

    Thank you

     

    Show Less
  • forum

    App Development

    What To Do As A Beginner In IOS App Development?

     Hello, I’m 19 and I have a dream of making a very simple FPS Mobile game. I understand that these projects can take years, but I’m willing to accept ... Show More
     

    Hello, I’m 19 and I have a dream of making a very simple FPS Mobile game. I understand that these projects can take years, but I’m willing to accept this challenge. Unfortunately, I have absolutely NO IDEA where to start. I’m deciding whether I should got college for this or be self-taught. Regardless, the only knowledge I have is that Swift may be my best option for IOS app development.

    I don’t have a clue about what to read, do, or what I’ll need. I’m just ready to take the next step in my life and I need guidance.

    Show Less
  • forum

    Security & Governance

    qlik sense root certificate query

    Dear Team, Just wanted to check  i have my qlik sense ver Sep 2020 installed on my windows server 2016 standard edition I have HA architecture for my ... Show More

    Dear Team,

     

    Just wanted to check  i have my qlik sense ver Sep 2020 installed on my windows server 2016 standard edition

     

    I have HA architecture for my qlik sense setup one is central node which has all services installed and one rim node which has all except Repository database service.

     

    I want to apply patch 9 so just wanted to check will it affect Qlik sense root-CA certificate.

     

    If yes what precautions i should take so that my url is not affected affected as this is a production environment.

     

    Regards

    Raj.

    Show Less
  • forum

    Deployment & Management

    SaaS error: memory limit for request was reached during reloads

    Hello,We have recently migrated to qlik and we have taken license for upto 4 apps expanded capacity for 10GB, but I am facing errors during reloads.Bu... Show More

    Hello,

    We have recently migrated to qlik and we have taken license for upto 4 apps expanded capacity for 10GB, but I am facing errors during reloads.

    But, I am getting the "memory limit for request was reached" error during reloads for a few apps (which have approx 7 GB utilization on opening sheets and charts) but since there are no limits on reloading scripts, can you please help us understand what is causing it and how can we fix it?

    Let me know what additional information you need from my end. Thank you!

    Show Less
  • forum

    New to Qlik Sense

    Duplicate Load from Script

    Hi,Someone helped me write this script, so it's a bit beyond my capabilities.  It is converting all income data whatever currency or distance measurem... Show More

    Hi,

    Someone helped me write this script, so it's a bit beyond my capabilities.  It is converting all income data whatever currency or distance measurement is used into USD and miles.  For some reason it is loading my data multiple times and I don't know why. 

     

    conversionMap:
    Mapping LOAD
    AutoNumberHash128(Curnc_Year,Currency_Abbr,'currency') as ConversionKey,
    USD_Equivalent
    FROM [lib://Documents (1qconsulting_debi.cook)/Currency Conversion.xlsx]
    (ooxml, embedded labels, table is Sheet1);

    TempTable:
    LOAD
    YearID as TestYearID,
    SubtextRow as Testsubtext,
    [Year] as testyear,
    if (SubtextRow = 'United Arab Emirates Dirham', 'AED', if(SubtextRow = 'Canadian Dollars', 'CAD')) as CurrencyAbbr
    Resident [ResponseTable]
    where match(SubtextRow, 'Canadian Dollars', 'United Arab Emirates Dirham')>0;

    left Join ([ResponseTable])
    Load
    TestYearID as YearID,
    testyear as Year,
    CurrencyAbbr
    resident TempTable;
    drop table TempTable;

    TempTable:
    LOAD
    YearID as TestYearID,
    SubtextRow as Testsubtext,
    [Year] as testyear,
    if (SubtextRow = 'Kilometers','Kilometer') as DistKilometer
    Resident [ResponseTable]
    where match(SubtextRow,'Kilometers')>0;

    left Join ([ResponseTable])
    Load
    TestYearID as YearID,
    testyear as Year,
    DistKilometer
    resident TempTable;
    drop table TempTable;

    Data:
    NoConcatenate Load
    *,
    if(Conversion = 'currency', Response / ApplyMap('conversionMap',AutoNumberHash128(num#(Year),CurrencyAbbr,Conversion),1),
    if(Conversion = 'distance' and DistKilometer = 'Kilometer', Response/1.60934,
    if(Conversion = 'sqmile' and DistKilometer = 'Kilometer', Response/1.60934*1.60934 ,
    if(Conversion = 'acre' and DistKilometer = 'Kilometer', Response/.404686, Response) )))
    as ConvertedResponse,
    ApplyMap('conversionMap',AutoNumberHash128(num#(Year),CurrencyAbbr,Conversion),1) as USD_Equivalent
    resident [ResponseTable];
    drop table [ResponseTable];

    drop field Response from Data;
    rename field ConvertedResponse to Response;

     

    Thanks

    Show Less
  • forum

    New to Qlik Sense

    decode in qliksense

    hi how i use decode in qliksense .. this is the expression SUM(DECODE(Rcount,0,DECODE(H.documentno,NULL,(C.gross- C.amont),0),0))how to use decode in ... Show More

    hi 

    how i use decode in qliksense .. this is the expression 

    SUM(DECODE(Rcount,0,DECODE(H.documentno,NULL,(C.gross- C.amont),0),0))

    how to use decode in qliksense ?

     

    any help 

    Show Less
  • forum

    COVID-19

    COVID-19 Data

    Hey Everyone,Great idea bringing people together from the Qlik community to work together and help consolidate resources. I'm working with a group on ... Show More

    Hey Everyone,

    Great idea bringing people together from the Qlik community to work together and help consolidate resources. I'm working with a group on a model for our hospitals in South Carolina. The Harvard and Penn models have been helpful, but there are a couple of different parameters we are looking to incorporate as well. 

    Harvard: https://projects.propublica.org/graphics/covid-hospitals

    Penn: http://penn-chime.phl.io/

    The Johns Hopkins reports are great at a high level, but the detailed information that the CDC reported here: https://www.cdc.gov/mmwr/volumes/69/wr/mm6912e2.htm would be even better. Does anyone here have an idea of where we could locate the raw data used in that report? Or more granular information than just confirmed/recov/death? Maybe I just keep missing it, but I can't seem to find it. 

    Thanks,

    Shrujan

    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

Online Conference

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