Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
1,319 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

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.

Events

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

Qlik Academic Program

Enabling professors and students with data and analytics.

About

Get started, 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

    Qlik NPrinting Discussions

    NPrinting May 2021 Help in Community

    I wanted to mention that this is confusing to see references to before and after NPrinting 16 and 17 in the May 2021 NPrinting qlik help page.  I star... Show More

    I wanted to mention that this is confusing to see references to before and after NPrinting 16 and 17 in the May 2021 NPrinting qlik help page.  I started with Qlik NPrinting Feb 2020 and now we are at June 2020 SR1 looking to move to May 2021.  

    https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/Introduction/Version-differences.htm

    The am in the link for May 2021 help and when it says comparing features of 17 and newer with 16. Per the release notes May 2021 is version 21+  (May 2021 Technical Preview (21.14.1))  what is the significance of dividing 17 and newer with 16 and older?

    mjht_0-1623878601291.png

    I am using NPrinting with Qlik Sense - It would be nice to have some new updated videos to watch around the topics of Conditions, Filters with variables (see below snap) rather than fields defined and when to use evaluate, image sizing specific to qlik sense and other than excel examples (most of my business users want ppt/pdf) - I have read the help on image sizing and it is still confusing.  Also business users want to see totals -- you cannot get totals on a native table to ppt and that leaves images and then we are back to the sizing dilemma.  

    mjht_1-1623879872185.png

    I would like a good example for variable created under the filters tab.  And when to check the evaluate box - what the difference is.  

    Thank you.

     

    Show Less
  • forum

    New to Qlik Sense

    Filtering by year in set analysis using Or and Distinct

    Hello, I would like to filter out this data by year using the set expression below. However, when I add year to the set analysis, it returns a value o... Show More

    Hello, I would like to filter out this data by year using the set expression below. However, when I add year to the set analysis, it returns a value of zero. 

    Here is the set analysis as it stands. This correctly generates numerical values. 

    count(distinct(if([CONTRIB_CODE-CONTRIB_CODE1]='07' or [CONTRIB_CODE-CONTRIB_CODE1]='19' or[CONTRIB_CODE-CONTRIB_CODE1]='60.88'
    or CONTRIB_CODE2= '07' or CONTRIB_CODE2='19' or CONTRIB_CODE2='60.88' or CONTRIB_CODE3='07'or CONTRIB_CODE3= '19' or CONTRIB_CODE3='60.88'
    or DISTRACTED_BY_CODE='01' or DISTRACTED_BY_CODE='02' or DISTRACTED_BY_CODE= '03' or DISTRACTED_BY_CODE= '04' or DISTRACTED_BY_CODE= '05' or
    DISTRACTED_BY_CODE='06'or DISTRACTED_BY_CODE= '07' or DISTRACTED_BY_CODE= '09' or DISTRACTED_BY_CODE='10'
    or DISTRACTED_BY_CODE= '12' or DISTRACTED_BY_CODE='13' or DISTRACTED_BY_CODE='14' or DISTRACTED_BY_CODE='15'
    or DISTRACTED_BY_CODE='16'or DISTRACTED_BY_CODE= '88' or DISTRACTED_BY_CODE='18'or DISTRACTED_BY_CODE= '17',OVERALL_REPORT_NO)))

     

    Here is the set analysis where I attempted to further filter the data by date. It consistently returns 0 as a value. When I use the set analysis as a measure and year as a dimension however, it returns values for 2015. So I know that the answer is not actually 0. 

    count(distinct(if([ACC_DATE.autoCalendar.Year]='2015',[ACC_DATE.autoCalendar.Year] and(if([CONTRIB_CODE-CONTRIB_CODE1]='07' or [CONTRIB_CODE-CONTRIB_CODE1]='19' or[CONTRIB_CODE-CONTRIB_CODE1]='60.88'
    or CONTRIB_CODE2= '07' or CONTRIB_CODE2='19' or CONTRIB_CODE2='60.88' or CONTRIB_CODE3='07'or CONTRIB_CODE3= '19' or CONTRIB_CODE3='60.88'
    or DISTRACTED_BY_CODE='01' or DISTRACTED_BY_CODE='02' or DISTRACTED_BY_CODE= '03' or DISTRACTED_BY_CODE= '04' or DISTRACTED_BY_CODE= '05' or
    DISTRACTED_BY_CODE='06'or DISTRACTED_BY_CODE= '07' or DISTRACTED_BY_CODE= '09' or DISTRACTED_BY_CODE='10'
    or DISTRACTED_BY_CODE= '12' or DISTRACTED_BY_CODE='13' or DISTRACTED_BY_CODE='14' or DISTRACTED_BY_CODE='15'
    or DISTRACTED_BY_CODE='16'or DISTRACTED_BY_CODE= '88' or DISTRACTED_BY_CODE='18'or DISTRACTED_BY_CODE= '17',OVERALL_REPORT_NO)))))

    If anybody can provide any insight on how to solve this I would greatly appreciate it!

    In addition, I am new to QLIK and largely self taught so new information or pointers are always welcome!

    Show Less
  • forum

    Deployment & Management

    Access to Hub for users from excel udc not working

    Hi @all,We have set up a user directory connection based on excel to synchronize specific users. The excel file contains password, userid etc. and the... Show More

    Hi @all,

    We have set up a user directory connection based on excel to synchronize specific users. The excel file contains password, userid etc. and the users are added to the Qlik Sense userlist after reloading/synchronizing the task. Furthermore we have allocated a cal to one of the new users and added privilege "root admin".

    Now we try to connect to the hub/qmc using the user directory "exceluser" and the userid as well as the password set in the excel file but the system refuses the connection with the statement: "The following user is not authenticated."

    Login: exceluser\user1
    PW: 123

    Do we miss something? Is it necessary that the mentioned user in the excel file exists within the Active Directory / local server user directory? 

    Any suggestions?

    Thanks in advanced.

    Show Less
  • forum

    Qlik NPrinting Discussions

    Launch NPrinting Designer Gets Error Seen in Snapshot included

    We are using NPrinting June 2020 SR1 with NPrinting Designer Client June 2020 SR1.   (you can see in the launch below)When user tries to edit a templa... Show More

    We are using NPrinting June 2020 SR1 with NPrinting Designer Client June 2020 SR1.   (you can see in the launch below)

    When user tries to edit a template, he gets this error trying to launch the Designer Client

    mjht_0-1623873417112.png

    @Lech_Miszkiewicz  @Frank_S 

    Show Less
  • forum

    Qlik NPrinting Discussions

    Qlik NPrinting Filters

    Hi to everyone!I am struggling to understand how to use filters in Qlik NPrinting,in particular Advanced Research and Evaluate Value.For example if I ... Show More

    Hi to everyone!

    I am struggling to understand how to use filters in Qlik NPrinting,

    in particular Advanced Research and Evaluate Value.

    For example if I want a range of period for a string field, let's say : YearMonth,

    I tried to write these expressions  using Advanced Research:

     

    =Num#(left(YearMonth,4))<=2015

    or

    =Num#(left(YearMonth,4))<=2017 and Num#(left(YearMonth,4))>=2012

    But them didn't work.

    Could you someone help me, for that specific question and give me general advices to use  Advanced Research and Evaluate Value. 

    I already read the official manual, and saw some videos tutorial.

    Thanks a lot!

    Show Less
  • forum

    App Development

    $ expansion of a conditional function in load editor, load as a field

    Hello I have this variable Set f_GroupScore ='If( (Sum(ACDTIME) + Sum(ACWTIME) + Sum(HOLDTIME)) / Sum(ACDCALLS) >= GroupScore1,1,If( (Sum(ACDTIME) + S... Show More

    Hello I have this variable 

    Set f_GroupScore =
    'If( (Sum(ACDTIME) + Sum(ACWTIME) + Sum(HOLDTIME)) / Sum(ACDCALLS) >= GroupScore1,
    1,
    If( (Sum(ACDTIME) + Sum(ACWTIME) + Sum(HOLDTIME)) / Sum(ACDCALLS) >= GroupScore2,
    2,
    If( (Sum(ACDTIME) + Sum(ACWTIME) + Sum(HOLDTIME)) / Sum(ACDCALLS) >= GroupScore3,
    3,
    If( (Sum(ACDTIME) + Sum(ACWTIME) + Sum(HOLDTIME)) / Sum(ACDCALLS) >= GroupScore4,
    4,
    If( (Sum(ACDTIME) + Sum(ACWTIME) + Sum(HOLDTIME)) / Sum(ACDCALLS) >= GroupScore5,
    5,
    If( (Sum(ACDTIME) + Sum(ACWTIME) + Sum(HOLDTIME)) / Sum(ACDCALLS) >= GroupScore0,
    1,
    Null()
    )
    )
    )
    )
    )
    )';

     

    I am trying to load it as a field but in the table it isn't expanding.  I loaded it as:

    AHT:
    Load
    KEY_IdDate,
    REPORT_GROUP,
    GroupScore1,
    GroupScore2,
    GroupScore3,
    GroupScore4,
    GroupScore5,
    GroupScore0,
    ACDCALLS,
    ACDTIME,
    HOLDTIME,
    ACWTIME,
    TOTALACDCALLS,
    ACDCALLS/TOTALACDCALLS as Weight,
    '$(f_GroupScore)'*(ACDCALLS/TOTALACDCALLS) as Weight1
    resident Temp2_AHT
    ;

    I want to expand it in the load editor so I can then filter certain values from showing up in the grids but instead of evaluating the expression it is only returning the string of the expression.  I've tried 'set', and 'let', I've tried inputing '=' in the parantheses.  Not sure what I'm missing is it not evaluating because it is an if statement?  Any help would be appreciated.  

     

    Thanks, 

    Show Less
  • forum

    Security & Governance

    Secure a script loaded by include statement

    Hello,System: Qlik Sense Enterprise Cloud 4/2020Over the last year we developed a robust framework around Qlik for our clients.  However one issue rem... Show More

    Hello,

    System: Qlik Sense Enterprise Cloud 4/2020

    Over the last year we developed a robust framework around Qlik for our clients.  However one issue remains due to our industry and data security.  We have a couple of scripts that are loaded as includes that pertain to data security access.  I can find no way to secure them from a developer and/or sponsor(we allow clients to develop apps).

    We secure data at both the database levels and application-section access.  

    There are two issues:

    (1) Anyone can simply comment out the lines (in DLE) and our security is non-existent. While there are some protections in that we have hooks to certain objects that won't work right without them and/or database roles that block data manager row level access, etc., it's not enough.

    (2) The debugger loads the scripts and walks through each line.  This scripts are tested and placed in secure paths on servers with hidden(can't see through folder connection that way or access through the other debug tool).  But I cannot stop the debugger in DLE from walking through each line of these scripts.

    I've tried to review most all Qlik API's, REST, SDK's, etc. and I can see no real way to do this.  I've also tried OS level file permissions.

    The primary is to block the debugger from showing the script or block the include from being debugged.

    The secondary would be to lock sections that would just have our one include line from being accessed and/or deleted, ie protected.

    The final issue we don't want anyone accessing code they can copy and debug and reveal security details which the above achieves.

    What are the possibilities?  

    This is now a security issue as we have upcoming FISMA audits and we could potentially expose data to unauthorized personnel in a clinical setting.  

    Thanks

     

    Show Less
  • forum

    Integration, Extension & APIs

    How to re render with Paint and new promises

    Hi guys, How to re render visualizations when api call is done without resizing and clicking ?Nothing is working:https://developer.mozilla.org/en-US/d... Show More

    Hi guys, 

    How to re render visualizations when api call is done without resizing and clicking ?

    Nothing is working:

    https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Promise

    https://community.qlik.com/t5/New-to-Qlik-Sense/How-to-render-Export-to-Image-after-getData-has-finished/m-p/1263168

    Paint render only when some click on sheet

    Show Less
  • forum

    New to Qlik Sense

    Dates Issue

    Hi all,I have a table which consists of 2 expressions Actual Cost and Revenue.Issue is Actual Cost value appears correctly only when date field Projec... Show More

    Hi all,

    I have a table which consists of 2 expressions Actual Cost and Revenue.

    Issue is Actual Cost value appears correctly only when date field Project Start Month is used as dimension while Revenue value appears correctly when CALDATE is used as dimension.

    I want to show both expressions in a single table but both should work as per their respective date field.

    I cannot use both the dimensions together.

    Is there way to show correct values in above situation in a single table only?

    Show Less
  • forum

    Integration, Extension & APIs

    Custom Theme won't apply to existing objects

    Hello All,I have created several custom themes to use in Qlik Sense but the themes are not working as desired.I'm using "_inherit: false" in 2 of 3 of... Show More

    Hello All,

    I have created several custom themes to use in Qlik Sense but the themes are not working as desired.
    I'm using "_inherit: false" in 2 of 3 of the custom themes but I'm having the same issues with all of the themes.
    The custom theme will not load with existing objects in a sheet without manually refreshing each object.
    The background color of the entire sheet will update but no other graphs/objects on the page will change.
    There are times where adding another object to the sheet will "refresh" the other objects and the theme will be applied.
    Other times entering "Edit Sheet" and then changing the theme will allow the theme to update.
    It is often that these methods do not work.
    Another user attempted to use the custom themes and experienced the same issues.

    The JSON & CSS file appear to be written & working correctly because the appropriate changes are shown when the theme does load.

    Is there anyway to ensure the theme will load properly every time it is selected ?

     

    I have attached the JSON file below. 

     

    Thanks!

    Show Less

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 QlikView.

May 18, 2021 10AM EST

Events

Qlik Insider - Webinar Series

This webinar will cover key new capabilities that drive Active Intelligence in your organization, helping your users go beyond the dashboard, to collaborate and take action at the point of decision.

May 26, 2021