Qlik Community

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

    New to Qlik Sense

    calculated field in data load script not available

    At the end of my data load section in the data load script, I've got this bit of code (not working).   If(IsNull("close_date"), '', Date(Date#("clo... Show More

    At the end of my data load section in the data load script, I've got this bit of code (not working).

     

     

        If(IsNull("close_date"), '', Date(Date#("close_date") - open_date)) as new_days_open,
        if("new_days_open" < 14, 'True', 'False') as FlagOnTime;

     

     

     

    The first line works but that very last line isn't doing what I expected. Is the syntax incorrect or is the calculated "new_days_open" field unavailable prior to the completed data load?

    Show Less
  • forum

    Deployment & Management

    Qliksense reload failure alert

    All,Qlikview has default alerting capability when reload fails.What is the similar option in qliksense? I see various posts related to that where ther... Show More

    All,

    Qlikview has default alerting capability when reload fails.

    What is the similar option in qliksense? I see various posts related to that where there are certain config required such as using Qlik webconnector etc.,

    What is the best robust option available for qliksense to generate such alerts?

    Thanks

    Show Less
  • forum

    New to Qlik Sense

    using a dynamic label in qlik Sense

    Hi im having trouble getting a dynamic lable to work in a qliksense app.I want to name a lable based on two selections.first is an id and second is a ... Show More

    Hi im having trouble getting a dynamic lable to work in a qliksense app.

    I want to name a lable based on two selections.

    first is an id and second is a value stateing the type of field. the id is selected from a box while the field_name is the one which will change and can be many different values.

     

    below is the metatable containing the lable names. field_desc is the lable name and field_name is the type. and ctrl_id is the id. 

    eclecticfish_0-1618923850752.png

    I try using code like =If(GetFieldSelections(field_name) = 'T_AMT', field_desc) but the lable turn out as - instead of "TAP CHARED MIN" 

    Show Less
  • forum

    New to Qlik Sense

    Defining Variable in Data Load Editor

    Dear All,I am trying to define a variable with sum involving aggr function in the data load editor. But the aggregation inside the aggr is evaluated. ... Show More

    Dear All,

    I am trying to define a variable with sum involving aggr function in the data load editor. But the aggregation inside the aggr is evaluated. I just want store the expression with out being evaluated as the expression is related the selections made in the front end dashboard.

    Ex: I want to store this expr = 'sum(aggr(1, $(=concat('[' & %Dimension & ']', ',' ))))' in a variable in data load editor, but the concat function is evaluated while reloading the dashboard itself and concat function returns null.

    Request to provide some suggestions to resolve this issue.

    Thanks,

    Vidya

    Show Less
  • forum

    New to Qlik Sense

    Create different folders so that you can group dimensions by different folders a...

    Create different folders so that you can group dimensions by different folders and measures by different folders
  • forum

    QlikView Administration

    Cluster: Dedicte one server for one document

    Hi.I have acustomer that have serverl smaller applications and one HUGE 20GB+. As long as the noone open the big document, everything is fine., Bur as... Show More

    Hi.

    I have acustomer that have serverl smaller applications and one HUGE 20GB+. As long as the noone open the big document, everything is fine., Bur as soon as the bog one gets opend, performance for all the other users gets terrible.

    Makeing the huge application smaller is not an option and keep adding resources to he server is not an option either. So im thinking of clustering. But then i ahve one Question.

    Is there a way to dedicate the guge appllication to a specific node in the cluster, and the other documents to the other server?

    There is a way to make users open the document on the server that has already opend it, but that way this application can be opend on any of the servers when it opends the first time.

    Is it possible to do this? And if not, what can you do?

    Show Less
  • forum

    QlikView App Dev

    Bookmark to current page using Document trigger

    Hi all,This is my scenario:I have set sheet triggers to select field values in every sheet.After hitting clear button,the triggers setting is also rem... Show More

    Hi all,

    This is my scenario:

    I have set sheet triggers to select field values in every sheet.After hitting clear button,the triggers setting is also removed and all values are seen which is not ideal.

    I refered the answer used in this question https://community.qlik.com/t5/QlikView-App-Dev/Clear-all-selections-removes-the-logic/td-p/1315902

    It solves the purpose of retaining the triggers ,however if I clik Clear button for eg on 3rd sheet,it automatically goes to 2nd sheet where the bookmark was created.

    Is there any way I can retain the trigger values and also remain on the same sheet ?

    Show Less
  • forum

    App Development

    Only need filename() and filetime() but ooxml XLSX files are huge and takes 30 s...

    This is part of a more complex script but I've isolated/simplified the problem part of code - see below.There are 4x matching files in the directory m... Show More

    This is part of a more complex script but I've isolated/simplified the problem part of code - see below.

    There are 4x matching files in the directory matching the * wildcard format.  It takes almost 3 minutes to load this tiny bit of script - over 30 seconds per file.

    The problem is there are almost 400 columns in these files (XLSX / ooxml).  But I don't care about the columns or file content at this point, I just want the filename/filetime (in my bigger script I'm only loading data from those with filetime>=lastreload, so this initial step is just to get a list of new files).  

    Is there any way Qlik can produce a file directory (including filetime) without trying to interpret the file contents, which is what seems to take ages?

    Thanks in advance.

     

     

    Test:
    FIRST 1 LOAD FileBaseName() as filename,
    FileTime() as filetime
    FROM
    [\\server\share\folder\namingconvention_*.xlsx]
    (ooxml);

     

     

     

    filetime, filename, dir, dirlist, filelist, directory, biff, incremental

    Show Less
  • forum

    App Development

    Line graphs as a percentage

    hi experts,looking for some help, apologies in advance as i am new to qlik!im pulling data from a excel file(attached) and i need to do 2 simple line ... Show More

    hi experts,

    looking for some help, apologies in advance as i am new to qlik!

    im pulling data from a excel file(attached) and i need to do 2 simple line graphs showing the % of selections in field "mode" and "c" was used in  a certain week. However its not showing up with the correct %'s and i cant understand why? 

    im using the wk-YY field as my x-axis in my line graphs. i used the expression "count( [Mode])/count(total "values")" and it works for a single week of data:

    JohnSamuel123_0-1618936827199.png

     

    but once i select numerous weeks, the line graphs dont have the correct %,(notice the different %  for week 2021-15):

    JohnSamuel123_1-1618936869482.png

     

    any help in getting the correct formula to show the total % of each mode and C type in a graph per week would be really appreciated

    thanks

    Show Less
  • forum

    New to Qlik Sense

    Using Measures in measures

    Hey everyone,is it in QlikSense possible to use a measure in another measure?At example we have the first measure "Sales", the second measure "Costs" ... Show More

    Hey everyone,

    is it in QlikSense possible to use a measure in another measure?

    At example we have the first measure "Sales", the second measure "Costs" and want to create the third measure "profit" with "sales" - "costs".

    In QlikView there was a possibility to use a measure in another measure using $(sales).

    Does anyone know this works in QlikSense?

    Thanks and Best Regards,

    Fabian

    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