Issue#116: Qlik - IMPORT WEB DATA

  • Hi Community,

    could I import CostiEsecizio.html from a web page (link: www.tuttotrasporti.it/listini-nuovo (tuttotrasporti: Costi esercizio VCL

    0 Answers

    Sorry, your answer is too short !

  • Issue#50007: Qlik - Hi calendar object data issue

    Hi Experts,                                   i have to show in calendar object from date 1990 to today, i created calendar object with two variables and two buttons apply , clear . problem is data is not coming exactly  1990 to today date, is there any solution for this or any example for this,Please post your comment.   Best Regards,Mike.

  • Issue#62698: Qlik - Class() Data Issue

    As you can see, it seems to be counting REQUEST_IDs that are not within the Business Days Turn Around Time indicated in the class. For example, I would expect to see 16 REQUEST_IDs in Close Out for more than 120 days in the bottom table, but in reality there only appear to be 6. How do I get both charts to reflect the correct counts? 

  • Issue#261571: import data from web

    Hi, I need help in importing the data from web, but my web app is having login credentials. To get access of data I need to login to the site and then import the data. Is there any way I can get data from web when there is login included?

  • Issue#309424: Qlik - Floor, date func issue with excel loaded data

    Hi,I successfully answered one community question(209863) but faced weird situation(for me at least!) when floor and date functions were not working on some fields. these fields were loaded from excel after transforming through transformation wizard.My question is -    in below script these two lines don't work, doesn't make any difference in outputFloor(ID) as ID,  Date(Floor([Date Bought])) as [Date Bought], But when I use new fields(added '1' at the end), it works, Why it is so? Floor(ID) as ID1,  Date(Floor([Date Bought])) as [Date Bought1], Here is the script, input excel file and output image  T1: LOAD @1 as ID,     @2 as [Date Bought],     @3 as [Product Bought],     @4 as [Last Name] FROM [allign rows.xlsx] (ooxml, no labels, table is Sheet2, filters( Remove(Row, RowCnd(CellValue, 1, StrCnd(contain, 'ID'))), Remove(Col, Pos(Top, 3)), ColXtr(1, RowCnd(CellValue, 2, StrCnd(null)), 0), ColXtr(1, R

  • Issue#382339: Qlik - Data Load Issue

    I'm trying to load the following, it doesn't give an error, but it says 0 lines fetched. Please help. Thanks. [CustomerTable]:LIB CONNECT TO [QlikSQL (cbsbank_mpratt)];LOAD [Name_ID], [Account_Number],    [Closed_Acct_Flag],    [Document_Distribution_Group]; SQL SELECT  t0.Name_ID, t0.Account_Number, t1.COD_Account, t1.Closed_Acct_Flag, t1.Document_Distribution_Group, t2.DDA_Account, t2.Closed_Acct_Flag, t2.Document_Distribution_Group, t3.Note_Number, t3.Closed_Account_Flag as [Closed_Acct_Flag], t3.Document_Distribution_Group, t4.SAV_Account, t4.Closed_Acct_Flag, t4.Document_Distribution_Group FROM "WEEK"."dbo"."Name_To_All_Acct" as t0, "WEEK"."dbo"."COD_Codes"        as t1, "WEEK"."dbo"."DDA_Codes"        as t2, "WEEK"."dbo"."Note_Codes"       as t3, "WEEK"."dbo"."SAV_Codes"        as t4 WHERE t0.Account_Numb

  • Issue#402880: Qlik - Comparison with previous month data issue

    Hi All, I have an issue while comparing this month data with previous months data.I have fields like product name ,Sale ID sold and Month. For each sale there is one SaleID associated.i need to compare the products items sold for each product with last months products and need to display the products under Improvement and Deterioration sections.If any product has got more no.of products sold when compared to previous month it should come under improvement else it should come under deterioration. To achieve this i have taken List box and instead of field i took expression and in expression for improvement i have considered the below expression. Improvement: If(Aggr(Count({<Month={"$(=Month(Max(Date)))"},Year={"$(=Max(Year))"}SaleID),Products)<Aggr(Count({<Month={"$(=AddMonths(Month(Max(Date))),-1)"},Year={"$(=Max(Year))"}SaleID),Products),Products but the issue is all products doesnt have sales in all months. while comparing the products comparison happ

  • Issue#450702: Qlik - Data upload issue

    In my fist attempts at loading data,I seem to be able to load only 75 of 8000+ records from an excel file into the app. I've tried several different excel files to verify there wasn't a problem with the original.I'm using Qlik Sense.

  • Issue#513790: Qlik - Loading Historical data into Transactions table issue

    Hi Eveyone,                I have a transaction table(Employee details) ,which contains Effective date,i have created a calendar in Transaction table .History table contains Effective From and Effective To dates,I need to include history table changes to Transaction table. History table Contains all the fields same as in Transaction table.  Any Suggestions would be greatly appreciated.  Please find the attached sample data for reference.   Regards,A.Harish

  • Issue#515069: how to import website data including additional table pages under the same web address

    I can import website data through the power bi desktop app but the following web address http://www.electionguide.org/elections/past/ has more data when you click next within the table using the same web address.  How do i access all the data in the table?

  • Issue#575633: Qlik - Currency exchange issue (daily rates missing some data)

    Dear Expert, I have a currency exchange table (mostly daily but it may miss some days which I don't  know when it will miss). I have transaction data table with date. I want get currency converted by this exchange rate table. If the data in transaction table doesn't have associated exchange rate on that day it should use the rate from the closest previous day (e.g. If Fan 7th doesn't have exchange rate then use Feb 6th exchange rate if it has it, if Feb 6th, 5th, 4th, 3rd, 2nd  and 1st don't have exchange rates, then use Jan 31st's exchange rate).  I thought that one way is trying to fill missing exchange rates in the exchange rate table, in this way the transaction data can be associated with exchange rate. But how to achieve it I need suggestion. Is there other nice way to do it without go through the whole exchange rate table for missing date? Your suggestion is greatly appreciated, Weidong

  • Issue#618848: Qlik - issue with EXISTS, appending data to a table

    hi Qlikkers, I am obviously missing something simple here but I cannot figure it why this does not work. I created a script below to demonstrate the issue. I have one main table called enc which has unique key encid for that table. I also created a copy of that key as enc2. Then I have another table called ord, which has multiple rows per encid. I need to do an append to ord table (this will be used for incremental load process). I expect ord table populated like that if the script runs properly: orderid,encid,ordercol11,1,old12,1,old23,1,old34,2,new45,2,new5 but I get this: encid enccol1 orderid ordercol1 1enc1 2enc24new4 2enc25new5what I am missing here? enc:load *,encid as encid2Inline [encid,enccol11,enc12,enc2];//new dataord:load * Inline [orderid,encid,ordercol14,2,new45,2,new5];// old dataCONCATENATE (ord)load * WHERE not EXISTS(encid2,encid);load * Inline [orderid,encid,ordercol11,1,old12,1,old23,1,old34,2,old45,2,old5];

  • Issue#639240: Qlik - Issue in excel export// data not coming in number format

    Hello All, I have a straight chart , in which i am showing data as both (%, and as normal number) and it is working fine is QlikView.But when i export the table into excel the data comes in text format in excel. Please find the attached dummy application. I am using "pick (match" in my scenario to meet my requirements. Any suggestions and help will be really appreciated. RegardsKC

  • Issue#745372: Qlik - Issue of loading the data

    Assume that I do have two tables.Table1:IDAC1AC2AC3AC Table2:IDAB2AB4AB5AB My task is to concatenate both tables with one option.I have to remove all the IDs from Table2 that are the same in Table1. I am looking for most efficient way to do that. Thank you for your ideas!

  • Issue#840910: Qlik - What is the best way to send data from Qlikview to a Web fron-tend environment

    We have a requirement where we want to use some of the data in an Existing Qlikview model in a secondary development which is web based (.NET). The data is already prepared in the Qlikview model so we do not want to replicate that logic again in the .NET application.

  • Issue#855025: Qlik - How to import a row of data from Excel into Qlikview

    Hello, I am trying to import a row of data from Excel into Qlikview. Unfortunately, I am unable to change the row (consisting of location ID #'s) to columns due to contractual reasons. I want to have this row of data be treated like a column, in that I want to be able to load it in as shown below so I can use it for reference with SQL Server. Row 10 has the ID's I need to be able to use to link the entries to the SQL data. The 'RowNo() = 10' shown below is not working on reading in Row 10. I would really appreciate any help in figuring out how to correctly write this statement to read in Row 10. LOAD D, E, F, G, H, I, J, K,RowNo() = 10FROM[Location] (ooxml, no labels, table is [table]) WHERE RecNo() >= 11;  Any help is greatly appreciated. Thanks, Alec

  • Issue#1107294: Import data from web as logged in user

    Hello, I'd like to import data from http://markets.ft.com/data/equities/tearsheet/financials?s=NVG:LIS&subview=IncomeStatement to Power BI Desktop. As a user of ft.com I have access to 5 years of data, but when I try to import the data to Power BI Desktop, I'm not logged in to ft.com so I can only get 3 years. Is it possible to import the page as a logged in user? Thank you so much for helping!

  • Issue#120: Qlik - Importing Data from SQL Server into Qlik

    Hi Community, I import Data from SQL Server into Qlik.it is possible to create a procedure to update the Qlik data at time intervals (every hour, every xx hour)Similar extension RELOAD but with the possibility to schedule the update automatically every xx hours

  • Issue#1281: Qlik - Chart to display data only for last 6 months

    Hello, I want to create some pie charts but I want my data to be only for the last 6 months, not longer. I want to count(Distinct CaseNumber) based by the field 'Date'. Do you have any idea how can I achieve this ? Thank you !

  • Issue#1952: Samsung Galaxy S6 Edge: s6 edge 3g network issue (mobile data)

    sorry about my bad english..........samsung s6 edge (sm g925).slow browsing or does not work mobile data when using 3g mobile data .in 2g mobile data is ok.but issues with WCDMA. I flash two different firmwares but same problem .set APN manually. SAME PROBLEM.and i have same issues while making a call or sending a message...........its a hardware issue????? i need your help thanks in advance.............

  • Issue#3977: Unity - Unet server using Web Sockets has performance issue

    I am experiencing CPU usage issue when running Unet server (as Windows desktop build) with and without checked option "Use Web Sockets". It looks like the build is 20-30x slower with Web Sockets and profiler does not show nothing interesting. Do you experience same behaviour? Is it known issue?

  • Issue#4487: Qlik - Stored Proc issue

    Hi All A bit stuck on stored proc Trying to input parameters SQL Execute DB.usp_rp_analysis '1222','20151201','20151231'; but getting no results 1222 is required id  20151201 is from date20151231 is to dateGetting connection but no results, Any ideas why?Thanks

  • Issue#5528: Qlik - Dropping FieldName with no data

    Hi Experts -  Here is my scenario. I am concatenating different databases (with mostly different field names) and then looping through them to create different qvds for each of them by using a flag. Now the problem is that I am getting the field names from all the data bases, although with 0 values and I was wondering if there was a way to remove the extra fields before I store it in the qvd. Here is a sample script: Table1:LOAD *,  1 as FlagInline [Dim, Value1A, 1]; Concatenate (Table1)LOAD *,  2 as FlagInline [Dim, Value2A, 10]; FOR i = 1 to 2    TEMP:  NoConcatenate  LOAD *  Resident Table1  Where Flag = $(i);    STORE TEMP into Table_$(i).qvd (qvd);  DROP Table TEMP; NEXT DROP Table Table1; The 1st qvd will include Value2 and 2nd qvd includes Value1 (completely blank) is there anyway I can drop them from the qvd? Thanks for any ideas and suggestions. Best,Sunny

  • Issue#5790: Send Data from phone to ASP web API

    Hello, I am making a app for my school canteen. It's function is letting users pre-order products that are being sold there. The function of the API is to process orders safely. The address will be: catering.osgs.nl/order/api/AuthKey=<key>&regapi=<true/false>. I am not really familiar with web-services (but you will have to start somewhere). But my question is: How do I send data from my phone app to the API and send that to a desktop application? Here are some names for the data public int proid //proid are the IDs that stands for a certain product public decimal price //price stands for the price that should be paid (€) public int orderID //orderID is a unique number of 10 digits that is "connected" to a order, this will be generated by the API can you guys help me out? Thanks in advance, Hugo Woesthuis 13 years old

  • Issue#6204: DAX issue with Date data type

    I am having an issue today with a DAX formula. The scenario is as follows. I have 2 Power BI desktop files which are formatted identically. I have them linked to separate Excel workbooks which are formatted identically. I am inserting a calculated column into both datasets under "Modeling" in Power BI with the following formula: Week_Crctd = if(weeknum('Line Calls'[Date])<=52,(weeknum('Line Calls'[Date])),1)In one PBI desktop file, I receive the expected result; a whole number between 1 and 52 which varies correctly according to the [Date] value. In the other file, I receive the following error: ï»¿ As I mentioned before, both Excel files are formatted with the exact same number formatting in these columns and both PBI desktop files are formatted with the same Data Type, Format, Data Category, and Default Summarization. What gives? Thanks guys and gals

  • Issue#6382: Qlik - Why doesn't Order By work with Excel data?

    Hi, Is it me or does Order By doesn't work with Excel data loads? I tried it with numerous files and it returns a garbage after statement message. Is this a bug? I know the fix is to do a resident load and then order by but just curious.

  • Issue#7975: Qlik - Fixa data no script em unico lugar

    Tenho várias tabelas.Mas o banco de dados é muito grandepreciso limitar a clasula WHERE todos as tabelas.Pergunta teria como eu criar lugar onde eu faço isso apenas uma vez no script   SQL SELECT *FROM damiani."public"."view_receber"WHERE data>= '2015-01-01';store FormaRecebto into FormaRecebto.qvd(qvd);  SQL SELECT *FROM damiani."public"."view_x45"WHERE data>= '2015-01-01';store Vendas into Vendas.qvd(qvd);  Lembrando que uso: Calenderio:LOADDistinctDate($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY') AS CalendarDate,ceil(Month(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY'))/3) & 'Trim' as Trimestre,month(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Mês,WeekDay(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Semana,Day(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Dia,year(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Ano,monthname(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS MesAno  AutoG

  • Issue#7978: Qlik - Eliminate multiple rows of data based on the highest value.

    I have 5 columns ID                  Name                Amount        RSF1                    abc                     2345           5431                    bcd                     5432           3451                  &

  • Issue#10353: Qlik - Balance Sheet Data should show only last month data when Qtr Selected.

    I am trying to create a BS report in QlikSense and want to show it quarterly and as BS data is as of that month when i create a quarterly report the numbers add up for all the month.Is there a way we can show the value of the last month of the quarter/year values if the acct is a BS type.Thanks.

  • Issue#13801: Qlik - Setting up a new Data Source

    Hi, Where are these connections made below? I want to connect a new data source and make it available in the list below. Specify IP and stuff. Help much appreciated!