Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
1,838 online
Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video

Data Analytics Forums

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

Data Integration Forums

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.

Product Insight & Ideas

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 Qlik Community

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

    Qlik Sense App Development

    Sense enterprise: Image linked on data

    Hi, i must visualize an icon for each competitor of my company.When i choose an competitor, i would like see his logo images (ico).I think to load in ... Show More

    Hi, i must visualize an icon for each competitor of my company.

    When i choose an competitor, i would like see his logo images (ico).

    I think to load in competitor table a new field with a url that link a ico files.

    but it not work, what link (in what sintax form) i must to have?
    Thanks

    Regards
    Ciro

     

    Show Less
  • forum

    New to Qlik Sense

    do not load if null in load statement

    I have the following code: Loadif(Len(Trim("FIBRE 1") > 0 ) and "PERCENT 1" = '100' and wildmatch(trim("FIBRE 1"),'Viscose LENZING™ ECOVERO™' ),'Visco... Show More

    I have the following code:

     

    Load
    if(Len(Trim("FIBRE 1") > 0 ) and "PERCENT 1" = '100' and wildmatch(trim("FIBRE 1"),
    'Viscose LENZING™ ECOVERO™' ),
    'ViscoseLENZINGECOVERO100',"FIBRE 1") as ViscoseLENZINGECOVERO100,
    From......

    This creates a field called  ViscoseLENZINGECOVERO100 where the Fibre 1 = 'Viscose LENZING™ ECOVERO™'  and Percent 1 =100

     

    I also have Dimensions FIBRE 2 and FIBRE 3 and i need to add another level to the above to include

    if FIBRE2 <0 or =0 (blank)

     

    The end result should be load where fibre 1 = 'Viscose LENZING™ ECOVERO™'  and Percent 1 =100 and fibre 2 and fibre 3 blank

     

    PLease can someone help to try and include this.

    I have tried numerous ways but then lose the values which are ViscoseLENZINGECOVERO100

     

    thank you in advance

    Show Less
  • forum

    Qlik NPrinting Discussions

    Using NPrinting API in QlikSense - GET Filters

    I am trying to get the table with all my current filters and their values.  I have already gotten to the point of pulling all my users, and their corr... Show More

    I am trying to get the table with all my current filters and their values. 

     

    I have already gotten to the point of pulling all my users, and their corresponding filter selections, but getting the values of those filters is eluding me. 

     

    Does anyone have a sample script for pulling the nested fields / values tables from the filters data?

     

     

    RestConnectionMasterTable:
    SQL SELECT
    "__KEY_data",
    (SELECT
    	"id" ,
    	"name",
        "description",
        "enabled",
        "appId",
        "connectionId"
    FROM "items" FK "__FK_items")
    FROM JSON (wrap off) "data" PK "__KEY_data"
    WITH CONNECTION( URL "https://qlik-nprint.mycompany.cloud:4993/api/v1/filters", HTTPHEADER "cookie" "$(vCookie)",QUERY "Limit" "10000") );
    
    
    NPrint_Filters:
    NoConcatenate LOAD 
    *
    RESIDENT RestConnectionMasterTable;
    drop table RestConnectionMasterTable;

     

     

     

     

    Show Less
  • forum

    QlikView App Development

    Moving a field from one table to another based on dates

    Hello all,Lets say I have a table with projects and phases along with costsPhases: load * inline [ Project, phase, startdate, enddate P1, p1, 1/1/2020... Show More

    Hello all,

    Lets say I have a table with projects and phases along with costs

    Phases:
    load * inline [
    Project, phase, startdate, enddate
    P1, p1, 1/1/2020, 3/30/2020
    p1, p2, 4/1/2020, 5/1/2020
    ]
    costs
    load * inline [
    activity, account, CostDate, Cost
    a1,Act1, 1/4/2020, 1000
    a1,Act2, 2/4/2020, 3000
    a1,Act3, 4/15/2020, 2000
    ]

     

    I can create the master table of  to get to this, using joins, and interval match, but it duplicates the costs across the phases. (change Cost to Phase)

    RogerG_1-1611692288151.png

     

    but what I need is (change Cost to Phase)  How do I keep the other phases null?

    RogerG_0-1611692243858.png

     

    Show Less
  • forum

    Qlik Catalog Discussions

    Is there any Qlik platform for product and licenses (Demo or NFR)requests for Pa...

    Dear Qlik Team,I would like to request a license key (NFR) for QDC (Qlik Catalog) by using a tool.Kind regards,Jorge L.IT Leader - DT-DATA
  • forum

    Qlik Sense App Development

    How to display trends with big changes

    Hi, I have a set of data with customer, product purchased on weekly basis and quantity.in the data, there are about 1000 customers. I only want to dis... Show More

    Hi, I have a set of data with customer, product purchased on weekly basis and quantity.

    in the data, there are about 1000 customers. I only want to display the customers where there's a 30% drop or 30% jump in the quantity of orders for the most recent week. view the example below

     

    customerproductquantity 
    Johnse226
    Johnse239
    Johnse223
    Johnse227
    Johnse226
    Johnse226
    Johnse2287

     

    As you can see john has been very consistent with his purchases except his latest purchase was huge compared to his previous purchase. this is the type of customer i want to view in form of a line chart displaying the trend. 

     

    Most customers are always consistent with heir order quantity, but in case there is a 30% drop or a jump, we want to display that on a line chart showing the trend

    Show Less
  • forum

    New to Qlik Sense

    Sum Error in expression nested aggregation not allowed

    I have this in my set analysis:-Count of Order_num = 635Count of Order_num where PSTN = Yes = 257 Its doing the first part correct and showing 635 - 2... Show More

    I have this in my set analysis:-

    Count of Order_num = 635
    Count of Order_num where PSTN = Yes = 257

     

    Its doing the first part correct and showing 635 - 257 = 378
    = Count(Order_Num) - Count { <,PSTN_PROVIDE={'Yes'}> }ORDER_NUM)

    however when I say * 1084 like so,
    = Count(Order_Num) - Count { <,PSTN_PROVIDE={'Yes'}> }ORDER_NUM) * 1084

    the answer should be 409,752 however its showing as -277,953 which is incorrect

    Show Less
  • forum

    New to Qlik Sense

    Qlik Sense - Custom measure colours with expression

    I am still new to qlik sense.I am trying to set custom colours for a stacked bar chart, where each category in a measure is a different colour.I have ... Show More

    I am still new to qlik sense.

    I am trying to set custom colours for a stacked bar chart, where each category in a measure is a different colour.

    I have trawled through the community board and found no solution that worked for me. I am not at the discretion of adding extra instructions into the load data as this request is for a once off report and there are business caveats atm.

    The measure is a "status", with the categories being:

    Approved = Green

    Cancelled = black

    In progress = cyan

    Rejected = magenta

    Returned = yellow

    Incomplete = blue

    This is the expression I have been playing with, but qlik continues to say "error in expression". everything is displaying in a green colour in the expression except the "if" part, which is blue.

    I'm normally ok with formulas having worked in excel quite a bit. Where are am I going wrong? I'm sure it's something simple.

    if([PR-Authorization Status]='Approved',([alpha,0,128,0]),if([PR-Authorization Status]='Cancelled',([alpha,0,0,0]),if([PR-Authorization Status]='In progress',([alpha,0,128,128]),if([PR-Authorization Status]='Rejected',([alpha,255,255,0]),if([PR-Authorization Status]='Returned',([alpha,255,0,255]),if([PR-Authorization Status]='Incomplete',([alpha,0,0,128])))))))

     

    Show Less
  • forum

    Community Corner

    Aggregate values from joined tables

    I've got two tables, Account and Contact inner join on AccountIDThe Contact table has a JobFunction column populated with CEO or CFO or CTO.Some Accou... Show More

    I've got two tables, Account and Contact inner join on AccountID

    The Contact table has a JobFunction column populated with CEO or CFO or CTO.

    Some AccountIDs may have multiple CEO, CTO or CTOs

    I loaded the data with 

     

        if (not(JobFunction)='CEO', 1)as [Has CEO],
        if (not(JobFunction)='CTO', 1)as [Has CTO], 
        if (not(JobFunction)='CFO', 1)as [Has CFO]

     

    I need to identify the AccountIDs that do not have CEO CTO CFO

    My Table columns are AccountID  |  Has CEO  |  Has CFO  |  Has CTO

    The result I get is multiple rows of data for each AccountID

    Id like to return one row per AccountID with "Yes" or "No" in the Has CEO  Has CFO Has CTO columns

    I also tried creating the Has CEO Has CFO Has CTO columns with a formula .. Something like if the sum of the AccountID row is zero, return "No" or else return "Yes". But, this only returns "Yes" for everything

     

    =if(sum([Has CEO] <>0), 'Yes','No')

     

     

     

    Show Less
  • forum

    New to Qlik Sense

    cannot access .ap.qlikcloud.com

    i want to study Qlik Sense personally, but i found that i cannot access .ap.qlikcloud.com in China.i thought maybe it is blocked, so I do something to... Show More

    i want to study Qlik Sense personally, but i found that i cannot access .ap.qlikcloud.com in China.

    i thought maybe it is blocked, so I do something to make I can access google, however it is still cannot be accessed in this case.

    how can i use .ap.qlikcloud.com?

    Thanks!

    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