Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
2,061 online
Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY

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

QlikWorld

This forum will provide you with event highlights and related content to get you energized and ready for QlikWorld Online.

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.

Qlik Resources

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

Events

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

Blogs

Hear directly from Qlik employees in our ten unique blogs.

About

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

Community Sitemap

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

Recent Discussions

  • No Boards Found
  • forum

    Security & Governance

    User Directory Connector

    Our platform users will log in to Qlik after JWT/SAML authentication, but as part of the authentication, we receive minimal user attributes.To get the... Show More

    Our platform users will log in to Qlik after JWT/SAML authentication, but as part of the authentication, we receive minimal user attributes.

    To get the Qlik security rules working, we need more attributes attached to the identical SAML/JWT authenticated user (say under user directory AD).

    Therefore, I configured UDC to connect to Excel (with user directory [AD]), having the same users with User directory [AD], hoping the users with the same userid under [AD] directory will be merged with SAMl/JWT AD directory but that's not happening.

    Instead, it's treating the same user under two different user directories, as per the screenshot below.

    NeelanjanBasu_0-1617941448647.png

    If I created a UDC (connecting Excel) with AD (SAML/JWT user directory) instead of [AD], it throws an error that the user directory already exists, which is fine.

    But the question is, how do we add a few extra users attributes to an authenticated user in Qlik? Even if Qlik treats the user under [AD] as a separate user entity, will it treat it as the same user from a security rule perspective?

    Show Less
  • forum

    New to Qlik Sense

    Script Optimization using without where condition

    Hi Folks, I want to know the alternative and best optimized  functions instead of where condition in the backend script of qliksense.
  • forum

    New to Qlik Sense

    How to compare same record with a different ID in a Table

    Hi Everyone,I have a difficult task at least for me in Qlik Sense Scripting.Task is, I would like to get all the records in which the below field valu... Show More

    Hi Everyone,

    I have a difficult task at least for me in Qlik Sense Scripting.

    Task is, I would like to get all the records in which the below field values are same but the IDs of those records are different (Example given below)

    ArressLine1, ArressLine2, City, State, Country and Postal Code

    So in the below example the result table should have only 4 records which IDs are 1,4,7 and 9

    How can I get this result table through Qlik Sense Scripting. please help me.

    Advance thank you for your support.

    ID | Addr1 | Addr2 | City | State | Cntry | PIN
    1 | ABC | DEF | GEH | IJK | LMN | 123456
    2 | yw | ete | yer | ertu | ergfd | 423623
    3 | fmdt | fuytu | iffd | fg | fgk | 663421
    4 | ABC | DEF | GEH | IJK | LMN | 123456
    5 | vm | jh | ut | tyur | ikd | 266234
    6 | wqwe | twee | rerew | erq | qwr | 672315
    7 | ABC | DEF | GEH | IJK | LMN | 123456
    8 | asd | adfa | sdfsadf | asfas | dfas | 963242
    9 | ABC | DEF | GEH | IJK | LMN | 123456

    Thank you,

    Raghu

    Show Less
  • forum

    Qlik NPrinting Discussions

    Nprinting report with URL to actual app not redirecting with selected filters

    Hi All, The below Nprinting report got a url which redirects to actual app in qliksense . The report got two filters:Facility : "RNS" as value and Yea... Show More

    Hi All,

     

    The below Nprinting report got a url which redirects to actual app in qliksense . The report got two filters:

    Facility : "RNS" as value and Year="2021" as numeric.

    1.PNG

     

    The report is emailed to user via Email as a PDF version.

    The attached report working correctly with selected filter : "RNS" and Year 2021. But when clicking on the URL/Link to redirect to actual App in qliksense . The App is opening with full data. 

    My requirement is : The filter selection should stay open clicking the URL.

    The URL is created by providing the web link :

    2.PNG

    Show Less
  • forum

    Deployment & Management

    QlikSense Update Failed

    Hello,I am updating QS from June 202 Patch 3 to November 2020 update but so far i am unable to. Any help would be appreciated. Please see attached the... Show More

    Hello,

    I am updating QS from June 202 Patch 3 to November 2020 update but so far i am unable to.

     

    Any help would be appreciated. Please see attached the logfile. Please let me know if you need me to attach the engine log file as well.

     

    Thank you.

    @Bastien_Laugiero 

    Show Less
  • forum

    Deployment & Management

    AD Usernames changing. Qlik Sense / View / NPrinting heavily effected.

    Good morning.We're currently going through major infrastructure changes (Azure, 365 etc) and all user UPNs are changing.After my username was changed;... Show More

    Good morning.

    We're currently going through major infrastructure changes (Azure, 365 etc) and all user UPNs are changing.

    After my username was changed;

    Qlik Sense imported a new user account, leaving my old one alone.
    The new account needed a licence, roles assigned and all 'owned items' transferred to my new username one by one. by changing owner. Not too bad for me, but we have 30 Pro licenses with a huge amount of items owned by some users.
    The same will go for Analyzers Access Allocations which we have over 1300 assigned - add to new user, remove from old.

    Is there anyway to automate any of this or is this going to have to be done manually, including changing ownership of items one by one?

    Qlik View seems to have removed my old username from CALs to each document and my new account is available to be assigned.  However in the first instance, I've lost access to all apps i was able to view previously.
    Qlik NPrinting looks like it may work as I think it uses an email address for login, but I need to investigate this further.

    Again, are these going to have to be done manually? Or is there any way around this with scripting / synchronising with existing users etc?

    We're looking for any way to make the transition smoother.
    Any help appreciated.

    Cheers

    Show Less
  • forum

    New to Qlik Sense

    Section Access Coding

    Hello Team,I'm new to Qlik Sense and I'm trying Section Access coding. I was using a set of coding provided by one of the team member. I would like to... Show More

    Hello Team,

    I'm new to Qlik Sense and I'm trying Section Access coding. I was using a set of coding provided by one of the team member. I would like to understand, how the code is working

    Can anyone guide me to understand this?

    Hierarchies:
    NoConcatenate
    Load
    NTNAME,
    ATTRIBUTE,
    DATAFIELD,
    If(WildMatch(DATAFIELD, '*Global*')>0,Trim(Mid(DATAFIELD,1,Len(DATAFIELD)))) as GLOBAL,
    If(WildMatch(DATAFIELD, '*GEO L1*')>0,Trim(Mid(DATAFIELD,9,Len(DATAFIELD)))) as GEO,
    If(WildMatch(DATAFIELD, '*GEO L2*')>0,Trim(Mid(DATAFIELD,9,Len(DATAFIELD)))) as COUNTRY

    Resident UAM;

    DROP Table UAM;

    Temp1:
    NoConcatenate
    LOAD
    Upper(NTNAME) as USERID,
    '' as GLOBAL,
    '' as GEO,
    '' as COUNTRY
    Resident [Hierarchies]
    Where
    Len(GLOBAL) <> 0;

    Temp2:
    NoConcatenate
    LOAD
    Upper(NTNAME) as USERID,
    Upper(Trim(GEO)) as GEO
    Resident [Hierarchies]
    Where
    Len(GEO) <> 0;

    Inner Join
    Load
    Upper(Trim(GLOBAL)) as GLOBAL,
    Upper(Trim(GEO)) as GEO,
    Upper(Trim(COUNTRY)) as COUNTRY
    Resident GEO_Hierarchy;

    Temp3:
    NoConcatenate
    LOAD
    Upper(NTNAME) as USERID,
    Upper(Trim(COUNTRY)) as COUNTRY
    Resident [Hierarchies]
    Where
    Len(COUNTRY) <> 0;

    Inner Join
    Load
    Upper(Trim(GLOBAL)) as GLOBAL,
    Upper(Trim(GEO)) as GEO,
    Upper(Trim(COUNTRY)) as COUNTRY
    Resident GEO_Hierarchy;

    Temp:
    NoConcatenate
    Load *
    Resident Temp1;
    Concatenate
    Load *
    Resident Temp2;

    Concatenate
    Load *
    Resident Temp3;

    Tempt:
    NoConcatenate
    Load *
    resident Temp;
    left Join

    Regards,

    Karthikeyan A

    Show Less
  • forum

    New to Qlik Sense

    Install Qlik Sense

    Hello, I want to install Qlik Sense but by clicking on Downloads I only have the option to download QlikView.Can anyone help me please? 
  • forum

    New to Qlik Sense

    Conditional if to pick correct expression

    Hi Guys,For an Inquiry Total KPI, I have written an expression that first it checks for current fiscal year(Apr 2021) if it is true it will calculate ... Show More

    Hi Guys,

    For an Inquiry Total KPI, I have written an expression that first it checks for current fiscal year(Apr 2021) if it is true it will calculate total inquiries for last fiscal year (Apr 2020 thru Mar 2021) else it will calculate total for current fiscal year after Apr 2021.

    In short, it is Apr 2021 then calculate totals from Apr 20 thru Mar 21 and if it is other than Apr 2021, if May 2021 then calculate  total only for Apr 2021, if it is Jun 2021 it will calculate for Apr 2021 thru May 2021 and so on.

    If(Max([Inq_MonthYear]) = Min({<IsCurrentYear = {'1'}>} [Inq_MonthYear]),
    Count({<[InqDate]= {">=$(=MonthStart(ReloadTime(),-12))<$(=MonthStart(ReloadTime(),0))"}
    >}Distinct InqKey) ,
    Count({<[InqDate]= {"<$(=MonthStart(ReloadTime(),0))"},IsCurrentYear = {'1'}>}Distinct InqKey)

     )

    I have filter for Fiscal Year 2020,2021,2022 and default is 2022.

    I am facing the challenge this expression doesn't work when fiscal year = 2022, but when I remove the filter it gives me correct total, can anyone please tell me why it is not working.

    If there is another approach I am open to that too.

     

    Thanks in advance.

    -V

     

     

     

    Show Less
  • forum

    New to Qlik Sense

    return value from function Month(Today())

    Hi. I do not know if the problem I am getting is due to some attitude in our environment or if I wrote something wrong in the code. What is seen in th... Show More
    Hi.
    I do not know if the problem I am getting is due to some attitude in our environment or if I 
    wrote something wrong in the code. What is seen in the image is: kolumn_vs_Qlik.png
    Month which is a field in a column and must be matched against the function that is to pick up the current month.
    However, it gives no result due to the month from the function being apr. The whole expression looks like this: sum( { 1<Month={"$(=Month(Today()) )"} > } LineSalesAmount)

    Asks the question here so maybe someone can give tips what is wrong.

    Regards.
    Show Less

Get Started On Community

Start Here Get Started On Community

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

Online Conference

Join QlikWorld to hear from Qlik CEO, Mike Capone on activating your data for impact. You’ll also have access over 100 breakout sessions covering data integration and analytics, tips for getting the most out of your data, and a view into what the next generation of BI holds.

May 10-12, 2021

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