Qlik Community

Ask a Question

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
4,127 online
Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources. Prep for the big move: READ DETAILS

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

Qlik Academic Program

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

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.

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

    Need help on Dates w.r.t 13 months ,25 months

    hi experts ,i have a requirement on dates Requirement : I have two date columns "repotted on date" and "effective date " when i select Reporeted on da... Show More

    hi experts ,

    i have a requirement on dates 

    Requirement : I have two date columns "repotted on date" and "effective date " when i select Reporeted on date on UI then i need to show 13 months sales from effective date 

    Example: when i select  "repotted on date"= '01-AUG-21' then data should show effective_date between '01-Aug-19' and '31-Jul-20' sales .

    Thanks in advance ....

    Thanks,

    Siddiq

     

    Show Less
  • forum

    Qlik NPrinting Discussions

    NPrinting exception error(Exception to HRESULT: 0x80048240)

    Good day I am using NPrinting Feb V21.0.0.0 with Qlik Sense 2020 Patch 2.When I create a NPrinting Power point report I get this error when I try and ... Show More

    Good day 

    I am using NPrinting Feb V21.0.0.0 with Qlik Sense 2020 Patch 2.

    When I create a NPrinting Power point report I get this error when I try and add a image in using Template editor: Exception to HRESULT: 0x80048240 (In screenshot below).

    Justinjdkdekock_0-1632314269719.png

     

    I am able to do this when creating reports in all other formats, but I cannot drag and drop the image into Excel or Word within template Editor.

    Your assistance will be highly appreciated.

     

     

    Kind regards,

    Justin 

    Show Less
  • forum

    QlikView App Dev

    Dynamic QVD Load based on the selected Month

    Hi All,Have a  situation where I have to develop a qlikview application which will dynamically load multiple qvds depending upon selected month.Files ... Show More

    Hi All,

    Have a  situation where I have to develop a qlikview application which will dynamically load multiple qvds depending upon selected month.

    Files are stored as:

    Jan21.qvd

    Feb21.qvd

    .

    .

    .Dec21.qvd

    Depending on the Month selected from Drop down list corresponding month qvd should Load and display the values in the calculated fields.  please help me with this

     

    Thank You

    Show Less
  • forum

    App Development

    Set Analysis

    Hello all, This is with regard to set analysis :count({$<Country = {"sum({$<Week = {">$(=$(vTest))"}>}Sales) > 1000"}>}distinct Country) The double qu... Show More

    Hello all,

     

    This is with regard to set analysis :

    count({$<Country = {"sum({$<Week = {">$(=$(vTest))"}>}Sales) > 1000"}>}distinct Country)

     

    The double quotes doesn't  work inside the element set , with single quote output is not correct

    Show Less
  • forum

    App Development

    Drill down dimension in qliksense

    Hello All,I have created a drill down dimension in qliksense like below :-But when I am passing this dimension in chart, it is not working . Please se... Show More

    Hello All,

    I have created a drill down dimension in qliksense like below :-

    Aspiring_Developer_0-1632316457720.png

    But when I am passing this dimension in chart, it is not working . Please see below :-

    Aspiring_Developer_1-1632316580667.png

    In Bar chart , i am unable to toggle to other dimension. Similarly when I take this drill down dimension in table , it is coming as a single field only . Am i doing something wrong ? Please suggest.

    Thanks is advance

     

    Show Less
  • forum

    App Development

    Maximum number of columns a Qlik Sense Straight Table

    Hi all!Today I faced with the following issue: 1) In one Qlik Sense app we have "Report toolkit" chart which allow users to select any dimensions and ... Show More

    Hi all!

    Today I faced with the following issue: 

    1) In one Qlik Sense app we have "Report toolkit" chart which allow users to select any dimensions and metrics from the list and create their own report: 

    Alyona_0-1632310039006.png

    2) All fields by default are hide and are displayed based on the rule in the "Show column if" field: 

    Alyona_1-1632310176931.png

    3) Currently in this report we have 170 columns. And when I try to add new column I am not able to do this: it is shown as empty and after close the editing this change isn't saved: 

    Alyona_2-1632310430198.png

    The problem is also in the fact that I am even not able to make some changes with existing items (for example to change "Show column if" rule). 

     

    Qlik experts please help me with the following: 

    1) Has anyone come across a limit on the maximum number of columns in a Qlik Sense straight table?

    Maybe after some of the last releases... Our current Qlik Sense version is May 2021 Patch 4.  

    2) What solutions could be in my case when I need to add new columns to the straight table with 170 existing columns? 

     

     

    Show Less
  • forum

    QlikView App Dev

    Data Recognition Problem

    Hello All,Here is a pdf attachment explaining my problem. Thanks in advance for your help.Waïl Riachi
  • forum

    New to Qlik Sense

    selection based on two timestamps

    Hi all,I Created Startdate and EndDate variables using the below definitions.vStartDate1 as "=max({<StartDate = {"$(=min(StartDate))"}>} StartDate)"vE... Show More

    Hi all,

    I Created Startdate and EndDate variables using the below definitions.

    vStartDate1 as "=max({<StartDate = {"$(=min(StartDate))"}>} StartDate)"

    vEndDate1 as "=Min({<EndDate = {"$(=min(EndDate))"}>} EndDate)"

    I have selected dates as below but the data is not getting filtered correctly.

     

    sujana1621_0-1632322117602.png

    here is the expression used for match date in the table.

    =if(timestamp(timestamp#([Match Date],'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm')>='$(vStartDate1)' and timestamp(timestamp#([Match Date],'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm')<='$(vEndDate1)',[Match Date])

    here is the script that I used to generate data from 2017.

    let vStartDate=Timestamp(AddMonths(now(),-48),'YYYY-MM-DD hh:mm:ss');
    let vEndDate=Timestamp(now(),'YYYY-MM-DD hh:mm:ss');
    trace $(vmindate);

     

    LET vMinDate = num(Timestamp(Timestamp#(now()))-1468);

     

    LET vMaxDate = num(Timestamp(Timestamp#(now())));

     

    LET vNumberOfDays = Floor($(vMaxDate)) - Floor($(vMinDate)) + 1;

     

    Calendar_Date_1Months:
    LOAD

     

    Timestamp(Num($(vMaxDate)) - (RecNo())/24/60 ) as Date,
    Num(Floor(Date(Num($(vMaxDate)) - RecNo()/24/60 ))) as DateKey
    AutoGenerate 24*60* $(vNumberOfDays) ;

    StartDate:

     

    LOAD Distinct
    Timestamp((Date),'DD/MM/YYYY hh:mm') as StartDate
    Resident Calendar_Date_1Months
    order by DateKey desc;

    EndDate:

     

    LOAD Distinct
    Timestamp((Date),'DD/MM/YYYY hh:mm') as EndDate
    Resident Calendar_Date_1Months
    order by DateKey desc;

     

    MatchDate is in timestamped format. 

     

    sujana1621_1-1632322380104.png

     

    Could anyone please help me out on this.

    Thanks

    Sujana

     

    @sunny_talwar 

    Show Less
  • forum

    QlikView App Dev

    QlikView Download November 2017 SR6 12.20.20700.0

    Hi everyoneWhere can I find the qlikview installer QlikView November 2017 SR6 12.20.20700.0 ?Thanks in advance!
  • forum

    QlikView App Dev

    dimensions always kept

    Hello,In an array, I have a dimension named 'CODE_NB' which I always want to display all the different values ​​regardless of:- the year selected (0 i... Show More

    Hello,
    In an array, I have a dimension named 'CODE_NB' which I always want to display all the different values ​​regardless of:
    - the year selected (0 if not used)
    - the REEL or BUDGET summed indicator (0 if not used).

    How to do this ?

    Thank you very much,

    Arnault

    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