Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
968 online

Here you will find Qlik Sense resources, partake in interesting discussions, solve problems and foster relationships with Qlik experts from around the globe.

Thank you for joining us in the QlikView Forum, your home for QlikView answers. Discover insights within your data that can transform your business.

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

Join one of our Qlik Community Groups. Anyone can view content in Open Groups, but you must join to participate. Closed Groups require joining in order to view content and participate.

Hear directly from Qlik employees in our eight unique blogs. Check out the new Architecture Deep Dive Blog!

Find a forum to ask a question or start a discussion.

Discussion Boards and Documents for Qlik Services.

Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.

Discussion board and documents related to Qlik Associative Big Data Index.

Learn about the Qlik Community. Explore 'How-To' documentation, ask questions, and engage in discussion around the community platform. This will also be the place where, from time to time, we will do some fun things.


Challenge the status quo

See why Qlik (Attunity) is recognized in the 2019 Gartner Magic Quadrant for Data Integration Tools.

Recent Discussions

  • New to Qlik Sense

    Create and Insert a Variable

    Hi to allOn the next lines a variable that I´m trying to create and insert a variable to get all the tables in a HTML file. The value on field "H... Show More

    Hi to all

    On the next lines a variable that I´m trying to create and insert a variable to get all the tables in a HTML file. 

    The value on field "Hojas" is 5 that equals the number of tables in file:  

    FROM [lib://Dropbox - alejandro@inflexion.com.co/PruebasHojas/Job REPORTE DE VENTAS, Step 1.htm]

    Script:

    LOAD
    Hojas
    FROM [lib://NumeroHojas]
    (html, codepage is 28591, embedded labels, table is @1);

    let vprueba= Hojas;
    drop Table;

    For VHojas = 1 to $vprueba;

    LOAD
    *
    FROM [lib://Dropbox - alejandro@inflexion.com.co/PruebasHojas/Job REPORTE DE VENTAS, Step 1.htm]
    (html, codepage is 708, embedded labels, table is [$(VHojas)$]);

    And I get the next error:

    Captura de Pantalla 2019-08-18 a la(s) 9.51.42 a. m..png

     

    Show Less
  • QlikView App Development

    QlikView Triggers

    Hi there.I'm experiencing what seems to be unusual/unexpected behavior using Field Event Triggers in QV.  I'm using QV April 2019 SR1.My app cont... Show More

    Hi there.

    I'm experiencing what seems to be unusual/unexpected behavior using Field Event Triggers in QV.  I'm using QV April 2019 SR1.

    My app contains a chart and I change the field of the chart dimension using different buttons.  I use the Field Event Triggers to also be able to have a dynamic drill-down in the chart whereby if a selection is made, the dimension changes to the next level in the hierarchy.  I specifically use the On Select action.  In the app I also have buttons which allow me to change the date range in question at more of a global level, for example, Current Month, QTD and YTD.

    The problem that I'm experiencing is that when I change the date range, it seems to trigger the logic in my Field Event Triggers thereby changing the dimension of the chart.  The triggers in my date range buttons don't refer in any way to the fields in my Field Event Triggers and visa versa.

    I have been told that because the fields are related, more of an 'implicit' selection takes place but I would have expected that the Field Event Triggers only fire when an 'explicit' selection takes place.  I've also tested the behavior on QV 2017 SR9 and the problem doesn't occur (albeit a more simplified example). 

    Please can you tell me if this is expected behavior and if so maybe give me some insight into the mechanics of this.

     

    Regards,

    Peter

    Show Less
  • QlikView Scripting

    Implement the dynamic script logic to get the order details.

    Hi Team,I have one requirement that is a little bit tricky. I want you guys to help me to do this.Provided the below data source d... Show More

    Hi Team,

    I have one requirement that is a little bit tricky. I want you guys to help me to do this.

    Provided the below data source details. In the data source if order date is null then quantity should be changed time to time. If order date filled by a user while entering the order details then order id and  quantity should be only first records it should not change. One order id should be one record only.

    Sample Data source:                                                  

    clipboard_image_1.png   

     Sample Output :    

    clipboard_image_2.png

    Note:   I tried this but its not working dynamically. I would like to request please help me to do this.

    Regards,

    Irshad Ansari

    Show Less
  • New to QlikView

    Considerations of SAN for qlikview cluster install

    Dear Experts -I've read several community posts, but have not found what i need.I have two node cluster for DC (two nodes) and DR (two nodes) where in... Show More

    Dear Experts -

    I've read several community posts, but have not found what i need.

    I have two node cluster for DC (two nodes) and DR (two nodes) where in qlikview needs to access files from a shared location. This shared location is SAN. what i need to know is the qv files  that are required to be available in SAN so that during DC/DR failover, there should be no issue in accessing qvw and qvd's. 

    Also, i hope qv do support SAN and have no latency in accessing or reloading qv files.

    Thank you!

    SEAN.

     

    Show Less
  • New to Qlik Sense

    Auto Filter don't work

    Hi everyone, my filter of the table don't want work.i don't why:  Sum(distinct PIPS)
  • New to QlikView

    Qlikview selection pick based on conditions

    Hi everyone,i have an example data as below,i would like to load the data if order by batch no and ODATE, the 1st-row type =C, 2ndrow type =... Show More

    Hi everyone,

    i have an example data as below,i would like to load the data 

    if order by batch no and ODATE, the 1st-row type =C, 2ndrow type =D only load first row data, otherwise, load second-row data order by ODATE

    below highlighted in red is the expected output.

    is it possible to do this in Qlikview. Thanks!

    batch notypeindexODATE
    AC1102019.07.11
    AD1112019.07.12
    AC1122019.07.13
    AD1132019.07.14
    AD1142019.07.15
    AC1152019.07.16
    BC1162019.07.17
    BC1172019.07.18
    BD1182019.07.19
    BC1192019.07.20
    BC1202019.07.21
    BD1212019.07.22
    Show Less
  • Qlik Sense Cloud Discussions

    Count consecutive and sum negative consecutive value

    I have a dataset  with positive and negative values. Hi, i would like to calculate consecutive negative or positive value of my table and al... Show More

    I have a dataset  with positive and negative values. 

    Hi, i would like to calculate consecutive negative or positive value of my table and also maximal.

    Is it possible.

    Thanks!

    Capture d’écran 2019-08-18 à 08.41.04.png

    Spoiler
     

    Capture d’écran 2019-08-18 à 08.25.58.png 

    Show Less
  • QlikView App Development

    Dynamic category based on selection

    Hi,Is it possible to create dynamic category base on user selections?In above example,  I have hard coded "Other" category for Products D,E,FBut ... Show More

    Hi,

    Is it possible to create dynamic category base on user selections?

    Capture.PNG

    In above example,  I have hard coded "Other" category for Products D,E,F

    But my requirement is - For example:

    If user selects Product A, B then rest of the possible products should come under category "Other"

    If user selects A, D, C then rest of the possible products should come under "Other"

     

    Kindly help! 

    @sunny_talwar @swuehl   @Gysbert_Wassenaar @tresesco 

     

    Thanks

     

    Show Less
  • New to QlikView

    register ssl certificate on qlikview webserver

    Hi,Recently we are forced to change all websites from http to https.I registered ssl sertificate based on the following instruction:https://community.... Show More

    Hi,

    Recently we are forced to change all websites from http to https.

    I registered ssl sertificate based on the following instruction:

    https://community.qlik.com/t5/QlikView-Documents/Enable-SSL-QlikView-Webserver/ta-p/1495958

     I did all the steps and   as a  last step I run the below command in cmd and I got this message:

    The ssl certificate successfully registered,

     netsh http add sslcert ipport=0.0.0.0:443 certhash=0000000000003ed9cd0c315bbb6dc1c08da5e6 appid={00112233-4455-6677-8899-AABBCCDDEEFF}

     

    I changed the port from 80 to 443 and sleceted  "use https"( in qlikview web server), then I reseted qlikview web server.

    But nothing happened after that and access point didn’t load with new configuration.

    Any help would be highly appreciated.

    Show Less
  • New to Qlik Sense

    automation of user access and licence management in Qliksense

    Hello,In a interview of Qlikview Admin I have been asked  certain question. The final question was given to me and here are these.1. Can you or d... Show More

    Hello,

    In a interview of Qlikview Admin I have been asked  certain question. The final question was given to me and here are these.

    1. Can you or do you know any tool that can automate user access request. We have user access of 300 users daily and we don't want to waste time on manual entering users.

    2. How can we automate deployment in Qliksense?  Everyday we are just copy and pasting many application and we want to save time on this 

    I need to answer this  by Monday. Any thought?

    Show Less

Blogs

Qlik Community Manager Blogs

Hear from the Qlik Community team about the latest platform enhancements, announcements, and more.

Blogs

Qlik Education Blog

Check out the latest Education Blog written by Kevin Hanegan,Qlik Chief Learning Officer.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products. We have 8 blog types for you to choose from.

Groups

Join a Group

Join one of our Qlik Community user groups around an Industry, Location & Language, or Topic.

Groups

Qlik Deployment Framework

This group hosts information related to the Qlik Deployment Framework (QDF).

2700+ Members

Groups

Qlik Healthcare

This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.

750+ Members
Sue_Stage : List Private Messages : Sign out : Switch user COMMUNITY Qlik Community Settings for: Community Qlik Community ChooseGo to Community ADMIN STUDIO TOOLBOX DISCUSSION STYLES FEATURES SYSTEM DISPLAY CONTENT USERS MOD TOOLS METRICS COMMUNITY STRUCTURE Search for settings Announcements Custom Content Custom Pages ActiveCast Featured Threads Promoted Search Select Custom Content Setting Event Card event-card Custom Content 7 Text

Events

Qlik Insider Webinar Series

What's New in 2019. Register for the Qlik Insider Webinar Series to stay connected on our latest releases

Available On Demand Webinar

Events

Events & Meetups

Participate in an upcoming Qlik related event, webinar, or local meetup.

Events

Welcome to Qlik

Join the “Welcome to Qlik” webinar and learn about the Qlik Ecosystem

Tuesday, August 27, 2019 Webinar
Show help for this page