Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
1,824 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.

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

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.


Qlik Data Revolution Tour

Discover how to transform your entire data value chain for deep insights at unprecedented speed. The Qlik Data Revolution Tour can show you how.

Coming to a city near you, this exclusive one-day event reveals the leaders in the Data Revolution will be those who can bring to bear the totality of their data assets to seek and uncover transformational insights and enrich every decision across all aspects of their operations.

Recent Discussions

  • Qlik NPrinting Discussions

    Error: An error occurred while elaborating the entity tags.

    Hi I'm migrating a pixel perfect report from NP16 to NP18 Jun 2019.After importing the report, I keep adding the object from the Qlikview source and t... Show More

    Hi I'm migrating a pixel perfect report from NP16 to NP18 Jun 2019.

    After importing the report, I keep adding the object from the Qlikview source and the preview works properly as soon as I don't use Levels.

    As I try to import an object as Level and I bind a field to the report the preview fails giving this error

    "An error occurred while elaborating the entity tags.
    Please check if the entities are properly placed inside their level tags"

    NPDesigner and Server are both 19.19.4.0

     

     

     

     

     

    Show Less
  • New to QlikView

    Need a set analysis expression

    Hi everybody,I have 2 tables like this Table1RelationshipAll I want to do is to create a straight table with Model and ReportMonth dimension, and coun... Show More

    Hi everybody,

    I have 2 tables like this 

    1.PNGTable1

    2.PNG

    3.PNGRelationship

    All I want to do is to create a straight table with Model and ReportMonth dimension, and count the number of VIN1/VIN2 for each Model when WSMonth = ReportMonth

    expect result :

    ModelReportMonthCount VIN1Count VIN2
    A20190110
    B20190111
    B20190211

     

    what should my expression looks like ?

    Thanks !

    Dave

    Show Less
  • New to Qlik Sense

    Selection Year vs Previous Year comparison in Bar chart

    Dear Experts, Im a week into my Qilk sense Learning and I'm writing this seeking your help to figure out a solution to the below scenario. I have a Ye... Show More

    Dear Experts, 

    Im a week into my Qilk sense Learning and I'm writing this seeking your help to figure out a solution to the below scenario. 

    I have a Year field ( 2016,2017,2018 & 2019) and i need to compare sales based on my current year (based on filter selection) to its previous year in a bar chart. 

     

    I have tried using this below set expression in Measure 

    =sum({<Year ={">= $(=max(Year)-1)<=$(=max(year))"}>}Sales)

    I can see 2019 and 2018 comparison but when i'm selecting another year for example 2018 its not working and data of all years is being displayed over bar chart.  Can you please correct me 

    Regards,

    Gopinath  

    Show Less
  • New to QlikView

    sell thru on basis of calendar

    my calendar is working on this =Sum({<SalesDate={'>=$(=Date(start))<=$(=Date(end))'}>}RealisedSale)but its not working on my sell thru code.sell thru ... Show More

    my calendar is working on this =Sum({<SalesDate={'>=$(=Date(start))<=$(=Date(end))'}>}RealisedSale)

    but its not working on my sell thru code.

    sell thru formula is :-=Sum (InvoiceQuantity)/Sum (TransactionQuantity)*100

    i did like this to attach my calendar but its not working  and data is not showing ,=Sum({<SalesDate={'>=$(=Date(start))<=$(=Date(end))'}>}(InvoiceQuantity)/(TransactionQuantity)*100)

    please help

    Show Less
  • New to Qlik Sense

    difference between Sum(Aggr(sum()) vs sum()

    Can someone give a small example showing exact difference between  Sum(Aggr(sum()) vs sum() 
  • Qlik Sense App Development

    Display only positive values in Measure in pivot table Qlik Sense.

    Hi Folks,I have got below scenario where i need to display only positive values and values within 100% only.Example:This is my sample pivot table-Name... Show More

    Hi Folks,

    I have got below scenario where i need to display only positive values and values within 100% only.

    Example:

    This is my sample pivot table-

    NameLocation RateValueLand RateValue_2
    Limited$5009100%$655656%
    Showroom$47829847%$45715%
    Kite$57498%$235-2546%
    shop$787-459%$56-45%

     

    Now i need to display only the values which are positives and below 100% only.

    I am sure , i need to write expression in Value(Measures), under show column if. But not sure how to write for the above scenario.

    Note: The logic for Value = (1-(Sum({<[C-Desc]={"N/A","0001","N/A(BLANK)","()"}>} DValue)) / (Sum([Location Rate])))

    Value2 = (1-(Sum({<[C-Desc]={"N/A","0001","N/A(BLANK)","()"}>} DValue)) / (Sum([Land Rate])))

    *C-Desc and Dvalue are others fields.

     

    Thanks in advance,

    LP27

    Show Less
  • QlikView App Development

    Dynamically display value based on year

    Hi, I have a textbox that shows the value accordingly based on the year i hardcoded in.=count({1<[DTO Year]={"2019"},[YTD DTO]= {">=45"}>}DISTINCT [Cu... Show More

    Hi, 

    I have a textbox that shows the value accordingly based on the year i hardcoded in.

    =count({1<[DTO Year]={"2019"},[YTD DTO]= {">=45"}>}DISTINCT [Customer])

    Currently, i'm trying to display it when user select the year but can't get it right. 

    When no selection, display the max year, else display the value accordingly. if(GetFieldSelections ([DTO Year]) = '2016',
    count({<[YTD DTO]= {">=45"}>}DISTINCT [Customer]),
    if(GetFieldSelections ([DTO Year]) = '2017',
    count({<[YTD DTO]= {">=45"}>}DISTINCT [Customer])))

    Show Less
  • New to Qlik Sense

    Change Total Formula

    Dear all,starting from the sample data attached, in Qlik Sense i want to create a table with a simple average of quantity per product and in the total... Show More

    Dear all,

    starting from the sample data attached, in Qlik Sense i want to create a table with a simple average of quantity per product and in the total the summary of all averages (not the grand average).

    So i would like to specify one formula for the details and another one for totals. is it possible?

    Below the result i have to achieve.

    2019-10-14 09_53_10-SampleData.xlsx - Salvataggio completato.png

    Show Less
  • Qlik Sense Deployment & Management

    Run reload task on central node and rim node

    Hi all,We have created the reload task on central node server and all generated qvd will be stored in central node server.How could we reload task by ... Show More

    Hi all,

    We have created the reload task on central node server and all generated qvd will be stored in central node server.

    How could we reload task by other rim node and those node can access the qvd?

     

    Thanks a lot.

     

    Best Regards,

    Louis

    Show Less
  • Qlik Sense Deployment & Management

    Is there information about the latest Qlik Sense product security audits?

    Hi All,Is there information about the latest Qlik Sense product security audits? For example tests complient with "OWASP  Application Security Verific... Show More

    Hi All,

    Is there information about the latest Qlik Sense product security audits? For example tests complient with "OWASP  Application Security Verification Standard 3.0.1".

    Does anyone have some test results? If yes, can You share it privately?

    Best regards

    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

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