Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
1,357 online

Find the forums for your Qlik data analytics products to ask a question, start a discussion, or review documentation.

Find the forums for your Qlik Data Integration products to ask a question, start a discussion, or review documentation.

Welcome to the Qlik Alerting Product Forum! Join in on the discussion around Qlik’s intelligent alerting solution for Qlik Sense! This is an open group to share and collaborate!

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

Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.

Learn about the Qlik Community. Explore 'How-To' documentation, ask questions, and engage in discussion around the community platform. This will also be the place where, from time to time, we will do some fun things.

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

Join one of our Qlik Community Groups. Anyone can view content in Open Groups, but you must join to participate. Closed Groups require joining in order to view content and participate.

Hear directly from Qlik employees in our ten unique blogs. Check out the new Product Insight & Ideas Blog!

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

Recent Discussions

  • No Boards Found
  • forum

    New to QlikView

    'Stuck' Filter for user

    Hi there, I've got an issue that is affecting one user only that i'm really struggling to rectify/fix. Whenever the user logs into the Qlikview dashbo... Show More

    Hi there, I've got an issue that is affecting one user only that i'm really struggling to rectify/fix. 

    Whenever the user logs into the Qlikview dashboard they automatically have a filter applied to a field, and are unable to clear the selection. This is stopping them from using the dashboard any further at the moment. The filter is 'stuck' on a few selections within that field, but not all available options in the field.

    I have tried revoking their licence and re-setting them back up, but to no avail. There is nothing in the scripts that should restrict any data to this specific user, and we have over 50 accessing the same dashboard with no issues what so ever.

    Has anyone got any ideas on what else i could try? Happy to provide more detail!

    Show Less
  • forum

    QlikView Scripting

    If the Rank branch has zero stock. stay in red

    Set analysis:=Codigo & ' ' & concat(aggr(' - '&' FL: ' & Filial & ' ET: ' & NUM(sum(Estoque),'000000')& ' RK: ' &NUM(rank(sum(Estoque)),'00'), Codigo,... Show More

    Set analysis:

    =Codigo & ' ' & concat(aggr(' - '&' FL: ' & Filial & ' ET: ' & NUM(sum(Estoque),'000000')& ' RK: ' &NUM(rank(sum(Estoque)),'00'), Codigo, Filial),'',aggr(rank(sum(Estoque)),Codigo,Filial))

    If the Rank branch has zero stock. stay in red

    Codigo   Rank
    100 100 - FL: 2 ET: 000099 RK: 01 - FL: 3 ET: 000088 RK: 02 - FL: 1 ET: 000000 RK: 03
    101 101 - FL: 2 ET: 000151 RK: 01 - FL: 1 ET: 000150 RK: 02 - FL: 3 ET: 000044 RK: 03
    102 102 - FL: 3 ET: 000560 RK: 01 - FL: 1 ET: 000380 RK: 02 - FL: 2 ET: 000341 RK: 03

     

    2020-11-28_16-52-55.jpg

    Show Less
  • forum

    Qlik NPrinting Discussions

    Area chart not showing line in Qlik NPrinting word report

     I have  a area chart in Qlik sense  It showing line for even I got zero as a value. But ,When try to see the same chart in  Nprinting report It wont ... Show More

     

    I have  a area chart in Qlik sense  It showing line for even I got zero as a value. But ,When try to see the same chart in  Nprinting report It wont show the line.

     

    Find the below images

     

    selvakumara_0-1606118515783.png

    selvakumara_3-1606118601106.png

     

    Why the line is not showing in the report

     

     

     

    @Daniele_Purrone  Qlik NPrinting   Qlik Sense   Qlik Data Catalyst  , 

     

     

     

     

     

     

     

    Show Less
  • forum

    Qlik Sense Advanced Authoring

    More dimensions (10+) in Sankey chart

    Is it possible to have more than 5 dimensions in Sankey chart (part of the Visualization Bundle)?I remember that in the extension that was published o... Show More

    Is it possible to have more than 5 dimensions in Sankey chart (part of the Visualization Bundle)?

    I remember that in the extension that was published on Qlik Branch there was a possibility to extend the last added dimension somehow. Is this possible in this official one? Because the last release from GitHub does not work on new Qlik Sense versions.

    Show Less
  • forum

    New to Qlik Sense

    Convert SQL query into Qlik Sense

    Hi guys,I want to convert the SQL query I mentioned below into a format that qlik sense can understand. Can you help me with this?Thanks ALL"SELECTODS... Show More

    Hi guys,
    I want to convert the SQL query I mentioned below into a format that qlik sense can understand. Can you help me with this?

    Thanks ALL

    "

    SELECT
    ODS.ddd_ARC_TABLE1_EXTERNAL_ID3,
    ODS.ddd_ARC_TABLE1_EXTERNAL_ID5,
    ODS.ddd_ARC_TABLE1_NAME,
    ODS.ddd_ARC_TABLE2BATCH_ID,
    CUSTCALL.MAX_CALL_DATE,
    CUSTCALL.MIN_CALL_DATE,
    ODS.ddd_ARC_TABLE2LIST_ID,
    COUNT(ODS.ddd_ARC_TABLE2CUST_KEY),
    TRUNC(ODS.ddd_ARC_BATCH_MASTER.IMPORT_START_DATE),
    COUNT(ODS.ddd_ARC_TABLE2CUST_KEY) - COUNT(CASE WHEN PREDIAL.RESULT IN ('FLAG 1 NO','FLAG 2 NO') THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
    COUNT(CASE WHEN PREDIAL2.RESULT IN ('FLAG 1 NO','FLAG 2 NO','IP VAR,KVKK YOK') THEN ODS.ddd_ARC_TABLE2CUST_KEY END) ,
    COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE IN (12) THEN ODS.ddd_ARC_TABLE2CUST_KEY END) - COUNT(CASE WHEN PREDIAL.RESULT IN ('FLAG 1 NO','FLAG 2 NO') THEN ddd_ARC_TABLE2CUST_KEY END),
    COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE IN (1,8,9) AND ODS.ddd_ARC_TABLE2CALL_COUNT = 0 THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
    COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE NOT IN (1,8,9) THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
    COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE NOT IN (1,8,9) AND ODS.ddd_ARC_TABLE2RES_REACHED = 1 THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
    CASE WHEN COUNT(ODS.ddd_ARC_TABLE2CUST_KEY) - COUNT(CASE WHEN PREDIAL.RESULT IN ('FLAG 1 NO','FLAG 2 NO') THEN ODS.ddd_ARC_TABLE2CUST_KEY END) = 0 THEN 0
    ELSE CAST(COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE NOT IN (1,8,9) AND ODS.ddd_ARC_TABLE2RES_REACHED = 1 THEN ODS.ddd_ARC_TABLE2CUST_KEY END) AS FLOAT)
    / CAST(COUNT(ODS.ddd_ARC_TABLE2CUST_KEY) - COUNT(CASE WHEN PREDIAL.RESULT IN ('FLAG 1 NO','FLAG 2 NO') THEN ODS.ddd_ARC_TABLE2CUST_KEY END) AS FLOAT) * 100
    END ,
    COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RES_IS_SUCCESSFUL = 1 THEN ODS.ddd_ARC_TABLE2CUST_KEY END) ,
    COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE IN (7) THEN ODS.ddd_ARC_TABLE2CUST_KEY END) ,
    COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE IN (1,8,9) THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
    COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE IN (9) AND ODS.ddd_ARC_TABLE2LAST_AGENT_ID = 'DIALER' THEN ODS.ddd_ARC_TABLE2CUST_KEY END) ,
    COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE IN (8,9) AND ODS.ddd_ARC_TABLE2LAST_AGENT_ID <> 'DIALER' THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
    COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RES_CTI_ID IN (11,12) THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
    COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE IN (3) THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
    COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE IN (1,8,9) AND ODS.ddd_ARC_TABLE2CALL_COUNT = 1 THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
    COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE IN (1,8,9) AND ODS.ddd_ARC_TABLE2CALL_COUNT = 2 THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
    COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE IN (1,8,9) AND ODS.ddd_ARC_TABLE2CALL_COUNT = 3 THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
    COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE IN (1,8,9) AND ODS.ddd_ARC_TABLE2CALL_COUNT = 4 THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
    COUNT(CASE WHEN ODS.ddd_ARC_TABLE2CALL_COUNT = 5 THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
    COUNT(CASE WHEN ODS.ddd_ARC_TABLE2CALL_COUNT > 5 THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
    COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RES_EXPLANATION = 'CANCEL' THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
    TO_DATE(ODS.ddd_ARC_TABLE2EXPIRE_DATE)-TRUNC(CURRENT_DATE),
    NVL(BATCH_DETAILS2.IMPORT_EDILEMEYEN,0)
    FROM
    ODS.ddd_ARC_BATCH_MASTER RIGHT OUTER JOIN ODS.ddd_ARC_CDS ON (ODS.ddd_ARC_TABLE2BATCH_ID=ODS.ddd_ARC_BATCH_MASTER.BATCH_ID)
    LEFT OUTER JOIN (
    SELECT
    ODS.ddd_ARC_LOGDIAL.CUST_KEY ,
    ODS.ddd_ARC_LOGDIAL.RESULT
    FROM
    ODS.ddd_ARC_LOGDIAL
    WHERE
    ODS.ddd_ARC_LOGDIAL.RESULT <> 'Allowed'
    AND
    ODS.ddd_ARC_LOGDIAL.ID IN (SELECT MAX(ODS.ddd_ARC_LOGDIAL.ID) FROM ODS.ddd_ARC_LOGDIAL WHERE ODS.ddd_ARC_LOGDIAL.RESULT <> 'Allowed' GROUP BY CUST_KEY)

    ) PREDIAL ON (PREDIAL.CUST_KEY=ODS.ddd_ARC_TABLE2CUST_KEY)
    LEFT OUTER JOIN (
    SELECT
    ODS.ddd_ARC_CUSTCALL.BATCH_ID,
    MIN( ODS.ddd_ARC_CUSTCALL.CALL_DATE) AS MIN_CALL_DATE,
    MAX(ODS.ddd_ARC_CUSTCALL.CALL_DATE) AS MAX_CALL_DATE
    FROM ODS.ddd_ARC_CUSTCALL
    GROUP BY ODS.ddd_ARC_CUSTCALL.BATCH_ID
    ) CUSTCALL ON (CUSTCALL.BATCH_ID=ODS.ddd_ARC_TABLE2BATCH_ID)
    LEFT OUTER JOIN (
    SELECT
    ODS.ddd_ARC_LOGDIAL.CUST_KEY,
    ODS.ddd_ARC_LOGDIAL.RESULT
    FROM ODS.ddd_ARC_LOGDIAL
    WHERE ODS.ddd_ARC_LOGDIAL.RESULT IN ('FLAG 1 NO','FLAG 2 NO')
    AND ID IN (SELECT MAX(ODS.ddd_ARC_LOGDIAL.ID) FROM ODS.ddd_ARC_LOGDIAL
    WHERE ODS.ddd_ARC_LOGDIAL.RESULT IN ('FLAG 1 NO','FLAG 2 NO') GROUP BY ODS.ddd_ARC_LOGDIAL.CUST_KEY)
    ) PREDIAL2 ON (PREDIAL2.CUST_KEY=ODS.ddd_ARC_TABLE2CUST_KEY)
    LEFT OUTER JOIN (
    SELECT BATCH_ID, COUNT(*) AS IMPORT_EDILEMEYEN
    FROM ODS.ddd_ARC_BATCH_DETAILS
    WHERE STATUS = 2
    GROUP BY BATCH_ID
    ) BATCH_DETAILS2 ON (BATCH_DETAILS2.BATCH_ID=ODS.ddd_ARC_TABLE2BATCH_ID)
    WHERE
    ODS.ddd_ARC_TABLE2ENABLED IN ( 1 )
    GROUP BY
    ODS.ddd_ARC_TABLE1_EXTERNAL_ID3,
    ODS.ddd_ARC_TABLE1_EXTERNAL_ID5,
    ODS.ddd_ARC_TABLE1_NAME,
    ODS.ddd_ARC_TABLE2BATCH_ID,
    CUSTCALL.MAX_CALL_DATE,
    CUSTCALL.MIN_CALL_DATE,
    ODS.ddd_ARC_TABLE2LIST_ID,
    TRUNC(ODS.ddd_ARC_BATCH_MASTER.IMPORT_START_DATE),
    TO_DATE(ODS.ddd_ARC_TABLE2EXPIRE_DATE)-TRUNC(CURRENT_DATE),
    NVL(BATCH_DETAILS2.IMPORT_EDILEMEYEN,0)   "

    Show Less
  • forum

    Qlik Sense App Development

    How drawing a Matrix showing number of changes between a current and previous Cl...

    Hi,I start from this kind of Input DateNDC,Data,Class1,2020/01/01,A1,2020/02/01,B2,2020/01/01,A2,2020/02/01,A3,2020/01/01,C3,2020/02/01,A4,2020/01/01,... Show More

    Hi,

    I start from this kind of Input Date

    NDC,Data,Class
    1,2020/01/01,A
    1,2020/02/01,B
    2,2020/01/01,A
    2,2020/02/01,A
    3,2020/01/01,C
    3,2020/02/01,A
    4,2020/01/01,B
    4,2020/02/01,B
    ];

    I would like  to count the number of Class Changing of my Customer and show the results in a matrix like this.

      Current Class
      ABC
    Previous ClassA110
    B010
    C100

     

    I could calculate the previous Class in the Load Script, using previous function, but I would like to be able to do it in the presentation, may be using additional dimension (e.g Class_Prev, Class_Cur).

    Could you help me ?

    Michele

     

     

     

     

     

     

     

     

    Show Less
  • forum

    New to QlikView

    Linking web dashboard thumbnails to the qvw?

    Hi guys, I have a fully functional web dashboard used by clients with multiple qvws available. I am trying to add a new qvw but I can't find out how t... Show More

    Hi guys,

     

    I have a fully functional web dashboard used by clients with multiple qvws available. I am trying to add a new qvw but I can't find out how to link the qvw to a stored image that would act as the icon for the clients to click on via the access point page. I was able to duplicate an existing qvw and add that but I need to change the thumbnail.

     

    Can someone point me to the exact place where this connection between qvw and dashboard image happens? It's probably something really simple. I am using Qlikview 12.10.

    Show Less
  • forum

    QlikView Scripting

    rank in ascending order

    set analysis:=Codigo & ' ' & aggr(concat(aggr(',' &'Filial ' & Filial& ' Stock ' & sum(Estoque)& ' RK ' & rank(sum(Estoque)), Codigo, Filial)), Codigo... Show More

    set analysis:

    =Codigo & ' ' & aggr(concat(aggr(',' &'Filial ' & Filial& ' Stock ' & sum(Estoque)& ' RK ' & rank(sum(Estoque)), Codigo, Filial)), Codigo)

    result:

    100 ,Filial 1 Stock 100 RK 1,Filial 2 Stock 99 RK 2,Filial 3 Stock 88 RK 3
    101 ,Filial 1 Stock 150 RK 2,Filial 2 Stock 151 RK 1,Filial 3 Stock 44 RK 3
    102 ,Filial 1 Stock 380 RK 2,Filial 2 Stock 341 RK 3,Filial 3 Stock 560 RK 1

    right:✔️

    100 ,Filial 1 Stock 100 RK 1,Filial 2 Stock 99 RK 2,Filial 3 Stock 88 RK 3
    101 ,Filial 2 Stock 151 RK 1,Filial 1 Stock 150 RK 2,Filial 3 Stock 44 RK 3
    102 ,Filial 3 Stock 560 RK 1,Filial 1 Stock 380 RK 2,Filial 2 Stock 341 RK 3

    can someone help me thank you.

    2020-11-28_11-38-38.jpg

     

    Show Less
  • forum

    QlikView App Development

    Calculate time difference between timestamps on different rows

    Hello, I have a view on the table in the database that contains all orderlines to be picked in the warehouse.A person starts an order that containers ... Show More

    Hello,

     

    I have a view on the table in the database that contains all orderlines to be picked in the warehouse.

    A person starts an order that containers multiple lines for 1 customer.

    Those lines are then processed in order of closest location in the warehouse.

    When the person starts a line on his barcodescanner a "start-timestamp" is written into the table.

    now i  calculate in excel the time between the timestamp on 1 row and the time stamp on the row before, but only if the previous row has the same id_picking  and the it is being treated on is the same day.

    If the Id-picking or the date of the picking is not the same as the  previous row i add a standard time of 2 minutes, assuming that's the time it takes to start a new order or restart the same order but on the next working day.

    In excel this is rather simple, i first order all the data on the date of the picking, picking Id and then the timestamp. that way i am sure that if i compare to the previous row it is correct.

    But if i import this view into qlikview then i'm stuck on how to do this.

    Anybody who might have an idea on how to do this?

    i attached a subset of the data.

     

    thanx a lot!

     

    Chris

     

     

     

     

    Show Less
  • forum

    Qlik Catalog Discussions

    How to get percentage Difference

    Hi Everyone.I nee one help.. I calculate a Difference Between Current Year Sale and Last Yearlike..num(Sum({$<[HSUBSEGM.descr]={"Clinker and Cement"},... Show More

    Hi Everyone.

    I nee one help.. I calculate a Difference Between Current Year Sale and Last Year

    like..

    num(Sum({$<[HSUBSEGM.descr]={"Clinker and Cement"},[CALYEAR]={">=$(vCurrentYear)"}>}[_volume_SO]),'##.0')-  num(Sum({$<[HSUBSEGM.descr]={"Clinker and Cement"},[CALYEAR]={">=$(vPreviousYear)<=$(vPreviousYear)"}>}[_volume_SO]),'##.0')

    so I m getting and answer Suppose.. This Year sale is 100 Rs and Last Year sale was 50 Rs.. so total growth 50 Rs.. But I want to show growth in %.. in this case my Revenue growth is 50 %.. because it got double from last year..

    Please help me how to do this

    Show Less

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

Data Revolution Virtual Summit

The new normal requires a new approach to data. Join this event to learn about the latest trends and approaches for accelerating value from your data.

October 27 - 29, 2020 Virtual Summit

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