Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
7,836 online
Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING

Welcome to Qlik Community

Data Analytics

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

Data Integration

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

Support

Chat with us, search Knowledge, open a Case, read the latest Updates Blog, find Release Notes, and learn about our Programs.

Qlik Gallery

Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.

Ideation

Participate in Qlik Technical Previews, submit ideas, and review documentation.

Events

Learn about upcoming Qlik related events, webinars and local meetups.

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.

About

Get started on Qlik Community, find How-To documents, and join general non-product related discussions.

Blogs

Hear directly from Qlik employees in our ten unique blogs.

Qlik Resources

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

Qlik Academic Program

Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

Community Sitemap

Here you will find a list of all the Qlik Community forums.

Recent Discussions

  • No Boards Found
  • forum

    New to Qlik Sense

    Create tooltip or hover as a description

    Is there a way to create a custome tooltip or hover when we hover on top of the kpi or graph to explain it's about? I can't see to add that in at all ... Show More

    Is there a way to create a custome tooltip or hover when we hover on top of the kpi or graph to explain it's about? I can't see to add that in at all or is there an alternative then when it hovers instead of showing a value it displays a description of what that graphs/kpi is about? 

    Show Less
  • forum

    New to Qlik Sense

    Change in price between months (inflation)

    I need to calculate the price inflation between month to month. for example, I would like to see the price increase/decrease for service A between the... Show More

    I need to calculate the price inflation between month to month. for example, I would like to see the price increase/decrease for service A between the month of July and August, and August and September(consecutive months). what is the suitable function to do this?

    moath_0-1638688390938.png

     

    Show Less
  • forum

    App Development

    wildcard load at qvd path

    Hi, loading multiple qvd's from qvd folder using wildcard load at qvd path. storing data into day wise qvd's and one field added in yesterday qvd. " d... Show More

    Hi,

    loading multiple qvd's from qvd folder using wildcard load at qvd path.

    storing data into day wise qvd's and one field added in yesterday qvd.

    " digital_campaign_code " field added in yesterday's qvd and values not reflecting.

    thanks in Advance

    below is my script :

    Activation_Temp:
    Load
    '' as SupplementaryFlag,
    '' as UploadDocumentFlag,
    '' as ApproverUserID,
    '' as ApprovalRemarks,
    '' as ApprovalJustification,
    '' as ApprovalStatus,
    '' as digital_campaign_code
    AutoGenerate 0;

     

    Concatenate(Activation_Temp)
    Load
    OrderActionID,
    PackType,
    SimSerialNumber,
    MNPInd,
    DonorOperator,
    PortinStatus,
    PortInReason,
    ActRejectReason,
    ActDeviceName,
    ActDeviceBrand,
    ActDeviceModel,
    ActDeviceSIMType,
    ActDeviceColor,
    ActDeviceSKU,
    ActPreToPostInd,
    ContractName,
    ContractDuration,
    ContractStartDate,
    ContractEndDate
    //digital_campaign_code //new
    FROM
    $(vQVDfolder)/OrderActivationDtl/OrderActivationDtl*.qvd(qvd);

     

     

     

    NoConcatenate

    OrderActDtl:
    LOAD OrderActionID,
    PackType,
    SimSerialNumber,
    MNPInd,
    If(MNPInd=1, 'MNP') as MNPIndVal,
    DonorOperator,
    PortinStatus,
    PortInReason,
    ActRejectReason,
    ActDeviceName,
    ActDeviceBrand,
    ActDeviceModel,
    ActDeviceSIMType,
    ActDeviceColor,
    ActDeviceSKU,
    ActPreToPostInd,
    ContractName,
    ContractDuration,
    ContractStartDate,
    ContractEndDate,
    SupplementaryFlag, //NEW
    UploadDocumentFlag, //NEW
    ApproverUserID, //NEW
    ApprovalRemarks, //NEW
    ApprovalJustification, //NEW
    ApprovalStatus, //NEW
    digital_campaign_code //new
    resident Activation_Temp;
    // FROM
    //$(vQVDfolder)\OrderActivationDtl\OrderActivationDtl*.qvd(qvd);
    drop table Activation_Temp;

    exit Script;

     

    Show Less
  • forum

    New to Qlik Sense

    remove empty column in chart

    Hello, I will want to display the average of my MTBF (column 1) of the name (Name column) of the non-empty rows of the sector_mtbf column How to proce... Show More

    Hello,

    I will want to display the average of my MTBF (column 1) of the name (Name column) of the non-empty rows of the sector_mtbf column

    How to proceed

    thank you

    stephane1_0-1638857306407.png

     

    Show Less
  • forum

    Integration, Extension & APIs

    Unable to authorize using generated JWT token

    Hello  We are trying to use the JWT token to authorize users in our tenant. Unfortunately, we are constantly getting a "No identity-provider is able t... Show More

    Hello 

    We are trying to use the JWT token to authorize users in our tenant. Unfortunately, we are constantly getting a "No identity-provider is able to complete the exchange" error message. 
     
    What we did:
     
    1. We created a JWT Identity provider
     
    ip.png
     
    2. We configured Content Security Policy 
     
    scp.png
     
    3. We added Web integration
     
    wi.png
     
    4. We generated a JWT token for the previously created user
     
    Payload
     
    payload =
    {
    'sub': 'AbVUmy-qm52KYnW3LLUMVj8XL9b_w_Xw',
    'subType': 'user',
    'name': 'Anton Akhramovich',
    'email': 'anton.akhramovich@leverx.com',
    'email_verified': True,
    'iat': datetime.now(tz=timezone.utc),
    'exp': datetime.now(tz=timezone.utc) + timedelta(hours=6),
    'iss': 'ipivg15a4pg4614.us.qlikcloud.com',
    'aud': 'qlik.api/login/jwt-session',
    'groups': ["Analytics Admin", "Data Admin", "Data Space Creator", "Developer", "Managed Space Creator",
    "Shared Space Creator", "Tenant Admin"],
    }
    Signing option
     
    options = {
    "keyid": "a9e1e157-b9a1-40da-8926-d2d022ab25eb",
    "issuer": "ipivg15a4pg4614.us.qlikcloud.com",
    "expiresIn": "6h",
    "algorithm": "RS256",
    "audience": "qlik.api/login/jwt-session"
    }
     
    5. We tried to call /login/jwt-session API end-points with this token and web integration id. 
     
    Request example:
     
    curl --request POST \
      --url 'https://ipivg15a4pg4614.us.qlikcloud.com/login/jwt-session?qlik-web-integration-id=4X19wW0KeJFDF_cSYIsDLoeUPN98kuqG' \
      --header 'Authorization: Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsImtleWlkIjoiNzM4MWVhMzItYTYyYi00MzE1LWE1NTAtNDE5NTA0NjkwMDhlIiwiaXNzdWVyIjoiaXBpdmcxNWE0cGc0NjE0LnVzLnFsaWtjbG91ZC5jb20iLCJleHBpcmVzSW4iOiI2aCIsImFsZ29yaXRobSI6IlJTMjU2IiwiYXVkaWVuY2UiOiJxbGlrLmFwaS9sb2dpbi9qd3Qtc2Vzc2lvbiJ9.eyJzdWIiOiJBYlZVbXktcW01MktZblczTExVTVZqOFhMOWJfd19YdyIsInN1YlR5cGUiOiJ1c2VyIiwibmFtZSI6IkFudG9uIEFraHJhbW92aWNoIiwiZW1haWwiOiJhbnRvbi5ha2hyYW1vdmljaEBsZXZlcnguY29tIiwiZW1haWxfdmVyaWZpZWQiOnRydWUsImdyb3VwcyI6WyJBbmFseXRpY3MgQWRtaW4iLCJEYXRhIEFkbWluIiwiRGF0YSBTcGFjZSBDcmVhdG9yIiwiRGV2ZWxvcGVyIiwiTWFuYWdlZCBTcGFjZSBDcmVhdG9yIiwiU2hhcmVkIFNwYWNlIENyZWF0b3IiLCJUZW5hbnQgQWRtaW4iXX0.A_s2kfGijAkigtZ24hNpEj1npN5mtNVYsD36k08Xl3lDAhUXL-cwbVc-w9i_ito8JU0S4GTnb-I6mCUtibgT35LOfu7jIyguzuT-EQIuRsAlxd76Wnv9f4c9VQXhko-RPjXXT8RRENTVPwkkik1XyR57cmDtgcXq4bTIO2qp--nN1Vqczw8GPn8Z8YVqWlxnoPeOCUH8VpeqCm-zVt32YJOiQptSFg9dukuy18qfjtdu6voriepM0Y6TWfyYt8cgIEGXQ5ydNNA14lVzyCQNL1gzx9Y_7FhjRcCIlX4_cGpjhQbEa7GfkqL46SHhTZyXDVFHiNPJ3ZR-Zq6cIRjR5vVPfmsYY87HArZCRc_aE5PvQ7MM3zNLLW9wrzn-u52YQIR2uvwWEXW96NM8H_aPggI3yAK2oMXkEerZ1QMkd-nOKYgfdMql3wRSirEJCGmvIIX8sQKpFnERM7JzkGXH1pcTcbHFoAbldeC4EbTgFeK2pTxHGXN2TH1DFqZfFvPg7wnHpfJs83yZYL3w4AWwxFvZ-OF3yHr8BxZLHjTK2Mu7nSYTamR93QtZmZqrp5rszjNK_RmjgOfJdCNQlk53UJcRRhDnE8OkKLWqUXiWNDWcxP_mZGvexPI51PKpM5z1V4w5J-Wd7ETc0hguy3Cp-Q6GUvMOcTJa2-VSYvQjzsI' \
      --header 'content-type: application/json' \
      --header 'qlik-web-integration-id: 4X19wW0KeJFDF_cSYIsDLoeUPN98kuqG'
     
    Response
     
    {
      "errors": [
        {
          "title": "Authentication failed",
          "detail": "No identity-provider is able to complete the exchange",
          "code": "LOGIN-1",
          "status": "401"
        }
      ],
      "traceId": "0000000000000000575fdaa5ce50c86f"
     
     
    I also attached the python script that is used to generate the JWT token
     
    It will be great if you can support us to find out what we are doing wrong. 
    Show Less
  • forum

    New to Qlik Sense

    Display default year in Dashboard but still able to multi select

    is there a way to set the  default data displayed in the dashboard to the current year but still having the ability to display the remaining years? I ... Show More

    is there a way to set the  default data displayed in the dashboard to the current year but still having the ability to display the remaining years? I have a filter for year how do I set the default year to the current year but still allow the users to remove that filter and set according to what they want? 

    Show Less
  • forum

    New to Qlik Sense

    Link Table not showing the required data

    I created a link table because I have a few fact tables. I needed the data to be connected and avoide synthetic keys and circular references. But now ... Show More

    I created a link table because I have a few fact tables. I needed the data to be connected and avoide synthetic keys and circular references. But now there are no errors to the link table script but I am not able to view the data I need and it appears not to be linked at all. Can someone help guide me please.

     

    chibi_0-1638436104667.png

    Link_table:
    LOAD DISTINCT
    [linkKey],
    draw_id,
    game_code
    RESIDENT fact_sales_hourly_agg;

    CONCATENATE(Link_table)

    LOAD DISTINCT
    [linkKey],
    draw_id,
    game_code
    RESIDENT fact_winners;

    CONCATENATE(Link_table)

    LOAD DISTINCT
    [linkKey],
    draw_id,
    game_code
    RESIDENT fact_pl_agg;

    CONCATENATE(Link_table)

    LOAD DISTINCT
    [linkKey],
    draw_id
    RESIDENT fact_sales_liability;

    CONCATENATE(Link_table)

    LOAD DISTINCT
    [linkKey],
    draw_id
    RESIDENT fact_draw_numbers;

    CONCATENATE(Link_table)

    LOAD DISTINCT
    [linkKey],
    game_code
    RESIDENT dim_game;

    //drop fields from initial QVD load scripts these data fields are no longer needed
    DROP FIELDS
    draw_id,
    game_code
    FROM fact_sales_hourly_agg;

    DROP FIELDS
    game_code,
    draw_id
    FROM fact_winners;

    DROP FIELDS
    draw_id,
    game_code
    FROM fact_pl_agg;

    DROP FIELDS
    draw_id
    FROM fact_sales_liability;

    DROP FIELDS
    draw_id
    FROM fact_draw_numbers;

    DROP FIELDS
    game_code
    FROM dim_game;

    Example of code that I added the link key to in the table: 

    LOAD
    draw_id&'|'&game_code AS [linkKey], //for linktable
    draw_id,
    game_code,
    FROM [lxxxxxx/fact_sales_hourly_agg.qvd]
    (qvd);

    Show Less
  • forum

    New to Qlik Sense

    mapping data

    Hi,   I have multiple branches in one city or multiple branch names in our system, so need to map data of all branches into existing branches in a par... Show More
    Hi,
     
    I have multiple branches in one city or multiple branch names in our system, so need to map data of all branches into existing branches in a particular city. 
     
    Example as per below - Five different branch name showing in our system for Ahmedabad branch, So need to map data of all Ahmedabad branches  in to Existing branch name - Ahmedabad **bleep**al Varsha
     
    Sr No Zone State City Branch Name Branch ops Region RM Name
    1 West Gujarat Ahmedabad Ahmedabad- **bleep**al Varsha WEST 2 Pragnesh Patel
    - - - - Ahmedabad-Ambavadi - -
    - - - - Ahmedabad-Ambavadi-2 - -
    - - - - Ahmedabad-C.G Road - -
    - - - - Ahmedabad-C.G Road-160 - -
    - - - - Ahmednagar-Nagar Shirdi Road-3 - -
                 
                 
    Show Less
  • forum

    App Development

    Set analysis comparison in the same table

    Hi team, I need help to write a set analysis with a Trend chart for the below scenario : Need to create a bar chart to compare data between different ... Show More

    Hi team,

    I need help to write a set analysis with a Trend chart for the below scenario :

    Need to create a bar chart to compare data between different dates and to count no of ids which were Old, New and Changed in each date. Old/New/Changed values need to be calculated on the flow if the Code is same or changed with respect to a date. Below is the example.

    Id Date Name Code Flag
    10 01-06-2021 A AU New
    11 01-06-2021 B IN New
    12 01-06-2021 C CN New
    13 01-06-2021 D NZ New
    12 08-06-2021 C CN Old
    13 08-06-2021 D AG Changed
    14 14-06-2021 E BP New
    11 14-06-2021 B IP Changed
    Show Less
  • forum

    App Development

    How can I Replace '-' with Zero quickly or efficiently ?

    I want to replace field values with Zero if value is hyphen i.e. '-'. Have tried many things like  If Statement Replace Function Pick Match Applymap ... Show More

    I want to replace field values with Zero if value is hyphen i.e. '-'.

    Have tried many things like 

    1. If Statement
    2. Replace Function
    3. Pick Match
    4. Applymap

    But all of these are taking lot of time to replace existing values to 0. Can I do this quickly in someway ?

    Data volume is ~274,444,124

    Script Example :

    FinalData:
    NoConcatenate
    LOAD *, if(Rate='-','0',Rate) As [Rate_New] Resident Final;
    Drop Table Final;
    Rename table FinalData to Final;

    Above block itself is taking excessive time. Around 2 to 2.5 hours

    Drop field [Rate_New] from FinalData;
    Rename Field [Rate_New] to [Rate];

     

    QlikView  Qlik Analytics Platform  

     

    Show Less

Get Started On Community

Start Here Get Started On Community

Top Participants

Blogs

Product Innovation Blog

Learn about what's new across all of the products in our growing Qlik product portfolio.

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.

German Group

Deutsche User Group

German speaking - This group makes it easier to collaborate in your local language.

Request to join

Brazil Group

Brazil

This group for Brazil users. All discussions are in Portuguese.

open to all

Industry Group

Public Sector Group

This is a open Group for the Public Sector

All are welcome

Events

Espresso Webinars - From Data Integration to Analytics in Action

These webinars get straight to the point, they are strong, short, and with immediate effect – like an espresso.

Upcoming and On-Demand

Events

Talk to Experts Tuesday

You’ve got questions? We’ve got answers! Talk to Experts is a live Q&A Webinar series! Join and ask your questions about Qlik Sense Enterprise, Client Managed.

June 29, 2021 10AM EST

Events

Cloud Data and Analytics Tour

Ready to steer your business towards data-informed growth? Our Cloud Data & Analytics Tour is the perfect place to start your journey.

Choose your Region