Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
1,814 online

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

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.

Ideation

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

Events

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

Qlik Academic Program

Enabling professors and students with data and analytics.

About

Get started, 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.

Support

Access Support programs, Knowledge Base, Updates blog, and Release Notes.

Community Sitemap

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

Recent Discussions

  • No Boards Found
  • forum

    New to Qlik Sense

    Advanced top 5 items by count

    Hi,I am tying to make a chart that shows the top 5 most populous colleges in a certain state (Minnesota). I have a variable called [States], a variabl... Show More

    Hi,

    I am tying to make a chart that shows the top 5 most populous colleges in a certain state (Minnesota). I have a variable called [States], a variable called [College Name], and a variable called [College Population]. What script can I use to do this?

    Thanks,

    Show Less
  • forum

    App Development

    Table-level Security with Section Access "not feasible"?

    Dear Gurus, I have a situation, where each group of tables is owned by different divisions. This ownership is indicated by REDUCTION field in each tab... Show More

    Dear Gurus, 

    I have a situation, where each group of tables is owned by different divisions. This ownership is indicated by REDUCTION field in each tables. Section Access defines who has access to what tables.  

    But to use REDUCTION field, we are bound to create such relation with security table (=Section Access table). 

    FGA Topic - Sanitized-Page-11.jpg

    But this will create such a datamart behind Qlik Sense. 

    Screenshot 2021-06-15 001313.jpg

    Once we needed to link-up with FKs (foreign keys), we end up with such. 

    FGA Topic - Sanitized-Page-11 (1).jpg

    To the worse, these REDUCTION values are nothing to do with the business meanings: i.e. it completely destroy relational key (FK_1 and FK_2), by creating synthetic key. 

    Screenshot 2021-06-15 001920.jpg

    Now, Link Table is only effective if the model is simple and record numbers are small. If we take on 50-80 million distinct FKs with 2 FACTS + 8-12 DIM tables, Link Table should host all the combination of distinct values. This is no-go. 

    In Qlik Sense, can we achieve "Table-Level Security" and FK relationships at the same time? (I doubt it.)

    To elaborate this case more, here is the example. 

    • You have Section Access, with USERID and REDUCTION. 
    • FACT_SALES is owned by Sales team. 
    • DIM_COA is owned by Finance team. 

    Users are setup as such: 

    • DOMAIN_USER_01 can access both tables. 
    • DOMAIN_USER_02 is an accountant, and only have access to DIM_COA. 
    • DIM_COA has one-to-many relationship to FACT_SALES. 

    FGA Topic - Sanitized-Danger of Unpredictable (1).jpg

    Now, we must implement user-access restriction based on table's REDUCTION, but still ensure the FK relationship. This results in such model, and no records is associatable. 

    Screenshot 2021-06-15 004517.jpg

    *This type of security can be easily implementable by the BI tool, that does credential passthrough to the base table.

    In my opinion, there must be a compromise that:

    • This type of security is not possible in Qlik Sense. 
    • Alternative is to create a Reporting Datamart. Original security properties are overwritten by ETL, so that Security table and FACT table will handle security as single point. The rest of cascaded filtering can be slightly loose.

    <This is the traditional Section Access, RLS>

    FGA Topic - Sanitized-Page-11 (2).jpg

    I think this is still acceptable. Is DIM data so secret? Usually no. They would be mostly some type of product, market segment, department, customer ....etc. It is the FACT that has to be confidential. 

    If DIM has PII (Personally Identifiable Information), create a special composite key, that effectively nullify via the FK if user is unauthorized. 

    But first of all, I am grateful if you possibly advise me about your opinion/view because you are probably far more experienced than me, a Spark data engineer. Thanks for your help.

    Show Less
  • forum

    Qlik Education Discussions

    Como copiar informações de algumas planilhas Qlik e colar em uma única planilha ...

    Estou tentando convencer as vantagens do QlikSense sobre o PowerDecision, e entre os argumentos que me apresentaram não existir no Qlik, é a facilidad... Show More

    Estou tentando convencer as vantagens do QlikSense sobre o PowerDecision, e entre os argumentos que me apresentaram não existir no Qlik, é a facilidade de copiar o conteúdo de algumas tabelas no Qlik e colar numa única tabela Excel.

    Este tem sido um ponto muito citado nas argumentações e não quero crer que o QlikSense não permita essa facilidade, talvez uma configuração que seja necessária ou versão específica.

    Aguardo um retorno o mais breve possível para que possa juntar eventual retorno positivo a minha lista de argumentações.

     

    Show Less
  • forum

    QlikView App Dev

    Git with Qlikview

    Hi all, I finally decided to start my own blog on how we can integrate Git with Qlikview, Step by Step.I will be updating the blog soon with my person... Show More

    Hi all,

    I finally decided to start my own blog on how we can integrate Git with Qlikview, Step by Step.

    I will be updating the blog soon with my personal details. Feel free to make comments and share your thoughts.

    Site: BI Experience | A place to share our Business Intelligence experiences

    Thanks,

    JV

    Show Less
  • forum

    QlikView App Dev

    Traer un Valor de Campo a otra Tabla en Base a un rango de fechas

    Tengo una tabla con  eventos por sucursal y las fechas de las actividades, en otra tabla tengo las campañas, la agencia y el rango de fechas de la cam... Show More

    Tengo una tabla con  eventos por sucursal y las fechas de las actividades, en otra tabla tengo las campañas, la agencia y el rango de fechas de la campaña y necesito agregar la campaña a la tabla de actividades y una tabla con ese dato incorporado. He probado con Join pero solo me combina las agencias con todas las campañas y no me toma las fechas

    Show Less
  • forum

    New to Qlik Sense

    Invalid Geometries - Match function in Data Load is breaking my map

    I'm trying to do a find and replace type of thing using the match function.Why does this (in the Data Load Editor) break my map?  if(match(county, cou... Show More

    I'm trying to do a find and replace type of thing using the match function.

    Why does this (in the Data Load Editor) break my map?

     

     

    if(match(county, county = 'St. Mary' & chr(39) & 's'), 'Saint Mary' & chr(39) & 's') as Modified.county,

     

     

    The map shows a message saying this:

    [Modified.county] - Area Layer

    The data contains invalid geometries that could not be shown on the map. Review your data for errors and try again.

    Show Less
  • forum

    App Development

    Gantt

    Hi guys!Following question because i think i go crazy.I have a table with "reclamations" and this "reclamations" have different Date "Positions"Some a... Show More

    Hi guys!

    Following question because i think i go crazy.

    I have a table with "reclamations" and this "reclamations" have different Date "Positions"

    Some are notificated = we was informed that there is a problem, some are picked up from us from the customer, some are arrived our stock.

    then there are timestamps when the customer is informed about costs and when for him its ok the date when gives us the ok.

    start repair date, delivery etc.

    All i want to have is a gantt with a timleine where i can mke this visible but i dont check it.

    example for a line:

    3 days from notification to pickup, 7 days from pickup to arrive our company, 15 days from inform the customer to his answer, 8 days for repair / production, 4 days from delivery stock to shippment.....

     

    Has anybody an idea how i can solve this problem?

     

    Thank you very much!

    Show Less
  • forum

    Qlik NPrinting Discussions

    Problem with OnDemand-Feature

    Dear Qlik Community,Since last Tuesday, we have been getting the following error message in Chrome and Microsoft Edge when using the OnDemand feature ... Show More

    Dear Qlik Community,

    Since last Tuesday, we have been getting the following error message in Chrome and Microsoft Edge when using the OnDemand feature for NPrinting.

    An error occurred:
    {"code":403, "message": "User has no rights to access the resource"}.

    We had this error once in the past, but were able to resolve it with the help of the following post:
    https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Nprinting-Ondemand-not-working-on-Chrome/td-p/1682939

    The error occurred suddenly without us changing anything in the application. Strangely enough, the OnDemnad function works in Internet Explorer.

    Support has already been informed, but maybe someone from the community has had the same experience recently.

    Already many thanks and best regards
    Lennart

    Show Less
  • forum

    Connectivity & Data Prep

    Qlik Sense Rest API Connector for Jira/Getting custom fields with their names fr...

    Hi Everyone,Good Evening,My source is jira, Loaded data from Jira through REST API into qlik sense, while loading Issue table custom fields are loadin... Show More

    Hi Everyone,

    Good Evening,

    My source is jira, Loaded data from Jira through REST API into qlik sense, while loading Issue table custom fields are loading into Qlik like Custom filed ids as lable, so its difficult to identify what is the actual filed name from jira.

    Due to requirement in project few field were added in Jira by Jira developer those fields called custom fields. These newly added fields by Jira developer are coming into qlik as custom filed with id (ex: custom field 250,custom filed 340).

    While creating the REST connection defined the filed names in the parameters, even though custom filed with ids are loading.

    Do i missed something while loading,please help on this.

    Thanks in Advance!!!!!!!!!!!

     

    Varsha.

     

     

     

    Show Less
  • forum

    New to Qlik Sense

    Count Where One Value is Not In Another Field

    Hello Folks, I have a datamodel that has three tables.  On the UI side, I have a straight table showing the data.  What I would like to do is count th... Show More

    Hello Folks,

     

    I have a datamodel that has three tables.  On the UI side, I have a straight table showing the data.  What I would like to do is count the number of times a value in Field A does not appear in Field B.

    For example, the data set below:

     

    AllowedTerminals:
    LOAD * Inline
    [
        'Bill To Terminal', 'Order Bill To Id'
        'GSP', 'IBM',
        'CLT', 'IBM',
    ]
    ;
    
    Orders:
    LOAD * Inline
    [
        'Order #', 'Order Bill To Id'
        '18CA7B', 'IBM'
        '63D95E', 'IBM',
    ]
    ;
    
    
    Assets:
    LOAD * Inline
    [
        'Order #', 'Tractor', 'Tractor Terminal'
        '18CA7B', '123 Freightliner', 'GSP',
        '63D95E', '900 Mack', 'LAX'
    ]
    ;
    
    EXIT Script
    ;

     

     

    In the example above, the tractor used for Order #18CA7B is terminaled at GSP.  GSP exists in the [Bill To Terminal] field that is linked to the [Order Bill To Id] of IBM.

    However, Order #63D95E used a tractor terminaled at LAX, and LAX is not in the [Bill To Terminal] list.

     

    I'm trying to get something like the following where the field CrossTerminalCount reflects the number of times this has happened.

     

    Order #Order Bill To IdTractor TerminalCrossTerminalCount
    18CA7BIBMGSP0
    63D95EIBMLAX1

     

    Order Bill To IdCrossTerminalCount
    IBM1

     

    The only solution that I can think of revolves around using the P() function, but every time my mind has gone in that direction, I've always had to backtrack.

     

    Any help is greatly appreciated.

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

May 18, 2021 10AM EST

Events

Qlik Insider - Webinar Series

This webinar will cover key new capabilities that drive Active Intelligence in your organization, helping your users go beyond the dashboard, to collaborate and take action at the point of decision.

May 26, 2021