Forums for Qlik Analytic solutions. Ask questions, join discussions, find solutions, and access documentation and resources.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.
Participate in Qlik Technical Previews, submit ideas, and review documentation.
Chat with us, search Knowledge, open a Case, read the latest Updates Blog, find Release Notes, and learn about our Programs.
Learn about upcoming Qlik related events, webinars and local meetups.
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.
Get started on Qlik Community, find How-To documents, and join general non-product related discussions.
Hear directly from Qlik employees in our ten unique blogs.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.
Here you will find a list of all the Qlik Community forums.
In the latest episode, Julie Kae, who lead’s Qlik’s charge on sustainability, talks to the former vice chairman of the World Economic Forum Global Agenda Council on Water Security to discuss how data can help us move from talking into action.
I am sure this topic has been discussed tons of time but can´t find a proper answer.
Imagine you have table with Millions of registers (for example CDRs calls) and you want to split it into different qvds each of if for a certaing day.
Right now, what I am doing is a simple loop and store, something like this:
FOR vDay= $(vDayMin) to $(vDayMax)
//Load original file
from ..\work\CDRS.qvd (qvd)
//Load files for vDay
where day = $(vDay)
//Store day file
store CDRS_DATE into ..\output\$(vDay)_CDRS.qvd (qvd)
drop table CDRS_DATE;
//Decrease original file without already stored registers
where day > $(vDay)
drop table CDRS;
store CDRS_PENDING into ..\work\CDRS.qvd (qvd);
drop table CDRS_PENDING;
With this code, everything works fine, but it taked too long. CDRS original file might be over 100 million registers.
Is there anyway to do it better? some way to iterate vDay within CDRS table only once and "create" on memory CDRS_DAY tables and afterwards make a loop and store all of them?
Thanks a lot in advance.
I have date filed as DD/MM/YYYY HH:MM:SS format.
In script side will derive the 1 month, 3 month, 6 months , YOY flags.
If current date is 25/11/2022 - 1 month is --- 25/11/2022 to 24/10/2022
If current date is 26/11/2022 - 1 month is --- 26/11/2022 to 25/10/2022 Like 1 Month
If current date is 25/11/2022 - 3 month is --- 25/11/2022 to 24/9/2022
If current date is 26/11/2022 - 3 month is --- 26/11/2022 to 25/9/2022 Like 3 Month
If current date is 25/11/2022 - 6 month is --- 25/11/2022 to 24/5/2022
If current date is 26/11/2022 - 6 month is --- 26/11/2022 to 25/5/2022 Like 6 Month
is Jan to Till date and Previous year of Jan to Current date of Previous date.
Please help on this .
Hello, I used to have a Qlikview free version for my 2 personal documents. I changed computer and I'm looking to downlaod this free version again, but I cannot find it anymore. Any clue ?
If I upgrade my qlik sense server from 13.95 (September 2020) to 14.97 (November 2022), am I right in thinking all the tasks and licence allocation will remain in place and we won't have to set it all up again?
What is the best way to introduce a checksum in my load script, and fail when this is not as expected.
Until now I have used a "KPI" chart in my application, where if(sum(facts)-sum(reference)=0,'OK','Diff') However I would prefer my script to fail before saving a new version if the checksum is wrong. Both to be notified immediately of errors when working on an application but also to ensure end users keep last good load if this happens due to poor data quality in production. (Typically this happens with joins where something is expected to be unique which suddenly isn't)
Here's an example where the last piece is for explanation and not expected to work.
Reference: Load * Inline [ CatREF,ValueREF a , 1 b , 2 c , 3 ]; Facts: Load CatREF as Cat , ValueREF as Value Resident Reference; //<--- adding stuff to the Facts table which may duplicate content by accident--> if sum(Value)-sum(ValueREF)=0 then Trace Checksum OK 😄 ; Else Trace Checksum Failed; Exit Script;
I am trying to create ODAG links using the ODAG API, but am getting a "Method Not Allowed" error. I've been successful in using all Repository APIs using the same method and am at a loss about why ODAG doesn't work.
Error: "The remote server returned an error: (405) Method Not Allowed."
Is it possible to create a new table (tables) from visualization component and insert/initialize data from visualization code? If there is some example code somewhere it would be excellent help.
(QuickTableViewer component was a great example how to query tables and fields and let user to choose from them. Now I would need a way to create tables and initial data according to users selection).
I have a pivot table, and I'd like to show % of Change based on the previous year. Below is my dummy data.
DummySales: Load *, DayStart(Floor(Num([Sales Date]))) AS %fact_calendar_key, ; Load *, Date#(SalesDateTxt, 'YYYY-MM-DD') As 'Sales Date' ; Load * Inline [ 'Product', 'Amount', 'SalesDateTxt' 'Car Jacks', 5000, '2018-10-10' 'Car Jacks', 1200, '2017-10-11' 'Car Jacks', 2500, '2016-10-09' 'SUV Jacks', 400, '2018-09-10' 'SUV Jacks', 1200, '2017-09-11' 'SUV Jacks', 300, '2016-09-09' ] ; Drop Field SalesDateTxt; MasterCalendar: Left Keep(DummySales) LOAD DayStart(Floor(Num(TempDate))) AS %fact_calendar_key, Date(DayStart(TempDate)) AS CalDate, Dual(Year(TempDate), Year(TempDate)) AS Year, ; //=== Generate a temp table of dates === LOAD DATE(mindate + IterNo()) AS TempDate, mindate, maxdate // Used in InYearToDate() above, but not kept WHILE mindate + IterNo() <= maxdate; //=== Get min/max dates from Field ===/ LOAD MIN(FieldValue('%fact_calendar_key', recno()))-1 as mindate, MAX(FieldValue('%fact_calendar_key', recno())) as maxdate AUTOGENERATE FieldValueCount('%fact_calendar_key'); EXIT Script ;
What I am trying to achieve is something like the following:
What I've tried is
But that doesn't work, because it's looking at the Max of the selectable years, not the value of the current year dimension.
I would like to use Set Analysis if possible, and avoid using Above or other charting keywords.
Any help is greatly appreciated.
I have a variable 'Fund' in my Table1 and for any NULL values i would like it to match the document_number and document_date from Table1 with the Document_Number_Blank and Docuemnt_Date_Blank from mapping file and if it is a match then I would like to populate 'Fund' with the Fund_Blank from the MappingFile. I wrote the script below but continue to get an error saying it cant find Document_Number_Blank. Appreciate any help!
If(Len(Trim(Fund))=0 or Isnull(Fund) and [Document_Number]=Document_Number_Blank and "Document Date" = Document_Date_Blank ,Fund_Blank, if(Len(Trim(Fund))=0 or Isnull(Fund),'Missing Fund', Fund)) as Fund
Has anyone had success with placing a button, within a Qlik Sense Enterprise app, that allows the users to initiate an app reload? Any experiences, articles, or resources the community could share? Is this possible/recommended? Uncertified or paid Extensions are not an option for this client.
I think it can be done, but I also think any user that can activate the button/reload, must be an ADMIN or have an elevated security rule(s). Would this increase license costs through the type of license needed? Could ANALYZERS trigger the reload?
Thank you so much for your attention and participation.
Our featured member for November 2022
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Discover your data swagger at a city near you.
Subscribe to our Events and Webinar page so you do not miss an event
Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.
There is more than one way to find upcoming events, look on the right side
of any Qlik Community forum!