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#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#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#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#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#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#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#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#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! 

  • Issue#14653: Qlik - Error loading data from SQL server

    Hello, I have started using qlikview very recently. I am trying to bring in data from two tables in sql into Qlikview. I tired using the SQL script with a few modifications. But when i run the screen it gives me read error.  This is the SQL query that work fine in Sql server management studio (like toad).  select *from ConfigTouchpoint ct, MessageFulfillment mfwhere ct.description like '%Thunderhead%'and ct.CoreProcessId = mf.CoreProcessIdand mf.CreatedDate between dateadd(month,-1,current_timestamp) and current_timestamp; I am using it as this script in qlikview MessageFullfillment:select *from ConfigTouchpoint ct, MessageFulfillment mfwhere ct.description like '%Thunderhead%'and ct.CoreProcessId = mf.CoreProcessIdand mf.CreatedDate between dateadd(month,-1,current_timestamp) and current_timestamp;store MessageFulfillment into MessageFulfillment.QVD(QVD);DROP TABLE MessageFulfillment; can anyone help me identify what the issue is with this script. i will

  • Issue#15142: Qlik - How to abort script an maintain existing data

    This may not be the best way to accomplish this.  But we are trying to not run our dashboards every night because our data only gets updated once a month.  So our plan was to put something in the start of the script that checks for a date value from a table and depending on the criteria will exit the script. The problem is that when we do that the dashboard looses all of its data and shows nothing. The question is how can we make this scenario work?  Or is there a better way to do this? I was also thinking that we could do it with dependencies with the tasks.  The problem is that the extract runs every night it just doesn't process data for that client if there is no new data.  So the dashboard will see that the extract ran no matter what.   Any ideas would be greatly appreciated.

  • Issue#16063: Qlik - Import TXT file, only show one column

    I have a few text files that are produced from IBM Cognos TM1, they have similar structure to the file I have attached.  But when I try to import them to Qlikview, they just show it as one column. The way I do it:> Edit Script > Table FilesOn the File Wizard: (see attached)I selected "Comma" as Delimiter, and "Embedded Labels" as Labels. Qlikview just doesn't show me the different columns, what have I done wrong here?  Please help. Thanks in advanced. Phyllis

  • Issue#17506: Qlik - QlikView + how qlikview can read sql server geometry data type

    Hi guys,  very technical question. I have a spatial data(geometry) store in SQL Server. I need to use that spatial data, and display the property's polygon out from QlikView.  Basically, i wanted to use Geoqlik to display out the property's polygon.  Rgds,  Jim Chan

  • Issue#19517: Occasionally missing data from output - Issue with Elapsed Time, Sample Compression, or something el

    Hi all, Hope you can help with the following. I have: A DAQ Assistant reading from 2 thermocouples at 1 Hz Sample Compression (factor of 60) to obtain the average every minute (not rolling average) Producer/consumer setup Elapsed Time which enables Write to Measurement (xlsx) every 60 seconds I ran this from 3:50pm to 7:22am the following morning. It seems to have worked, but I noticed that about once an hour, a data point is missing. Is this an issue with timing or how I set up the VI? Please advise.   Thanks!  

  • Issue#24431: Qlik - Read data from sharepoint list

    Hi all, I am facing issue with accessing sharepoint list data  through qlikview.I am making url as http://Server_Name/sites/Site_Name/_vti_bin/owssvr.dll?Cmd=Display&List=GUID&XMLDATA=TRUE but,somehow it's not connecting and not generating any xml file to find out .please suggest your solutions for the same