Home | Qlik Community

Time 2020-09-21 06:02:04

Web Name: Home | Qlik Community

WebSite: http://community.qlik.com

ID:54179

Keywords:

Home,Qlik,Community,

Description:

We no longer support Internet Explorer v10 and older, or you have compatibility view enabled. Disable Compatibility view, upgrade to a newer version, or use a different browser. Find the forums for your Qlik data analytics products to ask a question, start a discussion, or review documentation. read more Find the forums for your Qlik Data Integration products to ask a question, start a discussion, or review documentation. read more May Qlik Alert You – Welcome to the Qlik Alerting Product Forum! Join in on the discussion around Qlik’s intelligent alerting solution for Qlik Sense! This is an open group to share and collaborate! read more Here you will find Qlik Sense resources, partake in interesting discussions, solve problems and foster relationships with Qlik experts from around the globe. read more Thank you for joining us in the QlikView Forum, your home for QlikView answers. Discover insights within your data that can transform your business. read more 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. read more Hear directly from Qlik employees in our ten unique blogs. Check out the new Product Insight Ideas Blog! read more Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform. read more 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. read more Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page. read more Data Revolution Virtual Summit Traditional BI is over: The new normal requires a new approach to data. Join this free online event to learn about the latest data and analytics trends, approaches, and solutions for accelerating value from your data. This virtual summit runs from October 27 - 29, 2020. Register today for the virtual summit of your choice Register Now Check out More Events Leverage your QlikView Investment to Modernize your BI Experience QlikView customers can learn how to leverage their investment through the Analytics Modernization Program to accelerate their adoption of next-generation BI at a low TCO. Watch the webinar to learn more Join the QlikView to Qlik Sense discussion group Qlik Insider: What's New in 2020? BECOME A QLIK INSIDER. GET THE LATEST QLIK PRODUCT FEATURES.Join us to get the latest detail on Qlik product releases and program offerings! This series provides must-know information on our product enhancements and innovations delivered across our product portfolio. Watch Today More Events Talk to Experts Tuesday - Live Webinar Bring your questions and get answers during our LIVE Q&A Webinar – Talk to Experts! Bring your questions about moving from QlikView to Qlik Sense on September 22, 2020 at 10AM EST. Register Now Check out More Events Qlik Sense Data Connectivity Sum Field based on other two fields aggregated Hello Qlik community !!I have a table consisting of 4 Fields: Date, Buyer, Seller, TotalAmount.My data consists of transactions between the buyers a... Show More Hello Qlik community !!I have a table consisting of 4 Fields: Date, Buyer, Seller, TotalAmount.My data consists of transactions between the buyers and sellers which can be interchangeable, in other words, entity X can appear both as seller and buyer. What i want to do is rank the buyers and sellers as a single entity "Company" based on the Sum of the total amount, whether they acted as buyer or seller.For example supposing I have this values in my Table:Table:[ Date, Buyer, Seller, Total Amount 12/05/2020, Apple, Amazon, 2000 13/05/2019, Amazon, Apple 2500 01/01/2020, Apple, Microsoft, 1000]I want a table-chart that displays: (Rank, Company, TotalAmountTransactioned)1 - Apple - 55002 - Amazon - 45003 - Microsoft -1000Will really appreciate it if someone can help me Show Less QlikView Scripting Case 935 How to Get Average amount = 12/2=6 ? Now Getting 3 Hi AllBelow is the load script :-Accounts_001:LOAD * INLINE [DocNum,TotalSumSy,Customer_Name1,3,SERVO ENGINEERING SDN BHD1,3,SERVO ENGINEERING SDN BHD... Show More Hi AllBelow is the load script :-Accounts_001:LOAD * INLINE [DocNum,TotalSumSy,Customer_Name1,3,SERVO ENGINEERING SDN BHD1,3,SERVO ENGINEERING SDN BHD2,5,SERVO DYNAMICS SDN BHD];For Each i in 501WhatIfDimension$(i):LOAD * INLINE [Pls select $(i)st Dim,Column$(i)SOURCE,SOURCESQ_Num,DocNumTotal,TotalCustomer_Name,Customer_Name];NEXT i;My Table Dimension :-=$(ColumnDim501)My Table expression :-=pick(Match([Pls select 61st Dim],'Ave_SQ_Amt','Total_SQ','Total_Amount',),sum($(ColumnDim61))/count(DISTINCT $(ColumnDim61)),count(DISTINCT $(ColumnDim61)),sum($(ColumnDim61)))Total Amount = 12 is correct :-Total number of Quotation = 2 is correct :-Base on above Total =12 And No of Quotation = 2 Average = 12/2=6 , But my result shown = 4 which is wrong :-Hope some one can advise me.Paul Yeo Show Less New to QlikView Extract a list of fields from a Table (concatenated) HiPFAI am trying to extract a list of distinct Tablenames into a delimited string, and I'm not getting it right.I'm thinking I could probably use the ... Show More HiPFAI am trying to extract a list of distinct Tablenames into a delimited string, and I'm not getting it right.I'm thinking I could probably use the current For..Next ("For Count...")loop to get this, and not to have another resident load.In fact, I would need to do exactly the same for the field REQ_DATE andREQ_HOUR (long story..... Please may you have a look - here is my model.Thanks Show Less New to Qlik Sense Where not exists Hi,I have gone through the concept of NOT Exists but it is throwing me off. Please help me in understanding how does NOT EXISTS work in the script.B... Show More Hi,I have gone through the concept of NOT Exists but it is throwing me off. Please help me in understanding how does NOT EXISTS work in the script.Below is the pseudo-code I found on internet and I tried executing this code in QS . The result doesn't make sense to me.First:Load F1 As F1Reduce, F2;LOAD * INLINE [F1, F21, North2, South];Concatenate(First)LOAD * INLINE [F1, F21, North2, South3, West4, East3, West14, East1]where not Exists(F1Reduce,F1); //Loads records where F1's value not present in Table : Firstdrop Field F1Reduce from First;The output I get isI am not expecting the above output. What I am expecting is East, East1, West , West 1. How do I modify the script?My lack of understanding of NOT Exists is not helping me. Show Less New to Qlik Sense Sum Field based on other two fields aggregated Hello Qlik community !!I have a table consisting of 4 Fields: Date, Buyer, Seller, TotalAmount.My data consists of transactions between the buyers a... Show More Hello Qlik community !!I have a table consisting of 4 Fields: Date, Buyer, Seller, TotalAmount.My data consists of transactions between the buyers and sellers which can be interchangeable, in other words, entity X can appear both as seller and buyer. What i want to do is rank the buyers and sellers as a single entity "Company" based on the Sum of the total amount, whether they acted as buyer or seller.For example supposing I have this values in my Table:DateBuyerSellerAmount12/05/2020AppleAmazon200013/05/2019AmazonApple250001/01/2020AppleMicrosoft1000I want a table-chart that displays:RankCompanyTotal Amount Transactions1Apple55002Amazon45003Microsoft1000Will really appreciate it if someone can help me Show Less New to Qlik Sense Problema ao consultar bases pelo banco de dados do Saas Ola a Todos, espero que estejam Bem!Estou tendo problemas ao consultar planilhas no Qlick senseocorre que eu consigo executar a query (View) pelo des... Show More Ola a Todos, espero que estejam Bem!Estou tendo problemas ao consultar planilhas no Qlick senseocorre que eu consigo executar a query (View) pelo desktop ao banco de dados interno da empresa.contudo, pelo Saas, conecta mas não consigo executar a query (View) ao banco de dados da nuvem.ocorre o seguinte erro :(Connector error: ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-24347: Warning of a NULL column in an aggregate function)alguém consegue me explicar o por quê?abraços,Felipe Oliveira Show Less Qlik Deployment Framework Your license quota has been met I was upgrading from a Qlik Sense Free Trial to Paid version. I recieved a welcome email that needed to be activated...once activated an error message... Show More I was upgrading from a Qlik Sense Free Trial to Paid version. I recieved a welcome email that needed to be activated...once activated an error message "You have met the allowable number of tenants you can create. To manage your license, contact Qlik Sales." is there any way to resolve this today without waiting for someone from sales to get back to me tomorrow? Show Less Qlik Sense App Development Create a custom chart MAP Hello,I have an exercise to perform which consists in creating a personalized map in order to add heat points according to the zones impacted by an in... Show More Hello,I have an exercise to perform which consists in creating a personalized map in order to add heat points according to the zones impacted by an indicator. To facilitate the work, I cut the map into 6 zones.Do you know if it is possible to do this with Qliksense please? If so, how please?thank you Show Less New to QlikView Autocomplete empty records with a previous value HELOI have a little problem. I have two views: Master Calendar and TempLET vMinDate = Num(MakeDate(2020,9,18));LET vMaxDate = Num(Today()-1);LET vDays... Show More HELOI have a little problem. I have two views: Master Calendar and TempLET vMinDate = Num(MakeDate(2020,9,18));LET vMaxDate = Num(Today()-1);LET vDays = vMaxDate - vMinDate + 2;Master Calendar:LOAD date(floor(TimeStamp,0.000694444446708076),'YYYY-MM-DD hh:mm:ss')as CreationDate;LOAD Timestamp($(vMinDate) + (RecNo() - 1)/1440) as TimeStampAUTOGENERATE 1440 * $(vDays);Temp: LOAD * INLINE [ CreationDate, Stan 2020-09-18 00:07:12, A 2020-09-18 00:10:12, B 2020-09-18 00:15:12, C 2020-09-18 00:18:12, D 2020-09-18 05:22:12, A 2020-09-18 05:25:12, B 2020-09-18 08:32:12, C 2020-09-18 08:34:12, D 2020-09-18 07:12:00, A 2020-09-18 08:42:12, B];After reloading the script, I have tablesCreationDateStan2020-09-17 23:59:122020-09-18 00:00:122020-09-18 00:01:122020-09-18 00:02:122020-09-18 00:03:122020-09-18 00:04:122020-09-18 00:05:122020-09-18 00:06:122020-09-18 00:07:12A2020-09-18 00:07:122020-09-18 00:08:122020-09-18 00:09:122020-09-18 00:10:12B2020-09-18 00:10:122020-09-18 00:11:122020-09-18 00:12:122020-09-18 00:13:122020-09-18 00:14:122020-09-18 00:15:12C2020-09-18 00:15:122020-09-18 00:16:122020-09-18 00:17:122020-09-18 00:18:12D2020-09-18 00:18:12How to fill in empty fields in a table with an earlier value. I suppose you have to use the privus function.But how ??? Show Less Hear from the Qlik Community team about the latest platform enhancements for April and May 2020. Read all about Qlik's Voice of the Customer program and Customer Success initiatives. Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products. We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2. open to all Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense. open to all Join Group This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights. 750+ Members Data Revolution Virtual Summit The new normal requires a new approach to data. Join this event to learn about the latest trends and approaches for accelerating value from your data. October 27 - 29, 2020 Virtual Summit 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!’ 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

TAGS:Home Qlik Community 

<<< Thank you for your visit >>>

Hot Websites