Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 215,293 members
  • 5,219 online
  • 1,991,602 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

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

    App Development

    Créer un radio button (simplefieldselect) avec comme choix 2 dimensions

    Bonjour, Je voudrais que mon utilisateur puisse filtrer soit par Catégorie, soit par métier Dans un radiobutton, soit il coche "Catégorie", et seul le... Show More

    Bonjour,

    Je voudrais que mon utilisateur puisse filtrer soit par Catégorie, soit par métier

    Dans un radiobutton, soit il coche "Catégorie", et seul le volet de filtre Catégorie s'affiche, soit il coche "Métier" et seul le volet de filtre "Métier" s'affiche.

    Je précise que mes droits sont restreints, je ne peux pas écrire de script, ni créer de champs. Je peux juste créer des variables.

     

    Show Less
  • forum

    New to Qlik Analytics

    Qlik FIlter pane

    Hi Guys, I want to how to filter max date from a field and when opening the dashboard it should get bookmark according to it. =Num(InspectionDate2)=Nu... Show More

    Hi Guys,

    I want to how to filter max date from a field and when opening the dashboard it should get bookmark according to it.

    =Num(InspectionDate2)=Num(Max(InspectionDate2)) I have tried this but it filters all dates but not pick max date.  

    Show Less
  • forum

    New to Qlik Analytics

    Map the country to a table with only city

    Hello,I have a dataset where only the city is available as location and I need to add the country to the datamodel. Do you have any suggestion how thi... Show More

    Hello,

    I have a dataset where only the city is available as location and I need to add the country to the datamodel. Do you have any suggestion how this can be done in Qlik Sense?

    I have tried using the data manager and there I can create a geocode but it seems I can't generate the country as a separate field based on the city or the geocode. I know I can create a map and see the location country there but the requirement is to see the country information in a table.

    Best Regards
    Johan

    Show Less
  • forum

    Deployment

    deployment as microservices

    Hello,I use talend studio for esb without subscription. I would like to deploy my job in microservice.The deployment tab cannot be modified. Is this b... Show More

    Hello,

    I use talend studio for esb without subscription. I would like to deploy my job in microservice.

    The deployment tab cannot be modified. Is this because I'm only using a studio version?

    Thanks

    Show Less
  • forum

    New to Qlik Analytics

    Is Qlik able to determine the country based off a city

    i have people names and then the city they belong to. However there is no country field.  Is QlikSense able to interpret the Country/Continent based o... Show More

    i have people names and then the city they belong to. However there is no country field. 

    Is QlikSense able to interpret the Country/Continent based off the City?

    Show Less
  • 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

    App Development

    Summing nine months before each month

    Hello everyone, I need to create a trend line with  dimension [Year Month]  interval YTD (jan to current month) and for each month i have to calculate... Show More

    Hello everyone,

    I need to create a trend line with  dimension [Year Month]  interval YTD (jan to current month) and for each month i have to calculate the nine month before. I have already created thi graph with this measure:

    Rangesum(above(count(Transaction),9)) and the formula works correctly if I don't apply any filter. The problem is that my dimension have to be a YTD so from January to current month but with this formulas January not include the nine month before.

     

    How can i do?

    Thanks a lot!

    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!