Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 217,569 members
  • 9,106 online
  • 1,995,383 posts
  • 149,532 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    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 More

    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|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 GGG

    Thanks to anyone who can help how to do this.

     

    Show Less
  • forum

    QlikView App Dev

    newline in expression

    HiI've tried everything but cant figure out how to insert a new line character... I would like to show these three fields below each other. nl doesn't... Show More

    Hi

    I've tried everything but cant figure out how to insert a new line character... I would like to show these three fields below each other. nl doesn't work...


    =Maxstring(If([L1] = VarL1Out and Isnull([L2]),[HoverText])) &'. Actual: '
    &Maxstring(If([L1] = VarL1Out and Isnull([L2]),[Actual])) & '. Target: '
    &Maxstring(If([L1] = VarL1Out and Isnull([L2]),[Target]))
    {/code]
    Currently the help text looks like this:
    My hovertext. Actual: 50.4. Target: 55.5
    I want to be like:
    My hovertext.
    Actual: 50.4.
    Target: 55.5</body>
    Show Less
  • forum

    Integration, Extension & APIs

    Route multiple QlikSense servers through Nginx

    Hello everyone, We have 2 QlikSense servers in our internal infrastructure and we want to expose these 2 servers externally, through Nginx.We would li... Show More

    Hello everyone,

    We have 2 QlikSense servers in our internal infrastructure and we want to expose these 2 servers externally, through Nginx.
    We would like to be able to access these servers via ourdomain.com/qliksense1 and ourdomain.com/qliksense2.
    Is it possible to configure Nginx to allow this?

    Furthermore, we also require virtual proxies for some of our custom apps and we would like to be able to access the virtual proxy via ourdomain.com/qliksense1/virtualproxy and ourdomain.com/qliksense2/virtualproxy.
    Is this possible?


    Thank you!

    Show Less
  • forum

    App Development

    Show PDF (Base64) as Picture in App

    Dear all,   I have a T-SQL table with a list of PDFs. Each PDF is a 1 single page encoded in varbinary max.   I was able to convert this varbinary to ... Show More

    Dear all,

     

    I have a T-SQL table with a list of PDFs.

    Each PDF is a 1 single page encoded in varbinary max.

     

    I was able to convert this varbinary to a base64 but I cannot display the result with 'data&colon;image/jpg;base64' into a table.

    Is there some other balise or viewer that can display base64 PDF in QlikSense ?

    Or any way to convert a PDF to PNG Base64 ?

     

    Thanks,

    Sébastien

    Show Less
  • forum

    Connectivity & Data Prep

    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 More

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

     

    Show Less
  • forum

    New to Qlik Analytics

    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 More

    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 sessions available to enroll on that day. What would be the schedule for June3rd?
    Thanks

    Show Less
  • forum

    Move to SaaS

    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.    
  • forum

    New to Qlik Analytics

    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 More

    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 pourriez m'aider ?

    Voici ce que je souhaite mais en semaine 

    stephanie29_0-1713881993116.png

    Avec ma formule, j'ai qu'une couleur qui apparait 

    stephanie29_1-1713882109038.png

    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

     

     

     

     

    Show Less
  • forum

    Qlik Application Automation

    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 More

    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.Initial setup (APIkey not supplied)Initial setup (APIkey not supplied)QAA errors (1)QAA errors (1)QAA errors (2)QAA errors (2)Setup with APIkey supplied manually)Setup with APIkey supplied manually)

    Show Less
  • forum

    Deployment & Management

    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 More

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

    Show Less
Leaderboard

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!