Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
1,650 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

    Qlik Sense App Development

    Filter rows in a Pivot table

    Hi!I am stuck with a task. Please, help!I have the next data:SourceData: Load * inline [SetName, Date, Type, Value, color 'A', 30/10/2020, Type_1, 1, ... Show More

    Hi!

    I am stuck with a task. Please, help!

    I have the next data:

    SourceData:
    Load * inline [SetName, Date, Type, Value, color
    'A',	30/10/2020,	Type_1,	1,  red
    'A',	26/10/2020,	Type_1,	2,  red
    'B',	30/10/2020,	Type_1,	3,  green
    'B',	26/10/2020,	Type_1,	,   green
    'C',	30/10/2020,	Type_1,	2,  red
    'C',	25/10/2020,	Type_1,	3,  red
    'D',	25/10/2020,	Type_1,	4,  green
    'A',	30/10/2020,	Type_2,	4,  red
    'A',	26/10/2020,	Type_2,	3,  red
    'B',	30/10/2020,	Type_2,	,   green
    'B',	26/10/2020,	Type_2,	,   green
    'C',	30/10/2020,	Type_2,	1,  red
    'C',	25/10/2020,	Type_2,	5,  red
    'D',	25/10/2020,	Type_2,	2,  green
    'E',	25/10/2020,	Type_2,	,   green
    'E',	26/10/2020,	Type_2,	,   green
    'E',	25/10/2020,	Type_1,	,   green
    'A'	,	  ,     Type_3,	,   black
    'B'	,	  ,     Type_3,	,   black
    'C'	,	  ,     Type_3,	,   black
    ];

     

    I have a Pivot Table where I calculate Count of Values. And filter by Color.

    I want to display all possible types always, but SetName should be filtered by Color.

    For example, when I set Color = "Black" I want to see the next result: 

    Screen1.PNG

    I use two expressions:

    1) Count( Value ) + 0 * Count( {1-1<color={"$(=(color))"}>} 0). Types display correctly, but  I see ALL values of SetName

    2) Count(Value). SetNames dysplay correctly, but Types are missing (See screenshot below)

    I marked the result what I expect in Yellow.

    Screen.PNG

    Do you have any ideas on How to solve this?  Any help is appreciated!

     

    Show Less
  • forum

    Qlik Sense App Development

    Line chart with 3 dimensions

    Hi All,  I have a requirement to create a line chart in qlik sense with three dimensions and one measure as shown below: Is it possible to create this... Show More

    Hi All, 

     

    I have a requirement to create a line chart in qlik sense with three dimensions and one measure as shown below:

     

    aswinnar_0-1607170009363.png

    Is it possible to create this chart in qlik sense? What would I need to do to create this chart? 

     

    Thanks, 

     

    Aswin Narayanan

    Show Less
  • forum

    New to Qlik Sense

    How to make Aggr work with any Dimension

    Hi, communityI've got a table with clients debts looking like thisCustomerDateDebtCustomer101/01/2020100Customer201/01/202010Customer102/01/2020200Cus... Show More

    Hi, community

    I've got a table with clients debts looking like this

    CustomerDateDebt
    Customer101/01/2020100
    Customer201/01/202010
    Customer102/01/2020200
    Customer202/01/202030

     

    I want to make a measure, calculating average debt over dates, and then sum it over customers.

    The obvious way is to use Aggr:

    My_Measure = sum(aggr(sum([Debt]) / count(distinct Date), Customer))

    and it works fine for a table with Customer as a dimension:

    CustomerMy_Measure
    Total170
    Customer1150
    Customer220

     

    But if I change the Dimension to [Date], I get the wrong result, since Aggr aggregates Date before it looks for Dimension in Table:

    DateMy_MeasureShould be
    Total170170
    01/01/2020170110
    02/01/20200230

     

    Of course, I can rewrite measure like this

    sum(aggr(sum([Debt]) / count(distinct Date), Date, Customer))

    but in this case the Total result does not work correctly (it sums to 340)

     

    Is there any workaround, how to make this measure work correctly with Customer OR Date as dimension, and woth correct Totals?

    And can I make ot work corectly with any dimensions from linked tables (for example, Month, Year, Customer_Region etc._)

    Thanks!

    Show Less
  • forum

    New to Qlik Sense

    moving annual total/ selective month_year for line chart

    Hi Masters:I now have data from Jan 19 to Oct 20, presenting as 9/1/2020.What if I only want to show the latest 12 month/ moving annual months: Nov 19... Show More

    Hi Masters:

    I now have data from Jan 19 to Oct 20, presenting as 9/1/2020.

    What if I only want to show the latest 12 month/ moving annual months: Nov 19 to Oct 20 at my line chart

    what set expression I should put? or any smart way?

    Thanks

    coloful_architect_0-1607104521881.pngcoloful_architect_1-1607104594326.png

     

    Show Less
  • forum

    New to Qlik Sense

    Filter values within a dimension?

    Dear community,i try to filter a dimension within a chart.Lets say i want to count packages for weight classes in a bar chart.Despite al lot of search... Show More

    Dear community,

    i try to filter a dimension within a chart.

    Lets say i want to count packages for weight classes in a bar chart.

    Despite al lot of searching i did not find syntax to filter packages between 5 and 10 kilogram.

    One of my attempts:

    {<pack_max_weight={'<10'},pack_max_weight={'>5'}>}pack_max_weight

    This filter shall lie beyond all other filters. That means the resulting set can be reduced even more by other filters.

    Thank you in advance

     

     

     

    Show Less
  • forum

    Qlik Sense App Development

    Restricting to first visit

    I have a requirement where I need to show a graph of the number of new visits per month for a studySo for a Study A, for visits we have to use the vis... Show More

    I have a requirement where I need to show a graph of the number of new visits per month for a study

    So for a Study A, for visits we have to use the visit types which are shown as:

    V0 

    V1

    V2

    V3

    V4

     

    V0 for example would be the new visits that I am needing to use for my chart. Other studies have different visit types for new visits like T0, or V1. What expression can I use to show the count of the first visit type? 

     

    For example, for study A if I take count of v0 for Jan I should get 24, but with the expression that I am using: 

     

    =Count({$<visittype={$(=min(visittype))}>}visittype)

    I am getting 0, not 24. Is there something wrong with the expression that I am using? 

    Show Less
  • forum

    QlikView Scripting

    adapt rank for Dimensionality

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

    The result of the set analysis:

    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

    What I need to do

    It's possible?

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

     

     

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

    Show Less
  • forum

    QlikView Scripting

    the program values for resale. How to hide Customers without sales in a variable

    In the image below, there is a Client Code that is showing the variable vFinanceiro. because I need to create a set analysis that doesn't come white.T... Show More

    In the image below, there is a Client Code that is showing the variable vFinanceiro. because I need to create a set analysis that doesn't come white.

    2020-12-05_08-16-53.jpg

    The result I need should look like this.🤔

    2020-12-05_08-26-07.jpg

    Show Less
  • forum

    QlikView Scripting

    Automatically create column(using subfiedl) in load script

    Hi folks,  I have a high level case at least for me, I have  a load script a with a big string which i need to divide several times depends on count :... Show More

    Hi folks, 

     

    I have a high level case at least for me, 

    I have  a load script a with a big string which i need to divide several times depends on count :

     

     

    Table:
    load 
    [big string],
    subfield([big_string], '&', 1) as field 1,
    subfield([big_string], '&', 2) as field 2,
    subfield([big_string], '&', 3) as field 3,
    subfield([big_string], '&', 4) as field 4,
    subfield([big_string], '&', 5) as field 5,
    subfield([big_string], '&', 6) as field 6,
    ..............
    resident temp_table;

     

     

     

    So i know have many i have '&' and know how many times i need to to use subfield,

    i want to do it fully automatically, so if i have number 10 i know that should be 10 fields with subfield if 2 there will be 2 fields with subfield, one idea that comes to my mind is using loop but how later attached that column to main column i don't know. 

     

    I can do in a very simple way to create 50 fields with 50 subfield, but i would like to have it more flexible

    Thank you in advance 

    Show Less
  • forum

    Qlik Sense App Development

    Load Multiple Excel Files from SharePoint via Web Connectors

    I'm able to load a table that is a list of Excel files in a SharePoint location. This is all done via Web Connectors. The code and results look like t... Show More

    I'm able to load a table that is a list of Excel files in a SharePoint location. This is all done via Web Connectors. The code and results look like this:

    let vQwcConnectionName = 'lib://General sharepoint connector (userID123)';

    Office365Connector_ListFiles:
    LOAD
               UniqueId as ListFiles_UniqueId,
               id as ListFiles_id
    FROM [$(vQwcConnectionName)]
    (URL IS [http://qlikselfservice:5555/data?connectorID=Office365Connector&table=ListFiles&subSite=%2fsites%2fABC20140212073005&folder=%2fsites%2fSTS20140212073005%2fMSQR%2f2.+Reporting%2f2020-04&maxResults=40&appID=&loadAccessToken=mcd2x4lxzk], qvx);

    let vQwcConnectionName = 'lib://General sharepoint connector (userID123)'; Office365Connector_ListFiles: UniqueId as ListFiles_UniqueId, id as ListFiles_id FROM [$(vQwcConnectionName)] (URL IS [http://qlikselfservice:5555/data?connectorID=Office365Connector&table=ListFiles&subSite=%2fsites%2fABC20140212073005&folder=%2fsites%2fSTS20140212073005%2fMSQR%2f2.+Reporting%2f2020-04&maxResults=40&appID=&loadAccessToken=mcd2x4lxzk], qvx);

     

    ListFiles_UniqueIdListFiles_id
    1cccww47-1702-21be-9b07-8n23858205syhttps://share.companyx.com/sites/ABC20140212073005/_api/Web/GetFileByServerRelativePath(decodedurl='/sites/STS20140212073005/path/to/directory/file01.xlsx')
    8tkt8kt8-rd54-hgfs-5ys5-ytjdtr45shs5https://share.companyx.com/sites/ABC20140212073005/_api/Web/GetFileByServerRelativePath(decodedurl='/sites/STS20140212073005/path/to/directory/file02.xlsx')
    2aag5hsn-26sr-57dd-26hs-6js5shs5hsshhttps://share.companyx.com/sites/ABC20140212073005/_api/Web/GetFileByServerRelativePath(decodedurl='/sites/STS20140212073005/path/to/directory/file03.xlsx')
    ......

     

    I want to combine all these Excel files into one giant master table in Qlik Sense. New files are added to the SharePoint location monthly, and would need to automatically be appended to the end of the master table. My thoughts on doing this were:

    for each file in filelist('lib://vQwcConnectionName/path/to/directory/*.xlsx')
    load * from [$(file)](xlsx);
    next file

    Unfortunately, this does not work. How can I load this list of Excel files and bind the rows into a giant master table?

    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