Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Welcome to
Qlik Community!
Recent Discussions
-
Changing The data in a table
Hi, I have a data table consisting of two fields:OPNAME, NAMESTRING (This field consists of names separated by the sign "|") For example:OP1 "ABC|ABB|... Show MoreHi,
I have a data table consisting of two fields:
OPNAME, NAMESTRING (This field consists of names separated by the sign "|")For example:
OP1 "ABC|ABB|CVV"
OP2 "VGB|ABB"
OP3 "GGG"
I want to reverse the table so that it appears in the following format:
OP1 ABC
OP1 ABB
OP1 CVV
OP2 VGB
OP2 ABB
OP3 GGGThanks to anyone who can help how to do this.
-
Qliksense Conference Orlando 2024
Hi All, I registered for the Qlik Sense Conference in Orlando 2024. The official start date of the conference is June 3rd, but I don't see any session... Show MoreHi All,
I registered for the Qlik Sense Conference in Orlando 2024. The official start date of the conference is June 3rd, but I don't see any sessions available to enroll on that day. What would be the schedule for June3rd?
Thanks -
Qlikview documents in SaaS
How can i upload a Qlikview document .qvw into Cloud and use it as binary load into my Qlik Sense App in Cloud. -
Formule couleur
Bonjour à tous, J'aimerais pouvoir intégrer une couleur différente dans mes tableaux chaque semaine, mais ma formule ne marche pas. Est-ce que vous po... Show MoreBonjour à tous,
J'aimerais pouvoir intégrer une couleur différente dans mes tableaux chaque semaine, mais ma formule ne marche pas. Est-ce que vous pourriez m'aider ?
Voici ce que je souhaite mais en semaine
Avec ma formule, j'ai qu'une couleur qui apparait
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='1','#9ca2db',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='2','#9dc5e0',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='3','#a4c77b',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='4','#9de0ce',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='5','#9ee09d',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='6','#d7e09d',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='7','#fffb94',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='8','#edd182',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='9','#e0b19d',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='10','#e09d9d',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='11','#e09dbc',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='12','#9ca2db',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='13','#9dc5e0',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='14','#a4c77b',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='15','#9de0ce',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='16','#9ee09d',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='17','#d7e09d',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='18','#fffb94',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='19','#edd182',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='20','#e0b19d',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='21','#e09d9d',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='22','#e09dbc',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='23','#9ca2db',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='24','#9dc5e0',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='25','#a4c77b',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='26','#9de0ce',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='27','#9ee09d',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='28','#d7e09d',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='29','#fffb94',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='30','#edd182',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='31','#e0b19d',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='32','#e09d9d',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='33','#e09dbc',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='34','#9ca2db',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='35','#9dc5e0',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='36','#a4c77b',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='37','#9de0ce',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='38','#9ee09d',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='39','#d7e09d',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='40','#fffb94',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='41','#edd182',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='42','#e0b19d',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='43','#e09d9d',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='44','#e09dbc',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='45','#9ca2db',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='46','#9dc5e0',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='47','#a4c77b',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='48','#9de0ce',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='49','#9ee09d',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='50','#d7e09d',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='51','#fffb94',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='52','#edd182',
if(Week([DATE_LIVRAISON_LIVRAISON.autoCalendar.Date])='53','#F6888B','#ce9de0')))))))))))))))))))))))))))))))))))))))))))))))))))))Merci
-
Monitors Installation Automation
When I run Qlik Cloud Monitoring Apps Installer it fails if I tell it to create the APIKey. If I supply my own then it all goes through no problem.Ini... Show MoreWhen I run Qlik Cloud Monitoring Apps Installer it fails if I tell it to create the APIKey. If I supply my own then it all goes through no problem.
Initial setup (APIkey not supplied)
QAA errors (1)
QAA errors (2)
Setup with APIkey supplied manually)
-
QMC tasks for Qlikview DEV Admin
Hi, there, We need to give several Qlikview users certain admin privilege on our Qlikview DEV server. Here are what we have done so far:1. Have a new ... Show MoreHi, there,
We need to give several Qlikview users certain admin privilege on our Qlikview DEV server. Here are what we have done so far:
1. Have a new AD group 'Qlikview DEV Admin' created and have users added into it.
2. On Qlikview DEV server, added 'Qlikview DEV Admin' into the 'Qlikview Administrator' group.
3. Created a new folder on Qlikview DEV server and assigned 'Qlikview DEV Admin' access to it.
4. In QMC (System -> Setup -> QDS -> General tab -> Source Folders section), added a new Path for the folder created in previous step.It works, but there is one issue. In QMC -> Status -> Tasks, 'Qlikview DEV Admin' can see/run all tasks. But we only want them to see the tasks under one particular category (MRx_COAR in the attached image). Is it possible to do that?
Thanks
-
How to Open Outlook App using VBScript Macros in QlikView
Hi All, Please can anyone explain to me how to amend my code below to open outlook app on desktop before sending the report. If the Outlook Desktop Ap... Show MoreHi All,
Please can anyone explain to me how to amend my code below to open outlook app on desktop before sending the report. If the Outlook Desktop App is not opened, the report would be in outbox until the day you open outlook on your desktop before it would send.
Sub mSendMail(pdfFilePath)
Dim objOutlk
Dim objMail
Const olMailItem = 0
' Create a new instance of Outlook application
Set objOutlk = CreateObject("Outlook.Application")
' Create a new mail item
Set objMail = objOutlk.createitem(olMailItem)
' Recipient's email address
objMail.To = "abcd@example.com"
' Subject of the email
objMail.Subject = "Testing " & Date()
' Body of the email
objMail.HTMLBody = "Body of the email, This is an automatic generated email from QlikView."
' Add attachment (use the generated PDF file)
objMail.Attachments.Add pdfFilePath
' Send the email
objMail.Send
' Release resources
Set objMail = Nothing
Set objOutlk = Nothing
End SubWhat should I add to open the desktop App if it has not opened?
Thanks.
-
QVD storing to Azure Storage
I am able to read a QVD file just fine using the Azure Store Data Connections. But when I try to write a QVD to the Azure Store location I am getting... Show MoreI am able to read a QVD file just fine using the Azure Store Data Connections. But when I try to write a QVD to the Azure Store location I am getting the following error message. The account does have RW access to the storage area.
The following error occurred:
Cannot open file:xxxxxxxxxxxxxxxxxxxx
(Native path: ***
System error: ***)
The error occurred here:
Store NewData into data connection
Thanks in advance for your help -
How to set a different background color based on value comparison with the row a...
in Qlikview please: For example, if the value in the 2nd row is lower than in the row above to be colored in green. Thank you -
Slider
Hi, is there a way to get rid of this, so i can do the last post clickable? The table hav lot's of data so it's need to be there so i can move it to t... Show MoreHi, is there a way to get rid of this, so i can do the last post clickable?
The table hav lot's of data so it's need to be there so i can move it to the right, but the last post i cannot choose.
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.
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!
Healthcare User Group
Healthcare User Group
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Japan Group
Japan
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Brasil Group
Brazil
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Blogs
Community News
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!