Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
2,333 online

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.

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 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.


Challenge the status quo

See why Qlik (Attunity) is recognized in the 2019 Gartner Magic Quadrant for Data Integration Tools.

Recent Discussions

  • New to Qlik Sense

    "Access Denied" in Data Load Editor Qliksense

    Hi,i upgraded from 3.1 SR1 to june version of Qliksense. After Upgradation it in Load Editor when i load the app, App not get updated and throwing err... Show More

    Hi,

    i upgraded from 3.1 SR1 to june version of Qliksense. After Upgradation it in Load Editor when i load the app, App not get updated and throwing error "Access Denied"

    I am the root Admin. Please help me on this and why this error is happening.

    Capture1.PNG

    Show Less
  • New to Qlik Sense

    Setting a default filter with vizlib

    Hello, I am attempting to force a vizlib filter in my  dashboard to default to a certain value. I have two columns, one of which shows all t... Show More

    Hello, 

    I am attempting to force a vizlib filter in my  dashboard to default to a certain value. I have two columns, one of which shows all the months YTD, and one of which just shows the latest month. I would like table to be filtered to show only those rows where Month = Latest_Month upon opening the sheet or clearing any existing Month filter. 

    Any help with this would be much appreciated.

    Show Less
  • QlikView Creating Analytics

    expressions in charts

    Hi all.Please help me with the expressions in my bar chart. There is one already here but I do not know what it means?count({<[Subject] -= {"*Missi... Show More

    Hi all.

    Please help me with the expressions in my bar chart. There is one already here but I do not know what it means?

    count({<[Subject] -= {"*Missing*file*"},
    [exclude flag] = {0}>}[Subject])

     

    Basically in my chart I need the date as today date or latests date , this is d-1.

    I need to see the number of dl name , sent by, received time, and subject.

    I also need help excluding things from my script like certain email distributions and subjects. So that it is not in my charts, unless I  can do this in my charts.

    Show Less
  • QlikView Layout & Visualizations

    triggers

    Hi all. I desperetly need help!  I need to set a trigger so that all of the data on my sheets open for today -1. It is opening all the ... Show More

    Hi all.

     

    I desperetly need help! 

     

    I need to set a trigger so that all of the data on my sheets open for today -1. It is opening all the data but not today -1. The same goes for in the charts I need data to reflect today -1 . i tried to add it as a dimension but no luck.

    Show Less
  • New to QlikView

    Lookup value based on multiple conditions between two tables

    Hello everyone,I am having two tables below. Table: ABranchBuy CcyBuy AmountSell CcySell AmountAUSD200EUR190BEUR180USD190CJPY200EUR50 Table ... Show More

    Hello everyone,

    I am having two tables below. 

    Table: A

    BranchBuy CcyBuy AmountSell CcySell Amount
    AUSD200EUR190
    BEUR180USD190
    CJPY200EUR50

     

    Table B:

    CustomerBuy CcyBuy AmountSell Ccy Sell Amount
    AAEUR190USD200
    BBEUR180USD190
    CCJPY200EUR50
    DDEUR50JPY200

     

    I need to left join Table B to Table A based on multiple conditions.

    Condition 1: Left join if (Table A Buy Ccy = Table B Buy Ccy and Table A Buy Amount = Table B Buy Amount and Table A Sell Ccy = Table B Sell Ccy  and Table A Sell Amount = Table B Sell Amount) or (Table A Buy Ccy = Table B Sell Ccy and Table A Buy Amount = Table B Sell Amount and Table A Sell Ccy = Table B Buy Ccy  and Table A Sell Amount = Table B Buy Amount)

    As Brach sell and buy with the Customer but the Table B data is random. So need to compare both the combination of Ccy and Amount between two tables regardless sell or buy.

    Condition 2: A check is needed here. If there are more than one Customer in Table B match with a Branch in the Table A, leave Customer blank in the joined table. For example, both Customer CC and DD match Branch C based on the Condition 1, leave the customer blank.

    The final table should be like:

    BranchCustomerBuy CcyBuy AmountSell CcySell Amount
    AAAUSD200EUR190
    BBBEUR180USD190
    C JPY200EUR50

     

    Could you please provide the possible solution for this scenario?

    Thanks in advance. 

    Kind Regards,

    Riva 

    Show Less
  • Qlik Sense App Development

    Clickable Cells in Pivot Table 2019

    I have seen other users ask about creating clickable cells and read that it is on the roadmap, or was in 2016, what is the status on this? Can I make ... Show More

    I have seen other users ask about creating clickable cells and read that it is on the roadmap, or was in 2016, what is the status on this? Can I make my cells clickable and able to update the sheet? I see something quite close with the heat maps but can't seem to do it with the pivot table. 

    If not what are some work arounds? We are moving from SSRS which has this functionality so it looks bad to the users that the more modern solution doesn't seem to be able to handle clickable cells.

     

    Best,

    Jacob

    Show Less
  • QlikView App Development

    Pivot table not returning partial sum even after aggr function is being used

    Hi I have gone through lots of community discussion to find solution to show partial sum in pivot table. All says use aggr function, I am already usin... Show More

    Hi I have gone through lots of community discussion to find solution to show partial sum in pivot table. All says use aggr function, I am already using that.

    Can someone guide what I am missing here 

    My expression is:-

     
     

    =FirstSortedValue( [Dim C], aggr(num(rank( COUNT( {$<[Exit Rank] ={'Rank 1','Rank 2','Rank 3'}, Period={'<=$(=max(Period))'},[Year]={"$(=Year(max([Period])))"}>} EMPLID&[Exit Rank]),4)),Dim A,Dim B,Dim C))

    This expression is giving right value (I am using Dim A ,Dim B as pivot table dimension).

    But it isn't giving partial sum,IF I use Dimensionality function it gives partial sum but values are wrong.

     

     

     

     

     
     
    Show Less
  • QlikView Creating Analytics

    Trouble calculating denominator

    I am trying to get the Single Denom field to show 12 is Agenda Year is NOT 2019 and 8 if it is 2019 for the count of months to calculate the average. ... Show More

    I am trying to get the Single Denom field to show 12 is Agenda Year is NOT 2019 and 8 if it is 2019 for the count of months to calculate the average. It works some of the time but not all of the time. Any idea why? TIA!

    2019-08-20_14-07-52.jpg

    =if(year(today())=year(if(GOV_DECISION_BODY_SUB=PRIMARY_DECISION_BODY,date#(yearstart(PRIMARY_DECISION_AGENDA_DATE)),
    if(GOV_DECISION_BODY_SUB=PRIMARY_DECISION_COMMITTEE_CAT,date#(yearstart(PRIMARY_DECISION_AGENDA_DATE)),
    if(GOV_DECISION_BODY_SUB=SECONDARY_DECISION_BODY,date#(yearstart(SECONDARY_DECISION_AGENDA_DATE)),
    if(GOV_DECISION_BODY_SUB=SECONDARY_DECISION_COMMITTEE_CAT,date#(yearstart(SECONDARY_DECISION_AGENDA_DATE)),
    if(GOV_DECISION_BODY_SUB=THIRD_DECISION_BODY,date#(yearstart(THIRD_DECISION_AGENDA_DATE)),
    if(GOV_DECISION_BODY_SUB=THIRD_DECISION_COMMITTEE_CAT,date#(yearstart(THIRD_DECISION_AGENDA_DATE)),
    if(GOV_DECISION_BODY_SUB=FOURTH_DECISION_BODY,date#(yearstart(FOURTH_DECISION_AGENDA_DATE)),
    if(GOV_DECISION_BODY_SUB=FOURTH_DECISION_COMMITTEE_CAT,date#(yearstart(FOURTH_DECISION_AGENDA_DATE)),
    if(GOV_DECISION_BODY_SUB=FIFTH_DECISION_BODY,date#(yearstart(FIFTH_DECISION_AGENDA_DATE)),
    if(GOV_DECISION_BODY_SUB=FIFTH_DECISION_COMMITTEE_CAT,date#(yearstart(FIFTH_DECISION_AGENDA_DATE)),
    if(GOV_DECISION_BODY_SUB=SIXTH_DECISION_BODY,date#(yearstart(SIXTH_DECISION_AGENDA_DATE)),
    if(GOV_DECISION_BODY_SUB=SIXTH_DECISION_COMMITTEE_CAT,date#(yearstart(SIXTH_DECISION_AGENDA_DATE))))))))))))))),num(Month(today())),12)

    Show Less
  • New to Qlik Sense

    Using ColorMix2 with range greater than 100% and lower than -100%

    Hi, I am trying to get a color gradient on my Click column.I have the color gradient anything between -100%  and 100% however, anything greater o... Show More

    Hi, I am trying to get a color gradient on my Click column.

    I have the color gradient anything between -100%  and 100% however, anything greater or less than that range I am not able to get a color associated to it. 

    This is the formula i am currently using.

    if(match(only({1}Period),'WoW')>0,ColorMix2((sum({$<IsBrand=,Program=,Engine=,Device=,Category=,Week={"$(=$(vLastFullWeek))"},SharedDMA=>}Click)
    /sum({$<WeekName=, Year=,Week={"$(=$(vPriorLastFullWeek))"},IsBrand=,Program=,Engine=,Device=,Category=,SharedDMA=>}Click)-1),Lightred(),Lightgreen(),white()),
    if(match(only({1}Period),'YoY')>0,ColorMix2((sum({$<WeekName=, Year=,Week={"$(=$(vLastFullWeek))"},IsBrand=,Program=,Engine=,Device=,Category=,SharedDMA=>}Click)
    /sum({$<WeekName=, Year=,Week={"$(=$(vLastFullWeekPriorYear))"},IsBrand=,Program=,Engine=,Device=,Category=,SharedDMA=>}Click)-1),lightred(),lightgreen(),white())))

    I also attached a picture for reference of the output of my table. 

    Can someone please help?

    Show Less
  • QlikView Scripting

    Date range grouping of data

    I have a transactions data. I want to create a table having date range with account number and total amount of transactions.For example:Data:Date ... Show More

    I have a transactions data. I want to create a table having date range with account number and total amount of transactions.

    For example:

    Data:

    Date    account Number     amount

    11-July-19  XYZ                     40

    11-July-19 ABC                      20

    12-July-19 XYZ                        60

    13July-19   XYZ                       20

    13-July-19 ABC                    100

    14-July-19 ABC                      50

    16 July 2019 ABC                 40

    and so on...

     

    Desired Output for every 5 days interval (Can use a pivot table but unable to get the results):

    Date                         Account Number          Amount

    11-15 July 2019           ABC                           120

    11-15 July 2019           XYZ                           120

    12-16 July 2019          ABC                             140

    Show Less

Blogs

Qlik Community Manager Blogs

Hear from the Qlik Community team about the latest platform enhancements, announcements, and more.

Blogs

Qlik Education Blog

Check out the latest Education Blog written by Kevin Hanegan,Qlik Chief Learning Officer.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products. We have 8 blog types for you to choose from.

Groups

Join a Group

Join one of our Qlik Community user groups around an Industry, Location & Language, or Topic.

Groups

Qlik Deployment Framework

This group hosts information related to the Qlik Deployment Framework (QDF).

2700+ Members

Groups

Qlik Healthcare

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

750+ Members
Sue_Stage : List Private Messages : Sign out : Switch user COMMUNITY Qlik Community Settings for: Community Qlik Community ChooseGo to Community ADMIN STUDIO TOOLBOX DISCUSSION STYLES FEATURES SYSTEM DISPLAY CONTENT USERS MOD TOOLS METRICS COMMUNITY STRUCTURE Search for settings Announcements Custom Content Custom Pages ActiveCast Featured Threads Promoted Search Select Custom Content Setting Event Card event-card Custom Content 7 Text

Events

Qlik Insider Webinar Series

What's New in 2019. Register for the Qlik Insider Webinar Series to stay connected on our latest releases

Available On Demand Webinar

Events

Events & Meetups

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

Events

Welcome to Qlik

Join the “Welcome to Qlik” webinar and learn about the Qlik Ecosystem

Tuesday, August 27, 2019 Webinar
Show help for this page