Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 217,133 members
  • 6,931 online
  • 1,994,742 posts
  • 149,481 Solutions

Welcome to Qlik Community

Recent Discussions

  • forum

    Brasil

    Multiplicar um valor por um rank(Relativo). Não estou conseguindo chegar ao valo...

      Preciso achar o Valor da Coluna 1 * Coluna 2(Relativo). Mas não estou conseguido. Preciso criar um set analysis que trate (Pois o valor correto é di... Show More

     

    Preciso achar o Valor da Coluna 1 * Coluna 2(Relativo). Mas não estou conseguido.

    Preciso criar um set analysis que trate (Pois o valor correto é diferente). 

    Preciso de ajuda. 

    Cod Valor Rank(Relativo) (Column(1)
    *
    Column(2))

    /
    1000000 (Errado)
    Valor Correto
    2061 300000 4,69% 9.689,40 14.070,00
    5277 300000 21,21% 43.817,70 63.630,00
    5543 300000 3,36% 6.932,70 10.080,00
    10757 300000 7,27% 15.025,80 21.810,00
    12305 300000 4,10% 8.461,80 12.300,00
    13248 300000 3,01% 6.213,00 9.030,00
    13697 300000 11,97% 24.739,50 35.910,00
    16923 300000 6,23% 12.882,30 18.690,00
    17459 300000 24,93% 51.509,10 74.790,00
    19201 300000 5,18% 10.710,90 15.540,00
    19303 300000 6,45% 13.333,80 19.350,00
    29976 300000 1,60% 3.307,50 4.800,00
            300.000,00

    2024-04-17_15-38-16.jpg

    Show Less
  • forum

    Qlik Replicate

    Resume processing and CDC only modifications of table filters

    Hello   We have a Qlik CDC only task and we performed a modification on a filer transformation on a table. We stopped that task , perform Import task ... Show More

    Hello

     

    We have a Qlik CDC only task and we performed a modification on a filer transformation on a table.

    We stopped that task , perform Import task with the desired modifications and perform (for mistake) resume processing of the same task.

    The filer was loaded correctly (and unexpectedly !)

    We remember in the past documentation that , if we have to perform a filter modification, we are aware that we will perform stop+import of the task (or perform modification by Qlik Enterprise Manager GUI and save the currently running task) and perform reload target

    Can you explain us what happened ? in what case resume processing is acceptable for filter modifications scanarios ?

    Lt us know

    Regards

    Alessandro Ferrario

    Show Less
  • forum

    QlikView App Dev

    Initial data reduction based on section access analysis

    Hi, If the developer forgets to check the "initial data reduction based on section access" button under Document Properties - the Section access in th... Show More

    Hi,

    If the developer forgets to check the "initial data reduction based on section access" button under Document Properties - the Section access in the script is not in affective. no data reduction is done.

    We have more than 200 models, how can I verify that the developer remembered to check it?

    how can I get an indication/report that the "initial data reduction based on section access" is checked (except from opening 200 models and see if it is checked)?

    Thanks, Elad.

     

    Show Less
  • forum

    App Development

    Set Analysis - Set Modifier difference not working as expected

    Seems like I misunderstood how the Set Modifier is meant to work.  Would appreciate if someone can clear things up for me.  I'm attaching a sample app... Show More

    Seems like I misunderstood how the Set Modifier is meant to work.  Would appreciate if someone can clear things up for me.  I'm attaching a sample application which I'm working from.   In the application is a simple data model with a table for games, a table for invites, and a table for participant. 

    What I'm trying to count is the number of times a person has chosen to ignore their invite and not participate in the game in a table format where the dimension is the person.  Should be pretty simple. 

    The number of games they have been invited to is :  sum({<NumInvites = {1}>} NumGames)

    The number of games they participated in is : sum({<NumParticipations = {1}>}NumGames)

    Shouldn't the number of games they chose not to participate in be the difference between the two sets?  

    =Sum({

      <NumInvites= {1}> -
      <NumParticipations = {1}>
    } NumGames)

     

    And, yes, I know I can change the logic to 

    sum({<NumInvites = {1}>} NumGames) - sum({<NumParticipations = {1}>}NumGames)

    but I want to understand why the difference in SetModifiers does not work.

     

     

    Show Less
  • forum

    Integration, Extension & APIs

    Extension Properties

    Hello, I am trying to develop a chart extension. I created a dropdown in the extension properties field. I want to make multiple selections from the d... Show More

    Hello,

    I am trying to develop a chart extension. I created a dropdown in the extension properties field. I want to make multiple selections from the data listed in the dropdown. Do you have a solution?

    Show Less
  • forum

    App Development

    Adding a Measure as a Dimension in Pivot Table

    I have a situation where I want a measure, like a weekly average for the dimension value to the dimension values in a pivot table. For example in the ... Show More

    I have a situation where I want a measure, like a weekly average for the dimension value to the dimension values in a pivot table. For example in the below I would like the overall average next to the state before the measure values by month.

    datagrrl_0-1712925663216.png

    Something more like this

    datagrrl_1-1712925772685.png

     

    Thanks in advance.

     

    Show Less
  • forum

    New to Qlik Analytics

    How to read the data field with pipe '|DATA|' in qlikview and display in pie cha...

    I have the below field in the database, where I need to create a pie chart with with DATA vs DOMAIN  1|DATA|-|Def|- 3|DATA|-|dafsdf|- 4|DATA|-|sdfr|- ... Show More

    I have the below field in the database, where I need to create a pie chart with with DATA vs DOMAIN 

    1|DATA|-|Def|-

    3|DATA|-|dafsdf|-

    4|DATA|-|sdfr|-

    7|DATA|-|fwef|-

    6|ABD|DOMAIN|-||-

    9|EFDS|Other||-|-

     

    The chart should reads from the abobe table (Sample) to differentiate with and display the below result (data vs domain) as

    DATA as 66%

    DOMAIN as 17%

    and Other should name as NA in 17%

    Show Less
  • forum

    New to Qlik Analytics

    Filter Selection based on Condition

    Hi team, I have filter, In that i have some values. Eg: A B C D if I select A and B its to display sum(Sales) If I select A and B and C etc its to dis... Show More

    Hi team,

    I have filter, In that i have some values.

    Eg:

    A

    B

    C

    D

    if I select A and B its to display sum(Sales)

    If I select A and B and C etc its to display count(Sales)

    For Particular Selection, I need to show one measure,

    If extra anyone Value is added in the filter it should show other measure...

     

    Thanks in Advance

     

    Show Less
  • forum

    New to Qlik Analytics

    Where clause did not filter the data

    Hello, I have this load script for one of my app in Qliksense. Table1: Load First_Name, Last_Name, Salary, Fiscal_Year SQL Select FirstName as First_N... Show More

    Hello,

    I have this load script for one of my app in Qliksense.

    Table1:

    Load

    First_Name,

    Last_Name,

    Salary,

    Fiscal_Year

    SQL Select

    FirstName as First_Name,

    LastName as Last_Name,

    Salary,

    FY as Fiscal_Year

    From XYZ_Table

    In the sheet, I have this simple table with Fiscal_Year column that shows all the data for all the years.

    User requested to filter the data to only shows the current year and two previous years. I have adjusted my code to this:

    Table1:

    Load

    First_Name,

    Last_Name,

    Salary,

    Fiscal_Year

     

    SQL Select

    FirstName as First_Name,

    LasrName as Last_Name,

    Salary,

    FY as Fiscal_Year

    From XYZ_Table

    WHERE Fiscal_Year >= (YEAR(GETDATE())-2);   //to get only year 2024 and 2023,2022//

    It loaded successfully and I got no errors, but when I go to my table in the sheet, I still see years from 2016-2021

    I am not sure what I am missing. Could someone please help me with this?

    thank you!

    Show Less
  • forum

    New to Qlik Analytics

    How do I divide every column in the table with Column 1 (start 2023)

    Hi, How do I divide every column in the table with Column 1 (start 2023)
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!