Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
904 online
Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW

Data Analytics

Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

Data Integration

Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources

Groups

Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.

Qlik Gallery

Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.

Ideation

Participate in Qlik Technical Previews, submit ideas, and review documentation.

Qlik Resources

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

Events

Learn about upcoming Qlik related events, webinars and local meetups.

Blogs

Hear directly from Qlik employees in our ten unique blogs.

About

Get started, find How-To documents, and join general non-product related discussions.

Community Sitemap

Here you will find a list of all the Qlik Community forums.

Recent Discussions

  • No Boards Found
  • forum

    QlikView App Dev

    Ordenar suma de acumulados por varias dimensiones (dealer, mes y año) en pivot

    Hola buenas tardes,Agradezco de antemano su atención, mi consulta es de "suma de acumulada en pivot".Tengo una tabla con las siguientes columnas: Conc... Show More

    Hola buenas tardes,

    Agradezco de antemano su atención, mi consulta es de "suma de acumulada en pivot".

    Tengo una tabla con las siguientes columnas: Concesionario_atencion, Año_lanza, Mes_lanza y Cantidad.

    Deseo obtener 2 Columnas Acumuladas, "Acumulado" y "Acumulado Total"

    En la columna Acumulada; se busca la suma acumulada de "Cantidad" por "Concesionario_atencion", "Año_lanza", "Mes_lanza", reiniciando en cada año.

    En el periodo Oct-2015, el valor es incorrecta de la columna "Acumulado" lo correcto es la suma de: 539 + 519 =1058, pero muestra 1077 (539 + 519 + 19).

    La expresion empleada es:

    = aggr( rangesum(above( count({<Año_lanza>}[Fechalanzamiento]),0,rowno(TOTAL))),Concesionario_atencion,Año_lanza,Mes_lanza)

    varima_0-1614618443254.png

    Y la columna Acumulada Total debe mostrar la suma de cada fila y reiniciar al ser un Concesionario distinto "Concesionario_atencion"

    Expresion empleada:

    = aggr( rangesum(above( TOTAL count({<Concesionario_atencion>}[Fechalanzamiento]),0,rowno())),Concesionario_atencion,Año_lanza,Mes_lanza)

    Gracias.

    Si necesita mayor aclaració no dude en contactarme.

    Saludos

    Show Less
  • forum

    QlikView App Dev

    Count of a Calculated Measure

    HiI have a calculated field (CCY_SETID) in my load statement. Now I need to have the total count of (CCY_SETID) . Please helpTLMMO:LOADSET_ID,IF(Wildm... Show More

    Hi

    I have a calculated field (CCY_SETID) in my load statement. Now I need to have the total count of (CCY_SETID) . Please help

    TLMMO:

    LOAD
    SET_ID,
    IF(Wildmatch(SET_ID,'*GDS*')=1,NULL(),SET_ID) AS CCY_SETID

    FROM
    $(file)

    Show Less
  • forum

    New to Qlik Sense

    How to add a diagonal line on QlikSense Q-Q Plot

    Hi, I am currently working on a project that requires me to create a diagonal line on QlikSense Q-Q plot but I dont know how to do that. I have create... Show More

    Hi, I am currently working on a project that requires me to create a diagonal line on QlikSense Q-Q plot but I dont know how to do that. I have created a scatter plot on QlikSense as attached but now I need to create a diagonal line to see the distribution. Can someone please help me in creating a red diagonal line ?

    Under Measure X-Axis: =avg[value]

    Under Measure Y-Axis: =NORMINV( 1-(rank(([value])) - 0.5) / count(distinct total [value]) , 0,1)

    Show Less
  • forum

    QlikView App Dev

    How to create new field with group by in qlikview

    Hi,I am new in QlikView and I have the following situation. I have a table from a load with multiple fields and I want to count how many IDs are using... Show More

    Hi,

    I am new in QlikView and I have the following situation. I have a table from a load with multiple fields and I want to count how many IDs are using the same Product ID in each month. So I need to create a new column named: "check offers" as per below table:

    IDID NameID Year MonthProduct IDOffer TypeMonthNo of productscheck offers
    22A company2019-01applesingle2133
    22A company2019-01applesingle311
    22A company2019-01applesingle4151
    22A company2019-01applesingle552
    44B company2019-08applesingle2103
    44B company2019-08watermelonsingle251
    44B company2019-08watermelonsingle421
    55C company2019-08applesingle2103
    55C company2019-01applesingle552

     

    So far my script looks like this:

     

    Table1:
    LOAD [D],
    [ID Name],
    [ID Year Month],
    [Product ID],
    [Offer Type],
    [Month],
    [No of products]

    FROM
    [\\xxxxxl\xxxxx\xxxxx\xxxxx\products.qvd]
    (qvd);


    Table2:

    LOAD
    [Product ID] as [Product],
    [Month] as [Month_date],
    count([Products ID]) as [check offer]

    RESIDENT TB1
    GROUP BY
    [Month],
    [Product ID];

     

    But this doesn't bring me the result I want.

    Can you help with a solution? I want to keep all columns from my load + create the new column by 2 condition (to count how many IDs are using the same Product ID in each month).

    Thank you

    Show Less
  • forum

    Qlik Sense Data Connectivity

    progress database

    I need to connect to a Progress Database for connectivity to Qlik Sense. Has anyone done this before. I keep hearing OpenEdge but have not used it.Any... Show More

    I need to connect to a Progress Database for connectivity to Qlik Sense. Has anyone done this before.

    I keep hearing OpenEdge but have not used it.

    Any thoughts would be appreciated.

    Show Less
  • forum

    Qlik Sense App Development

    Money formatting Millions and thousands in load script

    Hi,My amount field has millions, thousands and hundreds as values. How do I convert into Money($) format as "xxxM", "xxxK", and "xxx" based on values ... Show More

    Hi,

    My amount field has millions, thousands and hundreds as values. How do I convert into Money($) format as "xxxM", "xxxK", and "xxx" based on values in load script

    Thanks

    Malini

     

    Show Less
  • forum

    New to Qlik Sense

    finding the latest Purchase orders

    Hi I have the following scenario:i have a fact table which has, the following fields:ItemCode, SupplierCode, DocDate, PurchDocNum, ObjType (has 2 type... Show More

    Hi 

    I have the following scenario:

    i have a fact table which has, the following fields:

    ItemCode, SupplierCode, DocDate, PurchDocNum, ObjType (has 2 types: 103 and 101 for each PurchDocNum)

    my mission is to Flag each combination of: ItemCode&SupplierCode  in PurchDocNum when ObjType =103 

    that have combination on ItemCode&SupplierCode when ObjType =101  in a date greater than the date is when  ObjType =103

     

    i atteached csv copy of the data

     

    thank you!

     

     

     

    Show Less
  • forum

    QlikView App Dev

    Data is not behaving properly

    Hi All , I have really great confusion over the output of the table ... As I dont see the data after reloading is working properly .Can you expertise ... Show More

    Hi All , 

    I have really great confusion over the output of the table ... As I dont see the data after reloading is working properly .

    Can you expertise please help me in fixing this ?  please find the attachment of the QVW file

    As shown in the below image the data should start from rally tame (Airport BLR 11 and respective rally prj id and rally feature . buthis is not considering this 

     

    smilingjohn_0-1615023367338.png

     

     

    Thanks in Advance

    Show Less
  • forum

    QlikView App Dev

    Converter Data e Hora

    Caros amigos,Tenho uma duvida de com devo proceder para transformar um campo data.O cenário é esse:Tenho um campo com a seguinte configuração (ele vem... Show More

    Caros amigos,

    Tenho uma duvida de com devo proceder para transformar um campo data.

    O cenário é esse:

    Tenho um campo com a seguinte configuração (ele vem do SQL)

    abaixo um exemplo dele:

    2021-01-31 02: 56: 04.000

    Já tentei algumas coisas, mas nada deu certo ....

    O que preciso:

    transformar esse campo e obter os seguintes formatos:

    1. DD / MM / AAAA

    2. Ter somente o ano (AAAA)

    3. Ter somente o mês (MM)

    Agradeço desde já por compartilharem seu conhecimento!

     

    Show Less
  • forum

    New to Qlik Sense

    Tricky Sums  in Qlik Sense

    Hi!I have users who are charged for IT-services in periods (months) while they are "active" and in some cases after they no longer are employed and ar... Show More

    Hi!

    I have users who are charged for IT-services in periods (months) while they are "active" and in some cases after they no longer are employed and are therefore "inactive".

    If a user becomes inactive and they  should no longer be charged for IT-services.

    I have a CostsAfterLastDayofEmploymentFlag on users.

    I want to show a sum (in two different pivot tables below) for IT-services still being debited in the "latest" period.

    Using sum({< CostsAfterLastDayofEmpoymentFlag={'Y'},[DataType]={'Actual'}>}[Price (SEK)]) I can see the total that the user has been debited after they became inactive.

    I have user X who was active until 202001 (jan), in 202002 (feb) they become inactive. 

    User X has been debited a number of services to a total of 18 SEK since she became inactive. I only want to see the 13 SEK total of IT-services still being debited.

    IT-Service A - 6  SEK for all periods since she became inactive  period 202002-202102 (feb last year-feb this year ie still being debited)

    IT-Service B - 5 SEK for periods  202002-202011 (feb-nov last year no longer being debited after nov)

    IT-Service C - 5 SEK for all periods since she became inactive periods 202002-202102 (feb last year-feb this year ie still being debited)

    IT-Service D - 2 SEK for all periods since she became inactive periods 202002-202102 (feb last year-feb this year ie still being debited)

    So the total since she became inactive is 18 SEK, but only 13 SEK are still being debited.

    I only want to see the total of IT-services which are still being debited in the latest period.

    So any suggestions as to how I can show only the sum IT-costs still running?

    I tried this:

     

    I made a variable vMaxPeriod variable is: =Max({<[DataType]={'Actual'},[Price (SEK)]={">0"} >} [Period])

     

    Then I used the following formula:

     

    If(Sum({$<Period={'$(=$(vMaxPeriod))'},[DataType]={'Actual'},CostsAfterLastDayofEmpoymentFlag={'Y'}>}[Price (SEK)])<>0,

    sum({< CostsAfterLastDayofEmpoymentFlag={'Y'},[DataType]={'Actual'}>}[Price (SEK)]),null())

     

     

    But returns the total of all IT-services debited on the user level after they became inactive 18 SEK but I want to see 13 SEK:

    AnnaEKinch_3-1615017948309.png

     

    AnnaEKinch_2-1615017877877.png

     

     

    Show Less

Get Started On Community

Start Here Get Started On Community

Top Participants

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements and other topics.

Blogs

Support Updates Blog

Important and useful support information about end-of-product support, new service releases, and general support topics.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.

Groups

Covid 19

We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2.

open to all

Groups

QlikView to Qlik Sense

Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.

open to all

Groups

Qlik Healthcare

This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.

750+ Members

Events

Events & Meetups

Virtual Meetups are now a possibility! With the impact of COVID-19, the Qlik Meetup network has expanded its support to include the ability to host your next Meetup online. Email QlikMeetups@qlik.com to get your virtual Meetup started!’

Events

Direct Relief Uses Qlik to Manage Its COVID-19 Supply Chain

Qlik can help you manage your supply chain risks during COVID‑19.The nonprofit organization, Direct Relief, uses Qlik’s Supply Chain solution to scale its delivery of medical supplies worldwide.

Available on Demand