Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
2,502 online
Announcements

Data Analytics Forums

Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

Data Integration Forums

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.

Product Insight & Ideas

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 Qlik Community

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

    Qlik Sense App Development

    A better way to code this scenario

    hi guys,I need some assistance here.  I am reading from 2 HUGE tables and I'm getting into performance issues.So in my model I do the following..1. I ... Show More

    hi guys,

    I need some assistance here.  I am reading from 2 HUGE tables and I'm getting into performance issues.

    So in my model I do the following..

    1. I read a list of Products that we sell in a 'For_next' Loop

    2. Then I go look in Table1, per one day - the Sessions for that specific product (you will see this in an Inner Select)

    3. Then I take the Sessions that I got in (2), read ALL the info for that IN Table2, for the WHOLE month - not just one day.

    So in essence, I'm looking where customers bought ONE specific product on ONE day of the month - all the other products , and the detail, for the rest of the month as well.

     

    There has to be a better way to do this.

    Thank you

     

    Show Less
  • forum

    New to Qlik Sense

    Values Null on Script Qlikview

    Hi Everybody,I need to build a historic table by An QlikView Script 🤔.My script begin like this :And the results :But i want to have a result like th... Show More

    Hi Everybody,

    I need to build a historic table by An QlikView Script 🤔.

    My script begin like this :

    Capture1.JPG

    And the results :

    Capture2.JPG

    But i want to have a result like this with the value 0 that replace the character  "-" : 

    Capture3.JPG

    I've tried this  Capture4.JPG   without success 🙄

    The script show me a issue "Invalid Expression" 🤕

    Can you help me ?

    Thanks,

    Fanch

    Show Less
  • forum

    QlikView App Dev

    GeoAnalytics for Qlikview Chart Layer Size

    Hi All,I have a Chart Layer (Pie Chart) for every location showing some distribution (Flag Field -> is, is not).Now I want to size the whole pie chart... Show More

    Hi All,

    I have a Chart Layer (Pie Chart) for every location showing some distribution (Flag Field -> is, is not).

    Now I want to size the whole pie chart according to the locations sales, but in QlikView there is only one size parameter, that seems to size all pie chart the same size.

    The Documentation says there is a min and max input, but there is none.

    Using Aggr also doesn't work, the chart always picks the total expression, not by location.
    The formula works fine in a straight table using the location as dimension:

    • RangeMax($(vKPI) / Max(Total Aggr( $(vKPI), $(vField_Location))) * 15, 5)

    Is it possible in GeoAnalytics for Qlikview to size the pie chart differently for each location?

     

    Thanks and regards,

    Johannes

    Show Less
  • forum

    New to Qlik Sense

    Hide and show column

    Hi All, I have a inline table "Category"   which I am considering as a filter pane. If I select Category (Cosmatic) then i want to hide my 3 columns (... Show More

    Hi All, 

    I have a inline table "Category"   which I am considering as a filter pane. 

    If I select Category (Cosmatic) then i want to hide my 3 columns (football,cricket and movie) and show only one column BeautyProduct in my pivot table . 

    and when i dont select Category then BeautyProduct should be hidden and  3 column  (football,cricket and movie) should be displayed. 

    How can I cahive this ?

    Thanks in Advance

     

    Show Less
  • forum

    New to Qlik Sense

    QlikSense .Net Sdk and Enigma Export Data Access Denied

    Hello Everyone, I connected qliksense cloud business with qliksense .net sdk or enigma. I'm using API key to connect. I can access objects and object ... Show More

    Hello Everyone, I connected qliksense cloud business with qliksense .net sdk or enigma. I'm using API key to connect. I can access objects and object hypercube but can't export data. Because engine return "access denied" error.Anyone have any idea?  

    Show Less
  • forum

    New to Qlik Sense

    Stacked Bar Chart in %

       I have a Stacked Bar Chart which i need in %. I have two Dimensions and one measure. The expression im using is below: Count({<Year = {"$(=Max(Year... Show More

     

     

     I have a Stacked Bar Chart which i need in %.

    Aaseemsood_0-1614238293302.png

     

    I have two Dimensions and one measure.

    Aaseemsood_1-1614238102502.png

     

    The expression im using is below:

     

    Count({<Year = {"$(=Max(Year(TODAY())-1))"}, Transaction_Type={'New Booking'},[Service Type]={'Air'},[Dom / INT'L]={'Domestic'}, [Trip anticipation]-={'Undefined','Back Dated'}>} [# of Transactions])

     

    I want a 100% Stacked Bar chart. please let me know if there is a possibility.

     

    Show Less
  • forum

    QlikView App Dev

    How to avoid the internal Inconsistency Type A Error ???

    we just migrated our apps in micro soft azure and when we are trying to reload the apps we are getting below issue in our app, looking like some memor... Show More

    we just migrated our apps in micro soft azure and when we are trying to reload the apps we are getting below issue in our app, looking like some memory allocation issue, can any one guide us on how to avoid this error..

    Few more inputs : Local server Qv 11 and Azure version is Qv 12.

    Please look into the below image.

    Thanks Much in advance. Error_TypeA.PNG

    Show Less
  • forum

    Qlik Sense Mobile Discussions

    From Power BI to Qlik?

    Hey, I'm being interviewed for a business analytics manager position, I'm very familiar with power bi, but their bi platform is built on qlik which I'... Show More

    Hey,

     

    I'm being interviewed for a business analytics manager position, I'm very familiar with power bi, but their bi platform is built on qlik which I've never used and quite frankly only heard isn't as easy at all as power bi is.

    question is, is qlik superior to power bi in some way, just wondering if there is a chance I could convince them to migrate to power bi.

     

    and no, don't really need opinions on whether I'm suitable for the position given my lack of experience with qlik, I'll leave it up to them to decide

    Show Less
  • forum

    QlikView App Dev

    Set expression

    Can anyone please explain the meaning of this condition?[Base Year] = max({1} [Base Year])If I select 2021 as Base Year, what will be the output?@marc... Show More

    Can anyone please explain the meaning of this condition?

    [Base Year] = max({1} [Base Year])

    If I select 2021 as Base Year, what will be the output?

    @marcus_sommer 

    Show Less
  • forum

    QlikView App Dev

    Show all dimension values in Pivot table

    Hi All,    I have a pivot table, ticked 'Show All Values' and unticked 'Suppress Zero-Values'  in all dimensions and tried both the expressions below ... Show More

    Hi All,

        I have a pivot table, ticked 'Show All Values' and unticked 'Suppress Zero-Values'  in all dimensions and tried both the expressions below to display all values even if it is null. Both the expression works but when selecting a record to view, system makes zero for all other records and shows all data. Is there anyway to hide all other records and display only selected records in pivot table? 

    Expression 1

    =if(sum({1} [# Total Hours]) <> sum([# Total Hours]), sum([# Total Hours]),0)

    Expression 2 

    =sum([# Total Hours]) + Sum({1}0)

    Thank you. 

     

    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

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