Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
2,869 online
Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.

Here you will find Qlik Sense resources, partake in interesting discussions, solve problems and foster relationships with Qlik experts from around the globe.

Thank you for joining us in the QlikView Forum, your home for QlikView answers. Discover insights within your data that can transform your business.

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

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 eight unique blogs. Check out the new Architecture Deep Dive Blog!

Find a forum to ask a question or start a discussion.

Discussion Boards and Documents for Qlik Services.

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

Discussion board and documents related to Qlik Associative Big Data Index.

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.


Make Your Data Dance - Virtual Forum 2019

You’re managing more data than ever before. But are you getting the insights you need? The Qlik Virtual Forum is here to help you take control and make your data dance.

Recent Discussions

  • Qlik Sense App Development

    "What if" Analysis in Qlik Sense

    Hi All,is it possible to make the "what if" analysis in Qlik Sense?
  • QlikView Connectors

    SAP transport file Miss match

    Hello Experts,I am doing an SAP connector installation, and I am stuck in transferring the Transport files, I need help as in which are the correct Tr... Show More

    Hello Experts,

    I am doing an SAP connector installation, and I am stuck in transferring the Transport files, I need help as in which are the correct Transport file to be transferred. I have installed SAP connector ver 7.0.1 and SAP Basis version 751, so I Want to know which transport file is import for this SAP Connector version  7.0.1 and SAP Basis Version 751.

    Thanks,

    Subash

     

     

    Show Less
  • New to QlikView

    Running a Qlikview Script before an other Qlikview Script

    Hi,I have 2 Qlikview Scripts. I want to run a Qlikview Script 1 before running Qlikview Script 2 (for loading)How can i proceed ?Thanks in advance for... Show More

    Hi,

    I have 2 Qlikview Scripts. I want to run a Qlikview Script 1 before running Qlikview Script 2 (for loading)

    How can i proceed ?

    Thanks in advance for your answers

     

    Show Less
  • New to Qlik Sense

    how to reduce rows?

    after i choose employee and year=2019, month= may i get 2 rowsi need to show only 1 row with the last date between themso in every case i need to redu... Show More

    after i choose employee and year=2019, month= may i get 2 rows

    i need to show only 1 row with the last date between them

    so in every case i need to reduce the rows and stay with 1 row for each employee 

    in this example i need to get only the first record (31/05/2019)

    qs.jpg

    Show Less
  • Qlik Sense Data Connectivity

    Count where present in a quarter and not in another one

    Hello,I am having a lot of difficulties with a chart I would like to create. I have 4 quarters and I need to count the number of new enterprises betwe... Show More

    Hello,

    I am having a lot of difficulties with a chart I would like to create. I have 4 quarters and I need to count the number of new enterprises between different quarters as well as the closed enterprises. To do so, if the enterprise is in the first quarter and not in the second, it means that it has closed. On the contrary, if it is not present in the 1st quarter and it appears in the second one, it means it is a new one.

    I wanted to be able to choose any 2 quarters and get the result of new/closed enterprises.

    If you have any ideas, I will be more than graterful.

    Show Less
  • New to Qlik Sense

    Logic Help

    Option1:Load * Inline [Option1Million (Means will display the value in M)Full Value (Means will display the value in Integer)];Option2:Load * Inline [... Show More

    Option1:
    Load * Inline [
    Option1
    Million (Means will display the value in M)
    Full Value (Means will display the value in Integer)
    ];

    Option2:
    Load * Inline [
    Option2
    '1 M $'
    '2 M $'
    '3 M $'
    ];

    Now I have to make an expression for calculation on - 

    If I select Option1 = 'Million ' and Option2 = '1M$' Then I want the sum of Non_PTI, Where Value will be in Million which is Greater Then 1M

    If I select Option1 = 'Million ' and Option2 = '2M$' Then I want the sum of Non_PTI, Where Value will be in Million which is Greater Then 2M

    If I select Option1 = 'Million ' and Option2 = '3M$' Then I want the sum of Non_PTI, Where Value will be in Million which is Greater Then 3M

    For -->  sum({<account={'EXPENSE'}>}non_ pti)

    Else Full Value in Integer. like --> 20000000000.25614

    Can anyone make an expression with these 2 condition  for me.

    Regards,

    AK

    Show Less
  • New to Qlik Sense

    Chart table - if current row value is null, use the last non null value

    Hello there,I have some data with missing values.In the charts, I would like the last value to be used until replaced by a new value, just like the pr... Show More

    Hello there,

    I have some data with missing values.

    In the charts, I would like the last value to be used until replaced by a new value, just like the proposedvalue below.

    (note that the field proposedvalue  does not exist in the data and has been added to for this example)

    This needs to be a chart based formula only please.

    Edit - a test desktop app is now attached.

    Many thanks,

    Colinsample chart.PNG

    Months:
    Load
    date(Monthdate)as Monthdate,
    num(value) as value,
    num(proposedvalue) as proposedvalue
    ;
    Load * inline [
    Monthdate, value, proposedvalue
    01/01/2019, 1,1
    01/02/2019,  , 1
    01/03/2019,  , 1
    01/04/2019,  , 1
    01/05/2019, , 1
    01/06/2019, 2, 2
    01/07/2019,  , 2
    01/08/2019,  , 2
    01/09/2019, 1, 1
    01/10/2019, , 1
    01/11/2019, , 1
    01/12/2019,  , 1
    ]
    ;

     

     

    Show Less
  • New to QlikView

    Set analysis won't calculates per dimension or per row..so what's the solution?

    Hi All, I understand that Set analysis won't calculates per dimension or per row..so what's the solution? I need to calculate the following but i... Show More

    Hi All,

     

    I understand that Set analysis won't calculates per dimension or per row..so what's the solution? I need to calculate the following but it returns only when specific dimension is selected.

     

    (sum(Total {$< [Year] =
    , [Qtr/Yr] =
    , [Month] =
    , [Mth/Yr] = {">=$(=monthstart( vReportAsAt, -24 ))<=$(=monthstart( vReportAsAt, -13 ))"}
    ,Product=p({<Customer= {"$(=getfieldselections(Customer))"}>})
    ,Customer=
    > }
    [Customer Payment] ))

     

    I would like to calculate the value per row so i have to remove this p({<Customer= {"$(=getfieldselections(Customer))"}>}) 

    and come up with some alternative to calculate per value of dimension.

     

    please help.

     

    Gautham

    Show Less
  • Qlik Sense App Development

    CAST in DIRECT QUERY

    Hi All,I have a doubt that when i am using CAST function in DIRECT QUERY..it's not working.EX:->DIRECT QUERYSELECT​a.code_marketing_campaign,b.[Bus... Show More

    Hi All,

    I have a doubt that when i am using CAST function in DIRECT QUERY..it's not working.

    EX:->

    DIRECT QUERY

    SELECT

    a.code_marketing_campaign
    ,b.[BusinessUnit__c] as 'Parent Campaign BU'
    ,b.[CurrencyIsoCode] as ' Parent Campaign Currency Code'
    ,CAST(b.[Description]) as 'Parent Campaign Description'
    ,CAST(b.category_marketing_campaign ) as 'Parent Campaign Type'


    from (select distinct code_marketing_campaign from [WH_ID_EMEA].[dwh].[marketing_campaign]) a
    inner join [WH_ID_EMEA].[dwh].[marketing_campaign] b
    on a.code_marketing_campaign=b.bkey_marketing_campaign

    group by
    a.code_marketing_campaign
    ,b.[BusinessUnit__c]
    ,b.[CurrencyIsoCode]
    ,CAST(b.[Description])
    ,CAST(b.category_marketing_campaign );

    Please suggest..

    Show Less
  • New to Qlik Sense

    "what if Analysis"

    Hi GuysIm working on a variable which i would like to increase my total revenue in percentage...I have been doing some searching and found a way to cr... Show More

    Hi Guys

    Im working on a variable which i would like to increase my total revenue in percentage...I have been doing some searching and found a way to create a varable but it only increases my total revenue by values like 10, 20, 30 etc.. how do i change this to say 10%,20%

     

    Thanks

     

    Show Less

Blogs

Qlik Community Blogs

Check out our community blogs to stay current on the latest and greatest information about Qlik products.

7 Blogs

Groups

Join a Group

Join one of our Qlik Community groups related to an Industry, Location, Language, or Topic.

28 Groups

Events

Events & Meetups

Participate in an upcoming Qlik related event, webinar, or local meetup.