Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
1,909 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 nine unique blogs. Check out the new Customer Success 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.

Recent Discussions

  • QlikView App Development

    Print a Text Object

    Hi FriendsIn my QV document I have loaded data relating to vehicle parts and it is displayed in a table box as  shown below. I want the records in Tab... Show More

    Hi Friends

    In my QV document I have loaded data relating to vehicle parts and it is displayed in a table box as  shown below. Screenshot_4.png

    I want the records in Table box to be printed as labels  (to be affixed on the part)  as shown above. I think this has to be arranged a text box and then print. However I am not aware  of how to do it. I seek your help to fulfill my requirement please. 

     

    Show Less
  • Qlik Sense App Development

    How to display max of the value name in KPI

    Hello, I have a set of data like below:-Sales officeUttar Pradesh SOGujarat SODelhi   Haryana SODelhi   Haryana SOPunjab  Himachal SOKerala SOKerala S... Show More

    Hello,

     

    I have a set of data like below:-

    Sales office
    Uttar Pradesh SO
    Gujarat SO
    Delhi   Haryana SO
    Delhi   Haryana SO
    Punjab  Himachal SO
    Kerala SO
    Kerala SO
    Punjab  Himachal SO
    Punjab  Himachal SO
    TAPSO
    Uttar Pradesh SO
    Uttar Pradesh SO II
    Uttar Pradesh SO II
    Uttar Pradesh SO II

     

    I have to display the name of, max of this sales office in a KPI, where most cases were registered,How to write expression for this?

     

    In this example suppose, Uttar Pradesh SO II has max of 4 cases, so it should display 'Uttar Pradesh SO II'.

     

    Please suggest.

    Show Less
  • New to QlikView

    Rolling and ytd calculation

    Hello,I need to find rolling and YTD revenue. rolling month starts from september and ends on august. I have two years of data sep-2019 to aug-2018. i... Show More

    Hello,

    I need to find rolling and YTD revenue. rolling month starts from september and ends on august. I have two years of data sep-2019 to aug-2018. i have a text object where current year and last revenue will be displayed. so, when i select rolling in the filter, in the text object revenue should displayed as currrent year rolling revenue and last year rolling revenue.

    when i'm using the below code to get revenue, the current year revenue is coming up to be zero and last year revenue is getting switched with current year revenue. Attaching the screenshot of the dashboard for your reference.image2.png

    ='Current Year:'& Num(Sum({<[week] = {">=$(=MakeDate(Year(Today()),9,1) )<=$(=MakeDate(Year(Today())+1,8,30) )"}> } NET_SLS_AMT/1000000),'##.00')
    & ' Last Year:'&Num(Sum({<[week] = {">=$(=MakeDate(Year(Today())-1,9,1) )<=$(=MakeDate(Year(Today()),8,30) )"}> } NET_SLS_AMT/1000000),'##.00')

     

    Show Less
  • New to Qlik Sense

    How to create stacked plus grouped bar chart in Qiksense

    I have two products , each product has 3 measures related to it and Month as a dimension.I want to create a bar chart where i want to show the  stacke... Show More

    I have two products , each product has 3 measures related to it and Month as a dimension.

    I want to create a bar chart where i want to show the  stacked bars for each product for same month.n short i want to combine the grouped as well as stacked bars in same Graph.

    Can anyone help me here?

     

     
    Show Less
  • Qlik Sense App Development

    Add up/down arrows to bar chart

    Hi everyone, I have pretty simple bar chart, to which i would like to add trend arrows up/down versus the previous week.I have a few 'Alternative dime... Show More

    Hi everyone,

     

    I have pretty simple bar chart, to which i would like to add trend arrows up/down versus the previous week.

    Screenshot - 9_12_2019 , 12_10_15 PM.png

    I have a few 'Alternative dimensions' within this chart.

     

    I have found a tutorial however i didn't manage to replicate the same logic (mainly because i am using QlikSense not QlikView).

     

    Below is my current Measure:

    =if((GetFieldSelections([Quote Type])='DQ' OR GetSelectedCount([Quote Type])=0),

    If(GetSelectedCount([Week Num])=0,
    Sum({$<[Quote Type]={"DQ"}, [Week Num]={"$(=week(today())-1)"}>} TEU)/Sum({$<[Week Num]={"$(=week(today())-1)"}>} TEU)
    ,
    Sum({$<[Quote Type]={"DQ"}>} TEU)/sum(TEU)),

    'N/A')

     

    Appreciate any help.

    Fabien

    Show Less
  • New to QlikView

    Count IF Multiple Conditions

    Hi guys, I would just like to seek help on how I can COUNT the occurrence of values greater AND smaller than 10.For example, I have in the table:ID 10... Show More

    Hi guys,

     

    I would just like to seek help on how I can COUNT the occurrence of values greater AND smaller than 10.
    For example, I have in the table:

    ID 1000.

    IDNum1Num2Num3Num4
    10001203040
    1001125060
    1002457080
    10033590100
    100412320
    100578950

     

    Numbers <= 10: only number 1;
    Numbers > 10: numbers 20, 30, 40;

    So the result would be:
    There are 1 number <= 10 and 3 numbers > 10 -- 1 low 3 high

    For the ID 1001, 2 low 2 high and so on.

    And the graph would be as follows (see attachment):

    My script is attached.

    //--------------------------------------------------

    TBL_LOAD:

    LOAD * INLINE [
    ID, Num1, Num2, Num3, Num4
    1000, 1, 20, 30, 40
    1001, 1, 2, 50, 60
    1002, 4, 5, 70, 80
    1003, 3, 5, 90, 100
    1004, 1, 2, 3, 20
    1005, 7, 8, 9, 50
    ];
    //-------------------------------

    TRANSFORM_CONCAT:
    LOAD
    ID,

    //Concatenate numbers separated by the "blank" string row by row

    [Num1]&' '&[Num2]&' '&[Num3]&' '&[Num4] as Num_Concat

    //1 20 30 40
    //1 2 50 60
    //and so on...

    Resident TBL_LOAD;

    //-------------------------------

    TRANSFORM_NUMBERS:

    LOAD

    //Create Numbers dimension with all numbers

    Num_Concat,
    subfield(Num_Concat,' ') as Numbers 

    Resident TRANSFORM_CONCAT;

    TRANSFORM_LOW_HIGH:

    LOAD Numbers,
    // Here, I'm utterly confused by my count if expressions

    If(count(if(Numbers<=10,Numbers)) =1 AND count(if(Numbers>10,Numbers))=3, '1 Low 3 High',
    If(count(if(Numbers<=10,Numbers)) =2 AND count(if(Numbers>10,Numbers))=2, '2 Low 2 High',
    If(count(if(Numbers<=10,Numbers)) =3 AND count(if(Numbers>10,Numbers))=1, '3 Low 1 High',

    'Others'))) as Count_Low_High

    Resident TRANSFORM_NUMBERS;


    Best regards,

    Show Less
  • New to Qlik Sense

    REST Connector with PUT, DELETE etc.

    Hello,I want to know if I can use PUT, DELETE, GET, HEAD in the Qlik Sense REST connector? I can choose between the following protocols in Qlik Sense:... Show More

    Hello,

    I want to know if I can use PUT, DELETE, GET, HEAD in the Qlik Sense REST connector? I can choose between the following protocols in Qlik Sense:

    123.pngMethods in Qlik Sense REST Connector

    The Qlik Sense API for example provides many REST Endpoints we can communicate with. For example:

    "DELETE  /qrs/user/{id}",

    "PUT     /qrs/app/{id}/publish?stream={streamid}&name={name}",

    How can I call such an request (using the mentioned protocols) in Qlik Sense?

    Greetings

    Show Less
  • New to QlikView

    How to create Calendar with current Month equal to last six month

    Hi All,I have requirement were user want see Bar chart with current month data adding last six month data in same month like that each and every month... Show More

    Hi All,

    I have requirement were user want see Bar chart with current month data adding last six month data in same month like that each and every month. we need keep on adding  that month +six month in bar chart. 

     

    Capture.PNG 

     

    Thank you in advance 

    Show Less
  • New to Qlik Sense

    Make a loop to request SaleId

    Im trying to request SaleId for this urlhttps://server."company".com/masterkey/agency/sale/<saleid>/saleOrderSo that I can get country and city of des... Show More

    Im trying to request SaleId for this url

    https://server."company".com/masterkey/agency/sale/<saleid>/saleOrder

    So that I can get country and city of destination of the SaleOrder.

    I want to make a loop so that every call I make, it will return the information of the saleOrder im calling.

    If there is someone that could help me that would be great!!!!!

    I have this already in the script

    LIB CONNECT TO 'Sale';

    RestConnectorMasterTable:
    SQL SELECT
    "__KEY_root",
    (SELECT
    "sort",
    "order",
    "max",
    "offset",
    "totalCount",
    "count",
    "__FK_meta"
    FROM "meta" FK "__FK_meta"),
    (SELECT
    "q",
    "courseType",
    "status",
    "interestLevel",
    "referrer",
    "paymentStatus",
    "enrollmentStatus",
    "seller",
    "client",
    "saleGroup",
    "isEnabled",
    "studentName",
    "saleOrderStartDate",
    "courseName",
    "customStatus",
    "channel",
    "manager",
    "__KEY_query",
    "__FK_query",
    (SELECT
    "@Value",
    "__FK_distributor"
    FROM "distributor" FK "__FK_distributor" ArrayValueAlias "@Value")
    FROM "query" PK "__KEY_query" FK "__FK_query"),
    (SELECT
    "id" AS "id_u5",
    "version",
    "pid",
    "externalId",
    "name" AS "name_u5",
    "status" AS "status_u0",
    "courseType" AS "courseType_u0",
    "dateCreated" AS "dateCreated_u0",
    "lastUpdated",
    "referrer" AS "referrer_u0",
    "interestLevel" AS "interestLevel_u0",
    "campaign",
    "formURL",
    "customStatus" AS "customStatus_u0",
    "saleGroup" AS "saleGroup_u0",
    "isEnabled" AS "isEnabled_u0",
    "manager" AS "manager_u0",
    "discardReason",
    "enrollmentFieldApproved",
    "enrollmentFieldCount",
    "paymentDueDate",
    "paymentStatus" AS "paymentStatus_u0",
    "enrollmentStatus" AS "enrollmentStatus_u0",
    "__KEY_resourceList",
    "__FK_resourceList",
    (SELECT
    "id",
    "name",
    "email",
    "firstName",
    "lastName",
    "birthday",
    "gender",
    "__KEY_client",
    "__FK_client",
    (SELECT
    "number",
    "type",
    "__FK_phone"
    FROM "phone" FK "__FK_phone")
    FROM "client" PK "__KEY_client" FK "__FK_client"),
    (SELECT
    "name" AS "name_u0",
    "nationality",
    "birthday" AS "birthday_u0",
    "occupation",
    "firstName" AS "firstName_u0",
    "lastName" AS "lastName_u0",
    "email" AS "email_u0",
    "__FK_student"
    FROM "student" FK "__FK_student"),
    (SELECT
    "id" AS "id_u0",
    "name" AS "name_u1",
    "email" AS "email_u1",
    "iconUri",
    "__FK_seller"
    FROM "seller" FK "__FK_seller"),
    (SELECT
    "id" AS "id_u1",
    "name" AS "name_u2",
    "__FK_distributor_u0"
    FROM "distributor" FK "__FK_distributor_u0"),
    (SELECT
    "departureDate",
    "destination",
    "interest",
    "budget",
    "channel" AS "channel_u0",
    "comments",
    "dateCreated",
    "reporter",
    "__FK_lead"
    FROM "lead" FK "__FK_lead"),
    (SELECT
    "id" AS "id_u2",
    "name" AS "name_u3",
    "__FK_customStatus"
    FROM "customStatus" FK "__FK_customStatus"),
    (SELECT
    "id" AS "id_u3",
    "start",
    "__FK_saleOrder"
    FROM "saleOrder" FK "__FK_saleOrder"),
    (SELECT
    "id" AS "id_u4",
    "name" AS "name_u4",
    "__FK_saleGroup"
    FROM "saleGroup" FK "__FK_saleGroup")
    FROM "resourceList" PK "__KEY_resourceList" FK "__FK_resourceList")
    FROM JSON (wrap on) "root" PK "__KEY_root"
    WITH CONNECTION (Url "$(vURL)");


    [client.sale]:
    LOAD [id] as id.sale,
    [name] as name.sale,
    [email] as email.sale,
    [firstName] as [firstName.sale],
    [lastName] as [lastName.sale],
    [birthday] as [birthday.sale],
    [gender] as [gender.sale],
    [__KEY_client] as [__KEY_client.sale],
    [__FK_client] AS [__KEY_resourceList.sale]
    RESIDENT RestConnectorMasterTable
    WHERE NOT IsNull([__FK_client]);

    store [client.sale] into [lib://QVD/client.sale.qvd] (qvd);
    drop table [client.sale];


    [student.sale]:
    LOAD [name_u0] as [name_u0.sale],
    [nationality] as [nationality.sale],
    [birthday_u0] as [birthday_u0.sale],
    [occupation] as [occupation.sale],
    [firstName_u0] as [firstName_u0.sale],
    [lastName_u0] as [lastName_u0.sale],
    [email_u0] as [email_u0.sale],
    [__FK_student] AS [__KEY_resourceList.sale]
    RESIDENT RestConnectorMasterTable
    WHERE NOT IsNull([__FK_student]);

    store [student.sale] into [lib://QVD/student.sale.qvd] (qvd);
    drop table [student.sale];


    [seller.sale]:
    LOAD [id_u0] as [id_u0.sale],
    [name_u1] as [name_u1.sale],
    [email_u1] as [email_u1.sale],
    [iconUri] as [iconUri.sale],
    [__FK_seller] AS [__KEY_resourceList.sale]
    RESIDENT RestConnectorMasterTable
    WHERE NOT IsNull([__FK_seller]);

    store [seller.sale] into [lib://QVD/seller.sale.qvd] (qvd);
    drop table [seller.sale];


    [distributor_u0.sale]:
    LOAD [id_u1] as [id_u1.sale],
    [name_u2] as [name_u2.sale],
    [__FK_distributor_u0] AS [__KEY_resourceList.sale]
    RESIDENT RestConnectorMasterTable
    WHERE NOT IsNull([__FK_distributor_u0]);

    store [distributor_u0.sale] into [lib://QVD/distributor_u0.sale.qvd] (qvd);
    drop table [distributor_u0.sale];


    [lead.sale]:
    LOAD [departureDate] as [departureDate.sale],
    [destination] as [destination.sale],
    [interest] as [interest.sale],
    [budget] as [budget.sale],
    [channel_u0] as [channel_u0.sale],
    [comments] as [comments.sale],
    [dateCreated] as [dateCreated.sale],
    [reporter] as [reporter.sale],
    [__FK_lead] AS [__KEY_resourceList.sale]
    RESIDENT RestConnectorMasterTable
    WHERE NOT IsNull([__FK_lead]);

    store [lead.sale] into [lib://QVD/lead.sale.qvd] (qvd);
    drop table [lead.sale];


    [customStatus.sale]:
    LOAD [id_u2] as [id_u2.sale],
    [name_u3] as [name_u3.sale],
    [__FK_customStatus] AS [__KEY_resourceList.sale]
    RESIDENT RestConnectorMasterTable
    WHERE NOT IsNull([__FK_customStatus]);

    store [customStatus.sale] into [lib://QVD/customStatus.sale.qvd] (qvd);
    drop table [customStatus.sale];


    [saleOrder.sale]:
    LOAD [id_u3] as [id_u3.sale],
    [start] as [start.sale],
    [__FK_saleOrder] AS [__KEY_resourceList.sale]
    RESIDENT RestConnectorMasterTable
    WHERE NOT IsNull([__FK_saleOrder]);

    store [saleOrder.sale] into [lib://QVD/saleOrder.sale.qvd] (qvd);
    drop table [saleOrder.sale];


    [saleGroup.sale]:
    LOAD [id_u5] as [id_u5.sale],
    [name_u5] as [name_u5.sale],
    [__FK_saleGroup] AS [__KEY_resourceList.sale]
    RESIDENT RestConnectorMasterTable
    WHERE NOT IsNull([__FK_saleGroup]);

    store [saleGroup.sale] into [lib://QVD/saleGroup.sale.qvd] (qvd);
    drop table [saleGroup.sale];


    [resourceList.sale]:
    LOAD [id_u4] as [id_u4.sale],
    [version] as [version.sale],
    [pid] as [pid.sale],
    [externalId] as [externalId.sale],
    [name_u4] as [name_u4.sale],
    [status_u0] as [status_u0.sale],
    [courseType_u0] as [courseType_u0.sale],
    [dateCreated_u0] as [dateCreated_u0.sale],
    [lastUpdated] as [lastUpdated.sale],
    [referrer_u0] as [referrer_u0.sale],
    [interestLevel_u0] as [interestLevel_u0.sale],
    [campaign] as [campaign.sale],
    [formURL] as [formURL.sale],
    [customStatus_u0] as [customStatus_u0.sale],
    [saleGroup_u0] as [saleGroup_u0.sale],
    [isEnabled_u0] as [isEnabled_u0.sale],
    [manager_u0] as [manager_u0.sale],
    [discardReason] as [discardReason.sale],
    [enrollmentFieldApproved] as [enrollmentFieldApproved.sale],
    [enrollmentFieldCount] as [enrollmentFieldCount.sale],
    [paymentDueDate] as [paymentDueDate.sale],
    [paymentStatus_u0] as [paymentStatus_u0.sale],
    [enrollmentStatus_u0] as [enrollmentStatus_u0.sale],
    [__KEY_resourceList] as [__KEY_resourceList.sale],
    [__FK_resourceList] AS [__KEY_root.sale]
    RESIDENT RestConnectorMasterTable
    WHERE NOT IsNull([__FK_resourceList]);

    store [resourceList.sale] into [lib://QVD/resourceList.sale.qvd] (qvd);
    drop table [resourceList.sale];


    DROP TABLE RestConnectorMasterTable;

    Show Less
  • QlikView Security & Governance

    Max RAM usage 79 GB when the Physical RAM of Server is 64 GB, Please explain

    Hi Experts,We have the production server with actual RAM of 64 GB.However, the governance dashboard shows the Maximum RAM usage as 79 GB on a day and ... Show More

    Hi Experts,

    We have the production server with actual RAM of 64 GB.

    However, the governance dashboard shows the Maximum RAM usage as 79 GB on a day and for an hour.

    Could someone please explain what this means?

    Thanks in advance.

    Show Less

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for October and November 2019.

Blogs

Qlik Support Updates Blog

Read the latest blogs from Qlik Support and get important and useful support information.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.

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

Events

Qlik World 2020

Get the most value from your data and see the hottest trends in data and analytics. Join us in Phoenix, AZ. Register by December 31 to save $400.

May 11- 14, 2020 Conference

Events

Events & Meetups

Participate in an upcoming local Qlik Meetup


Events

Data Revolution Virtual Forum

An exclusive online event where industry experts share practical advice to help your entire team take charge of their data.

Find a location December 3, 4 and 5th