Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Welcome to
Qlik Community!
Recent Discussions
-
Access to raise ticket/Case
Hi Team, I am part of the Nike team, we use attunity replicate regularly to access to ingest data from Oracle and db2. I already registered with m... Show MoreHi Team,
I am part of the Nike team, we use attunity replicate regularly to access to ingest data from Oracle and db2.
I already registered with my Nike account. But Still I am not able to access(or raise one) to any existing tickets.
Name: Dheeraj Gona
Email: Dheeraj.gona@nike.com
-
Custom theme not being applied
We have created a custom theme in Qlik. This has been working, until yesterday when the theme suddenly stopped being applied, and a default Qlik theme... Show MoreWe have created a custom theme in Qlik. This has been working, until yesterday when the theme suddenly stopped being applied, and a default Qlik theme is set instead. This is strange and unpredictable behavior and curious why our previously functioning custom theme, all the sudden stops being applied. The theme is uploaded based on the JSON-file code below. This has been tested and validated in JSON-validator too. Can there be any other issues with the code? Or why can a theme all the sudden stop being applied?
{"_inherit": false,"_variables": {"@default": "#31657F","@dark": "#333333","@light": "#ffffff","@H6": "10px","@font-normal": "12px","@font-family": "Arial","@TitleSize": "16px","@SubtitleSize": "14px","@TextSize": "12px","@FooterSize": "10px","@TitleColor": " #31657F","@SubtitleColor": " #31657F","@TextColor": " #31657F","@FooterColor": "#31657F","@BackgroundColor": "#ffffff","@AxisMajorColor": "#31657F","@AxisMinorColor": "#0094cf","@vFTFMoorkegraa": "#3C3E3E","@vFTFMoerkeblaa": "#31657F","@vTFKnallBlaa": "#0094cf","@vBeige": "#F5F5DC","@vFTFOransje": "#F5981E","@vSalmon2": "#DDCAD7","@vRedSymbolColor": "#CD5C5C","@vFTFTLilla": "#C8AEF8","@vLightBrown3": "#C8AE9C","@vSalmon": "#C4A1B7","@vGrey2": "#AEC3C6","@vLightBrown2": "#AE8D77","@vViolet2": "#AC7C99","@vDarkGray": "#A2A2A2","@vBlue": "#9CA0C1","@vLightBrown": "#966E56","@vViolet": "#965B7E","@vYellowGreen": "#90AB55","@vDarkViolet": "#820666","@vGrey1": "#808080","@vBrown": "#708090","@vGreenSymbolColor": "#66CDAA","@vOlive": "#668848","@vDarkGreen": "#607E54","@vLightgray" : "#D3D3D3","@vMellomblaa": "#4a8ab1"},"customStyles": [{"cssRef": "theme.css","classRef": "sense-theme"}],"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family","backgroundColor": "@light","object": {"title": {"main": {"color": "@default","fontSize": "@TitleSize","fontFamily": "@font-family"},"subTitle": {"color": "@default","fontSize": "@SubtitleSize","fontFamily": "@font-family"},"footer": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family","backgroundColor": "@light"}},"label": {"name": {"color": "@default","fontSize": "@font-normal"},"value": {"color": "@default","fontSize": "@font-normal"}},"axis": {"title": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"},"label": {"name": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family"}},"line": {"major": {"color": "@default"},"minor": {"color": "@default"}}},"grid": {"line": {"highContrast": {"color": "@default"},"major": {"color": "@default"},"minor": {"color": "@default"}}},"referenceLine": {"label": {"name": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family"}},"outOfBounds": {"color": "@default","backgroundColor": "@default","fontSize": "@H6"}},"legend": {"title": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family"},"label": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family"}},"barChart": {"backgroundColor": "@light","title": {"main": {"color": "@default","fontSize": "@TitleSize","fontFamily": "@font-family"},"subTitle": {"color": "@default","fontSize": "@SubtitleSize","fontFamily": "@font-family"},"footer": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family","backgroundColor": "@light"}},"axis": {"title": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"},"label": {"name": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family"}},"line": {"major": {"color": "@default"},"minor": {"color": "@default"}}},"legend": {"title": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"},"label": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"}},"label": {"value": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family"}},"outOfRange": {"color": "@default"}},"boxPlot": {"backgroundColor": "@light","title": {"main": {"color": "@default","fontSize": "@TitleSize","fontFamily": "@font-family"},"subTitle": {"color": "@default","fontSize": "@SubtitleSize","fontFamily": "@font-family"},"footer": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family","backgroundColor": "@light"}},"axis": {"title": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"},"label": {"name": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family"}},"line": {"major": {"color": "@default"},"minor": {"color": "@default"}}},"box": {"whisker": {"stroke": "@default"},"line": {"stroke": "@default"},"box": {"fill": "@default","stroke": "@default"}}},"comboChart": {"backgroundColor": "@light","title": {"main": {"color": "@default","fontSize": "@TitleSize","fontFamily": "@font-family"},"subTitle": {"color": "@default","fontSize": "@SubtitleSize","fontFamily": "@font-family"},"footer": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family","backgroundColor": "@light"}},"axis": {"title": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"},"label": {"name": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family"}},"line": {"major": {"color": "@default"},"minor": {"color": "@default"}}},"legend": {"title": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"},"label": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"}}},"filterpane": {"backgroundColor": "@light","title": {"main": {"color": "@default","fontSize": "@SubtitleSize","fontFamily": "@font-family"},"subTitle": {"color": "@default","fontSize": "@SubtitleSize","fontFamily": "@font-family"},"footer": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family","backgroundColor": "@light"}}},"gauge": {"backgroundColor": "@light","title": {"main": {"color": "@default","fontSize": "@TitleSize","fontFamily": "@font-family"},"subTitle": {"color": "@default","fontSize": "@SubtitleSize","fontFamily": "@font-family"},"footer": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family","backgroundColor": "@light"}},"axis": {"title": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"},"label": {"name": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family"}},"line": {"major": {"color": "@default"},"minor": {"color": "@default"}}},"label": {"value": {"color": "@default"}}},"histogram": {"backgroundColor": "@light","title": {"main": {"color": "@default","fontSize": "@TitleSize","fontFamily": "@font-family"},"subTitle": {"color": "@default","fontSize": "@SubtitleSize","fontFamily": "@font-family"},"footer": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family","backgroundColor": "@light"}},"axis": {"title": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"},"label": {"name": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family"}},"line": {"major": {"color": "@default"},"minor": {"color": "@default"}}},"label": {"value": {"color": "@default","fontSize": "40px"}}},"kpi": {"backgroundColor": "@light","title": {"main": {"color": "@default","fontSize": "@TitleSize","fontFamily": "@font-family"},"subTitle": {"color": "@default","fontSize": "@SubtitleSize","fontFamily": "@font-family"},"footer": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family","backgroundColor": "@light"}},"label": {"name": {"color": "@default","fontFamily": "@font-family"},"value": {"fontFamily": "@font-family"}}},"lineChart": {"backgroundColor": "@light","title": {"main": {"color": "@default","fontSize": "@TitleSize","fontFamily": "@font-family"},"subTitle": {"color": "@default","fontSize": "@SubtitleSize","fontFamily": "@font-family"},"footer": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family","backgroundColor": "@light"}},"axis": {"title": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"},"label": {"name": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family"}},"line": {"major": {"color": "@default"},"minor": {"color": "@default"}}},"legend": {"title": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"},"label": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"}},"outOfRange": {"color": "@default"},"label": {"value": {"color": "@vFTFMoorkegraa","fontSize": "@font-normal","fontFamily": "@font-family"}}},"listBox": {"backgroundColor": "@light","title": {"main": {"color": "@default","fontSize": "@SubtitleSize","fontFamily": "@font-family"}},"content": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family"}},"mapChart": {"backgroundColor": "@light","title": {"main": {"color": "@default","fontSize": "@TitleSize","fontFamily": "@font-family"},"subTitle": {"color": "@default","fontSize": "@SubtitleSize","fontFamily": "@font-family"},"footer": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family","backgroundColor": "@light"}}},"pieChart": {"backgroundColor": "@light","title": {"main": {"color": "@default","fontSize": "@TitleSize","fontFamily": "@font-family"},"subTitle": {"color": "@default","fontSize": "@SubtitleSize","fontFamily": "@font-family"},"footer": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family","backgroundColor": "@light"}},"axis": {"title": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family"}},"legend": {"title": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"},"label": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"}},"label": {"name": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family"},"value": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family"}}},"pivotTable": {"backgroundColor": "@light","title": {"main": {"color": "@default","fontSize": "@TitleSize","fontFamily": "@font-family"},"subTitle": {"color": "@default","fontSize": "@SubtitleSize","fontFamily": "@font-family"},"footer": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family","backgroundColor": "@light"}},"header": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"},"content": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"}},"scatterPlot": {"backgroundColor": "@light","title": {"main": {"color": "@default","fontSize": "@TitleSize","fontFamily": "@font-family"},"subTitle": {"color": "@default","fontSize": "@SubtitleSize","fontFamily": "@font-family"},"footer": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family","backgroundColor": "@light"}},"axis": {"title": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"},"label": {"name": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family"}},"line": {"major": {"color": "@default"},"minor": {"color": "@default"}}},"legend": {"title": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"},"label": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"}},"label": {"value": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family"}}},"straightTable": {"backgroundColor": "@light","title": {"main": {"color": "@default","fontSize": "@TitleSize","fontFamily": "@font-family"},"subTitle": {"color": "@default","fontSize": "@SubtitleSize","fontFamily": "@font-family"},"footer": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family","backgroundColor": "@light"}},"header": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"},"content": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"}},"textImage": {"backgroundColor": "@light","title": {"main": {"color": "@default","fontSize": "@TitleSize","fontFamily": "@font-family"},"subTitle": {"color": "@default","fontSize": "@SubtitleSize","fontFamily": "@font-family"},"footer": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family","backgroundColor": "@light"}}},"treemap": {"backgroundColor": "@light","title": {"main": {"color": "@default","fontSize": "@TitleSize","fontFamily": "@font-family"},"subTitle": {"color": "@default","fontSize": "@SubtitleSize","fontFamily": "@font-family"},"footer": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family","backgroundColor": "@light"}},"legend": {"title": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"},"label": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"}},"branch": {"backgroundColor": "@vLightgray","label": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family"}},"leaf": {"label": {"fontSize": "@font-normal","fontFamily": "@font-family"}}},"waterfallChart": {"backgroundColor": "@light","title": {"main": {"color": "@default","fontSize": "@TitleSize","fontFamily": "@font-family"},"subTitle": {"color": "@default","fontSize": "@SubtitleSize","fontFamily": "@font-family"},"footer": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family","backgroundColor": "@light"}},"axis": {"title": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"},"label": {"name": {"color": "@default","fontSize": "@font-normal","fontFamily": "@font-family"}},"line": {"major": {"color": "@default"},"minor": {"color": "@default"}}},"legend": {"label": {"fontSize": "@font-normal","fontFamily": "@font-family","color": "@default"}},"label": {"value": {"fontSize": "@font-normal","fontFamily": "@font-family"}},"value": {"color": {"default": "@default","dark": "@dark","light": "@light"}},"shape": {"positiveValue": {"fill": "@light"},"negativeValue": {"fill": "#ccccc"},"subtotal": {"fill": "#000000"},"bridge": {"stroke": "#333333"}}}},"dataColors": {"primaryColor": "@vFTFOransje","othersColor": "@vTFKnallBlaa","errorColor": "@vFTFMoerkeblaa","nullColor": "@vFTFMoorkegraa"},"palettes": {"data": [{"name": "FTF colors","translation": "FTF colors","propertyValue": "12","type": "row","scale": ["@vFTFMoerkeblaa","@vTFKnallBlaa","@vFTFOransje","@vFTFMoorkegraa","@vSalmon2","@vRedSymbolColor","@vFTFTLilla","@vLightBrown3","@vSalmon","@vGrey2","@vLightBrown2","@vViolet2","@vDarkGray","@vBlue","@vLightBrown","@vViolet","@vYellowGreen","@vDarkViolet","@vGrey1","@vBrown","@vGreenSymbolColor","@vOlive","@vDarkGreen","@vMellomblaa"]},{"name": "FTF contrast colors","translation": "FTF 4 colors","propertyValue": "4","type": "row","scale": ["@vTFKnallBlaa","@vFTFOransje","@vFTFMoorkegraa","@vFTFMoerkeblaa"]},{"name": "First data palette","translation": "Qlik colors","propertyValue": "data-palette-1","type": "pyramid","scale": [["#4477aa"],["#4477aa", "#cc6677"],["#4477aa", "#ddcc77", "#cc6677"],["#4477aa", "#117733", "#ddcc77", "#cc6677"],["#332288", "#88ccee", "#117733", "#ddcc77", "#cc6677"],["#332288", "#88ccee", "#117733", "#ddcc77", "#cc6677", "#aa4499"],["#332288","#44aa99","#88ccee","#117733","#ddcc77","#cc6677","#aa4499"],["#332288","#44aa99","#88ccee","#117733","#999933","#ddcc77","#cc6677","#aa4499"],["#332288","#44aa99","#88ccee","#117733","#999933","#ddcc77","#cc6677","#882255","#aa4499"],["#332288","#44aa99","#88ccee","#117733","#999933","#ddcc77","#661100","#cc6677","#882255","#aa4499"],["#332288","#6699cc","#44aa99","#88ccee","#117733","#999933","#ddcc77","#661100","#cc6677","#882255","#aa4499"],["#332288","#6699cc","#88ccee","#44aa99","#117733","#999933","#ddcc77","#661100","#cc6677","#aa4466","#882255","#aa4499"]]}],"ui": [{"name": "Palette","colors": ["@vFTFMoerkeblaa","@vTFKnallBlaa","@vFTFOransje","@vFTFMoorkegraa","@vSalmon2","@vRedSymbolColor","@vFTFTLilla","@vLightBrown3","@vSalmon","@vGrey2","@vLightBrown2","@vViolet2","@vDarkGray","@vBlue","@vLightBrown","@vViolet","@vYellowGreen","@vDarkViolet","@vGrey1","@vBrown","@vGreenSymbolColor","@vOlive","@vDarkGreen"]}]},"scales": [{"name": "FTF gradient blue","translation": "","type": "gradient","propertyValue": "q09ang","scale": ["@vFTFMoerkeblaa","@vTFKnallBlaa"]},{"name": "FTF sequential blue","translation": "","type": "class","propertyValue": "q08ang","scale": ["@vFTFMoerkeblaa","@vTFKnallBlaa"]},{"name": "FTF gradient salmon","translation": "","type": "gradient","propertyValue": "q07ang","scale": ["@vDarkViolet","@vSalmon"]},{"name": "FTF sequential salmon","translation": "","type": "class","propertyValue": "q06ang","scale": ["@vDarkViolet","@vSalmon"]},{"name": "Qlik Sequential Gradient","translation": "Qlik Sequential Gradient","propertyValue": "sg","type": "gradient","scale": ["#1A2980","#26D0CE"]},{"name": "Qlik Sequential Classes","translation": "Qlik Sequential Classes","propertyValue": "sc","type": "class","scale": ["#d32b1d","#023474"]},{"name": "Qlik Diverging gradient","translation": "Qlik Diverging gradient","propertyValue": "dg","type": "gradient","scale": ["#1A2980","#FFFFFF","#26D0CE","#d32b1d"]},{"name": "Qlik Diverging Classes","translation": "Qlik Diverging Classes","propertyValue": "dc","type": "class","scale": ["#9C824A","#EF0107","#DB0007","#FFFFFF","#023474"]}]} -
Creating a filter based on radius
I have a field for postal code, latitude, longitude, state and city. The latitude and longitude is based on the center of the postal codes. I want to ... Show MoreI have a field for postal code, latitude, longitude, state and city. The latitude and longitude is based on the center of the postal codes. I want to be able to create a filter that pushes the data out to include other zip codes by their lat/lon coordinates based on whether the user selects 5, 10, 20, 25 or 50 mile radius. Is this possible in Qlik with the data I have available to me?
-
Facing anywhere existence error
Source: On-Prem SQL server Target: Azure SQL server We are copying 196 tables from source to target. For whole night it was running fine. Full load an... Show MoreSource: On-Prem SQL server
Target: Azure SQL server
We are copying 196 tables from source to target. For whole night it was running fine. Full load and Change processing was perfect over a night.
Suddenly we encountered this error.
-
Large Dataset Wide and Long Table Load Times Issue
Hello, I have a data set of 1.3 million rows. For a lot of the visuals I require a long table so when i create a long table it produces 153 million ro... Show MoreHello,
I have a data set of 1.3 million rows. For a lot of the visuals I require a long table so when i create a long table it produces 153 million rows. The widgets have a hard time loading that much data especially when the widget is using the long table. the long table gives me what im looking for in the visuals but the widget loading is really bad, Is there any other options that has the same functionality of the long table?
-
connecting Postgresql db via ssh ?
Hello, does anybody has experience how to get a postgresql dbase connection via ssh? I have tried the 2 possibilities with and without via Direct Acce... Show MoreHello, does anybody has experience how to get a postgresql dbase connection via ssh? I have tried the 2 possibilities with and without
-
Google Drive
Hallo Ich bekomme keine Verbindung mehr zu Google drive. Hier die Fehlermeldung: -
How to list down a record where the data is found in one table but not in anothe...
Dear gurus There are so many similar posts in here but try to understand it may takes some time. Hence i decide to post it here using my table. I hav... Show MoreDear gurus
There are so many similar posts in here but try to understand it may takes some time. Hence i decide to post it here using my table.
I have 2 tables - Staff and Form_Submission. Both table contains column 'Name' and 'UserIds'
In the load editor how am i suppose to write the script so that i want to know which staff in table Staff has never submit a form. I saw lots of example using Not Exist. Just hope that someone can help me by using my scenario here . TQ !
-
Pk handling in Oracle19c
Hi Community, I'm currently working with Oracle 19c as a source, and I've some tables without primary keys. Need to configure a task for a full load w... Show MoreHi Community,
I'm currently working with Oracle 19c as a source, and I've some tables without primary keys. Need to configure a task for a full load with Change Data Capture (CDC). How should I proceed in managing the absence of primary keys in this scenario? Your guidance on handling this situation would be greatly appreciated.
Regards,
Pranita
-
Connexion à une base de données HFSQL
Bonjour, Je rencontre actuellement un problème de connexion à une base de données hfsql Type de base de données : JDBC généralURL : jd... Show More
Lots of Qlik Talend Data Integration Sessions!
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Qlik Community How To's
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Do More with Qlik - Delivering Real-Time, Analytics-Ready Data
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
Your journey awaits! Join us by Logging in and let the adventure begin.
Leaderboard
17
12
Customer Story
Qlik Data Integration & Qlik Replicate story
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Customer Story
Building a Collaborative Analytics Space
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Location and Language Groups
Choose a Group
Join one of our Location and Language groups. Find one that suits you today!
Collaborate
Healthcare User Group
Healthcare User Group
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
All are welcome
Japan Group
Japan
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Request to join
Brasil Group
Brazil
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
open to all
Blogs
Community News
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!