Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 215,303 members
  • 5,732 online
  • 1,991,612 posts
  • 149,200 Solutions
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    $() Expansion is ignoring the dimension filters in a chart table

    Hello Qlik lovers, I have an interesting case that I came across and I hope you can help me solve it. For this case, I am trying to filter against a n... Show More

    Hello Qlik lovers, I have an interesting case that I came across and I hope you can help me solve it.

    For this case, I am trying to filter against a numeric field [KPI_Code]

    I created a Table and inserted [KPI_Code] as a Dimension.

    I have 2 expressions, the results are in the table below

    Expression A: Max(KPI_Code)

    Expression B: Aggr(Only({<KPI_Code={"$(=Max(KPI_Code))"}>}KPI_Code),KPI_Code)

    when I use a dollar sign expansion, it always gives me the maximum number in the dataset, disregarding the dimension value.

    How can I use $() and still get values just like in Expression A ???

    ------------

    Note: I need to use the $() because I need the output value inside a variable to call its expression

    Example: vKPI_$()_Expression

    if the $() resulted in 1001 then the variable would become  vKPI_1001_Expression and I would use it's saved expression output in the cell beside its corresponding KPI_Code

     

    KPI_Code Expression A Expression B
      1004 1004
    1001 1001 -
    1002 1002 -
    1003 1003 -
    1004 1004 1004
    Show Less
  • forum

    Qlik Application Automation

    How to send Dashboard as an image to MS Teams in QS SAAS

    Hi.   Is it possible to loop through all the sheets in a QS SAAS app, export it as an image and then send via teams?   I can only see an option for PD... Show More

    Hi.

     

    Is it possible to loop through all the sheets in a QS SAAS app, export it as an image and then send via teams?

     

    I can only see an option for PDFs but it would be nice to have it sent as an image instead.

     

    Many thanks

     

    Show Less
  • forum

    Deployment & Management

    NPRINTING VS QLIKSENSE STORY TELLING??

    Hello everyone,  I am failing to understand what advantages could bring for me to implement NPrinting.  What is the difference in capabilities between... Show More

    Hello everyone, 

    I am failing to understand what advantages could bring for me to implement NPrinting. 

    What is the difference in capabilities between NPrinting and QlikSense Story telling?

     

    thanks in advance

    Show Less
  • forum

    Techspert Events

    Q&A with Qlik: App Development

    Join Qlik's office-hours, recorded live, where our experts help you with your dashboard, app, and visualization related questions. This month's topic... Show More

    Join Qlik's office-hours, recorded live, where our experts help you with your dashboard, app, and visualization related questions. This month's topic is: App Development.

     

    Questions:

    • 01:17 - Plans to add field level triggers?
    • 01:52 - Plans to select multiple fields at once in a chart?
    • 02:55 - Is the container object different on Qlik Cloud?
    • 03:44 - How to include an image with a KPI object?
    • 06:49 - Plans to add conditions to the Layout Container?
    • 08:21 - How to change text color base on conditions?
    • 08:52 - How to get Bookmark IDs from a published app?
    • 10:28 - Does the newest NPrinting have the same functionality as 16?
    • 11:16 - How to request future functionality?
    • 12:08 - Is there a public Qlik?
    • 12:53 - Any videos on how to create a REST connection?
    • 13:55 - Why not all Cloud features in Qlik Sense Client Managed?
    • 15:06 - How to access Qlik blogs?
    • 16:19 - How to export to PowerPoint?
    • 17:17 - How do backups work with Qlik Cloud?
    • 19:18 - Is version control available?
    • 20:06 - Plans to make Straight Tables horizontal?
    • 20:33 - How to migrate QV NPrinting reports to Sense?
    • 21:33 - Is there a Gantt chart available?
    • 22:21 - Can visualisations be created from a shared drive?
    • 22:49 - How to access ESG add-on?
    • 23:11 - Does Qlik allow automation workflows?
    • 24:49 - Are there performance evaluation apps for Qlik Sense?
    • 26:15 - Will the Tool Tip be available for Pivot Table in QS?
    • 26:56 - New Pivot Table demo
    • 29:38 - Are Live reports possible?
    • 30:39 - What introductory courses are available?
    • 31:20 - Are the courses free?
    • 31:35 - How to use Maps in Qlik?
    • 32:11 - How can we calculate memory consumption on Qlik Cloud?
    • 33:08 - How to know which objects take more time to load?
    • 33:40 - Is native write back available?
    • 34:09 - Can you schedule subscriptions or file transfer?
    • 34:39 - Are there any considerations for the Layout Container?
    • 35:17 - When was the Layout Container available in Client Managed?
    • 35:51 - Can Qlik make Nursing performance dashboards?
    • 36:12 - Can users select their own data to import?
    • 37:19 - Is Big Querry connection possible in Qlik 2022?
    • 38:09 - How to create a line char with 2 Y-axis?
    • 40:09 - Can you add live text to a chart?
    • 41:58 - Does using the Layout Container affect performance?
    • 42:33 - Is there an issue connecting to Outlook SMTP email servers?
    • 43:49 - Can data connections be used in multiple spaces?
    • 44:47 - How to use company specific colors?
    • 45:58 - Can you add HTML formatted text in objects?
    • 47:07 - How to hide user-specific sheets?
    • 48:26 - How to replace the default selection with current selections?
    • 49:14 - How to add Current date to bookmarks?
    • 51:39 - Can Section Access ignore selections in the Master Calendar?
    • 52:36 - Is sheet level usage auditing possible?
    • 53:08 - What is the best custom sheet size?
    • 54:11 - Can you create a square pie chart?
    • 55:39 - Can you specify column width in a Pivot Table?
    • 56:03 - Plans for folder organization options?
    • 56:23 - Plans for a date slider for start and end date?

     

    Resources:

     

     

    Did we answer your question? Let us know by clicking the like button!

     Banner_390x200.jpg

    Click here to see video transcript

     

    @Ola_Roxendal 

    @Patrik_Lundblad 

    Show Less
  • Data and Metadata Governance

    Talend Open Studio MDM Installation

    How do we install Talend Open Studio for MDM on AWS? is it still Open source post Qlik aquisition
  • forum

    New to Qlik Analytics

    Script error: Invalid expression

    I have employee data - EmpName, Joining Date, Exit Data and added Flag value status as current, New and exit. Each month there are new and exit employ... Show More

    I have employee data - EmpName, Joining Date, Exit Data and added Flag value status as current, New and exit. Each month there are new and exit employees. The next month current is a calculated value using previous month data.

    I am getting Invalid Expression for the below script. Can someone please help me understand what is missing in the below.

    Load
    count(if(status='Current',"EmpName")) as JanExisting,

    count(if(status='Current',"EmpName"))
    +count(if(status='New' and Month='Jan',"EmpName")) -
    count(if(status='Exit' and Month='Jan',"EmpName"))
    as JanFinal
    Resident MyTable;

    Load
    JanFinal +
    count(if(status='New' and Month='Feb', "EmpName", null())) -
    count(if(status='Exit' and Month='Feb', "EmpName", null()))
    as FebFinal

    Resident MyTable;

    Load
    FebFinal +
    count(if(status='New' and Month='Mar', "EmpName", null())) -
    count(if(status='Exit' and Month='Mar', "EmpName", null()))
    as MarFinal
    Resident MyTable;

    Show Less
  • forum

    Design and Development

    REST API using HTTPS, tokens or OAUTH

    Hello everyone ! I have lately learned how to use Talend ESB and I'm able to implement a REST API. However, it uses HTTP procotole. Is there any tut... Show More

    Hello everyone !

    I have lately learned how to use Talend ESB and I'm able to implement a REST API.

    However, it uses HTTP procotole. Is there any tutorial explaining how to activate and use HTTPS ?

     

    Is there the same concerning token and OAUTH activation ?

     

    Thank you ! 0683p000009MACn.png

    Show Less
  • forum

    New to Qlik Analytics

    Add Alternative Dimension in a Stacked Bar Chart

    Hello QS experts, I am dealing with a bar chart. Here is the outcome when I only select March 2024. I'd like to add an Alternative Dimension, which i... Show More

    Hello QS experts,

    I am dealing with a bar chart. Here is the outcome when I only select March 2024.

    BoXiangWang_0-1711619802777.png

    I'd like to add an Alternative Dimension, which is the autocalendar.YearMonth.

    After adding the dimension, it seems that it couldn't fit with my current measure expression.

    The accumulation should be 359, but it shows 16 instead.

    BoXiangWang_1-1711619923028.png

    Is there any way add another expression to fit with the dynamic dimension?

    The expressions I am using are:

    Measure: 

    =
    Aggr(
    Count({<Date={"<=$(=Today())"} >} ID),
    Class , (Date,NUMERIC,ASCENDING)
    )

    Dimension:

    Date, Class

    Show Less
  • forum

    QlikView App Dev

    Mapping Load / Apply Map versus Left Join

    Mapping Load / Apply Map was functionality which was shown to us during our initial training session with QlikTech many moons ago but it is not someth... Show More

    Mapping Load / Apply Map was functionality which was shown to us during our initial training session with QlikTech many moons ago but it is not something that I have used within my scripts instead using left joins to get say description of a code into my QVD table.

    Not really sure what the benefits or differences are between using mapping and left joins and would be grateful if someone could elaborate on this for me...

    Many Thanks

    Show Less
  • forum

    Connectivity & Data Prep

    Creare un valore nuovo relativo ad una dimensione già esistente, unendo due valo...

    Buongiorno,avrei bisogno di creare un valore nuovo relativo ad una dimensione già esistente, unendo due valori relativi alla suddetta dimensione. Ad e... Show More

    Buongiorno,
    avrei bisogno di creare un valore nuovo relativo ad una dimensione già esistente, unendo due valori relativi alla suddetta dimensione. Ad esempio tra gli agenti ho l'agente 'Caio' e l'agente 'Sempronio' che devono essere aggregati nel nuovo agente 'Caio + Sempronio'.
    C'è possibilità di creare tipo un oggetto di transcodifica?
    Grazie

    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!