Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
940 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

  • Qlik Sense App Development

    How to sort bars by measures level in Bar chart

    Hi Folks,Could some one help me on this following requirement.  How to sort bars by measures level in Bar chart. I am having a bar chart in the follow... Show More

    Hi Folks,

    Could some one help me on this following requirement.  

    How to sort bars by measures level in Bar chart. I am having a bar chart in the following 

    bar test.PNG

    In the above chart if we look at dimensions Hard disk.  Lower value is 4  and Actual is 0. So  1st bar should be Actual & 2nd bar should be Lower Value.

    If we look at dimension USB Lower value is 20 & Actual is 17. So 1st bar should be Actual & 2nd Bar should be Lower Value.

    There is one more Dimension  Mouse. In this case 1st bar is Lower , 2nd bar is actual & 3rd bar is Upper. So these bar should be in ascending order. 1st bar should be Lower and 2nd bar should be Upper and 3rd should be Actual.  

    Mouse.PNG 

    Could some one can please help me  to resolve this Issue. Is this possible in Qliksense? Please let me know and you can find the data and sample qvf files in attachments

     

    Thanks and Regards,

    Satya

     

    Show Less
  • Qlik Sense Integration, Extensions, & APIs

    Trouble with capability API - field selectValues

    Trying to set up a mashup with two apps and shared filters.  There is a listener on the selectionState of the first app like this:which sets the field... Show More

    Trying to set up a mashup with two apps and shared filters.  There is a listener on the selectionState of the first app like this:

    Untitled.png

    which sets the field selectValues of the second app.  This works for some fields but not all.  I looked at one of the problem fields using

    app.field('METRIC DATE.YEAR').getData();

    compared to:

    app1.field('METRIC DATE.YEAR').getData();

    and it is identical in both apps.  I also tried setting it directly as numeric and text:

    app1.field('METRIC DATE.YEAR').selectValues([2016], true, true);

    app1.field('METRIC DATE.YEAR').selectValues(['2016'], true, true);

    but no luck.

    Any ideas on what to try next?

     

     

    Show Less
  • New to Qlik Sense

    COMO ENMASCARAR DATOS

    Estimados Muy buen día, quisiera saber como poder enmascar datos.
  • Qlik Sense App Development

    Pie Chart for Multiple Columns

    Hi,I am facing the below issue for Pie chart.I have 5 columns with Data ex: A1,A2,A3,A4,A5. Now need to build pie chart. Here is the data for these co... Show More

    Hi,

    I am facing the below issue for Pie chart.

    I have 5 columns with Data ex: A1,A2,A3,A4,A5. Now need to build pie chart. Here is the data for these columns.

    A1A2A3A4A5
    ABABA
    BDCCB
    CEEAC
    D    
    E    

     

    Pie chart should have count of all A's(5 Columns),B's,C's,D's,E's.

    A - 4

    B - 4

    C - 4

    D - 2

    E - 3

    Can any one help me how to do that.

    Appreciate for quick help.

     

    Show Less
  • QlikView App Development

    Hide a tab for Users which are not Admin in the Dashboard

    Hello All,I need to hide a tab in the qlikview dashboard for Users whose Access is not Admin.I tried to use the column Access in the section file . Cr... Show More

    Hello All,

    I need to hide a tab in the qlikview dashboard for Users whose Access is not Admin.

    I tried to use the column Access in the section file . 

    Created one table with the column Access called USer_Access so that it joins with the Access column in the security table .

     I added a condition in the sheet properties to show for Access='ADMIN'. 

    When I refresh the file , it opens in Qlikview Desktop but doesnt oopn in Access Point.

    Please advise

     

    Thanks 

    Kusha 

    Show Less
  • New to Qlik Sense

    Highlight a Bar on a Stacked Bar Chart

    I am trying to highlight one bar in a stacked bar chart.  In a simple bar chart, I can color by expression so whatever I have selected will be a singl... Show More

    I am trying to highlight one bar in a stacked bar chart.  In a simple bar chart, I can color by expression so whatever I have selected will be a single color and all other data will be a different color.  But in a stacked bar, I need to leave the color alone so each piece in my stack has its own color.  I would like my selected bar to be bold.  I have attached two pictures - "Graph" is of the stacked bar graph and "Selected" shows what I would like it to look like when a bar is selected (I selected bar 31 for the example).  I tried searching for this but didn't have any luck.  And suggestions would be great.  Thank you!

     

    GRAPH:Graph.JPGGRAPH

     

     

    SELECTED:

    Selected.JPGSELECTED

     

    Show Less
  • New to Qlik Sense

    Qlik Sense Desktop stuck with "Initializing Add data" after pressing the add dat...

    Hi, I am having the above issue on a fresh installed Qlik Sense Desktop version.Installed the November 2019 Qlik Sense Desktop version on up to date w... Show More

    Hi, 

    I am having the above issue on a fresh installed Qlik Sense Desktop version.

    Udklip.PNG

    1. Installed the November 2019 Qlik Sense Desktop version on up to date windows 10 Dell laptop.
    2. Created an App and opened it
    3. Pushed the area to add data
    4. A circle appears with the following text below "Initializing Add data" 
    5. Noting mores happens

    What to do? 

    I tried to repair, run as admin but nothing works. 

    Running the cloud version seems to work fine.

     

     

    Show Less
  • QlikView Scripting

    Apply discount to the product with the lowest value.

    Hi,I've trying to do this in the script, managed to do it with an expression.I want to find the lowest priced product per SubId and apply a discount (... Show More

    Hi,

    I've trying to do this in the script, managed to do it with an expression.

    I want to find the lowest priced product per SubId and apply a discount (in this case 50%) and then sum the Totals.

    FirstsortedValue should work i guess but I'm doing something wrong 🙂

     

    This is the expression:

    (Sum(FullPrice)
    -
    (Min({<flgNewOrder = {'1'}>} Aggr(FullPrice, [Product ID]))
    *0.5))

     

    SubIdProdIdFullPricePriceAfterDiscount
    450623268268
    450654226226
    45061214572,5
        
        
     Total639566,5
    Show Less
  • Qlik Sense Cloud Discussions

    Qlik Sense Business connection lost constantly

    I am developing in Qlik Sense Business, and constantly get either one of the below messages. When I say constantly, I mean about every 5 minutes. Ever... Show More

    I am developing in Qlik Sense Business, and constantly get either one of the below messages. When I say constantly, I mean about every 5 minutes. Every time you need to do a refresh or close, your last changes are gone. The machine is not left idle, I am working on a new App. 

    I have a fibre line with 20g upload and down load. I also have a 4G standby router. The issue is the same no matter which service I use. I have done the rebooting of the router thing!

    Has any experienced the issue and found a solution? If so, please can you share your solution. Thank you.

    Capture.JPG

    Show Less
  • New to Qlik Sense

    Date variable projecting forward to 2020

    Hello,I am trying to find an error in some script that was developed for us by a third party. We have a report that has stopped working due to the kno... Show More

    Hello,

    I am trying to find an error in some script that was developed for us by a third party. We have a report that has stopped working due to the knock on effect of our date calendar now projecting to 2020. I can see in the variables that a variable called varMaxDate is calculating a value 43887 (in Excel this is showing me it is 26/02/2020 which is the date in Qlik too).

    varMaxDate.JPG

     

     

     

     

     

    I have used the find function to look through all of the sections within the script and the only mention of the variable varMaxDate is in the below script. 

    //CalDate field exists elsewhere in script and is the link. Example: date(InvoiceDate, 'DD/MM/YYYY') as [CalDate],

    QuartersMap:
    MAPPING LOAD
    rowno() as Month,
    'Q' & Ceil (rowno()/3) as Quarter
    AUTOGENERATE (12);

    Temp:
    Load
    min(CalDate) as minDate,
    max(CalDate) as maxDate
    Resident Fact;

    Let varMinDate = Num(Peek('minDate', 0, 'Temp'));
    Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));
    DROP Table Temp;

    TempCalendar:
    LOAD
    $(varMinDate) + Iterno()-1 As Num,
    Date($(varMinDate) + IterNo() - 1) as TempDate
    AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);

    MasterCalendar:
    Load
    MonthStart(date([TempDate],'YYYYMM')) as Period1,

    Date(monthstart(TempDate), 'YYYYMM') as CalYearMonth,

    12*(Year(Today())-Year(TempDate)) + Month(Today()) - Month(TempDate) as MonthsAgo,

    // MonthStart(date([TempDate],'YYYYMM')) as Period1,
    TempDate AS CalDate,
    Date(monthstart(TempDate), 'MMM-YY') as CalMonthYear,
    week(TempDate) As CalWeek,
    Year(TempDate) As CalYear,
    Month(TempDate) As CalMonth,
    Day(TempDate) As CalDay,
    ApplyMap('QuartersMap', month(TempDate), Null()) as CalQuarter,
    Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as CalWeekYear,
    weekstart(date(TempDate, 'DD/MM/YYYY')) as [CalWeekCommencing],
    WeekDay(TempDate) as CalWeekDay
    Resident TempCalendar
    Order By TempDate ASC;
    Drop Table TempCalendar;

    As I'm still new to Qlik I cannot figure out why this script is generating 26/02/2020 for the calendar. Any help would be great!

    Show Less

Blogs

Qlik Community Manager Blogs

Hear from the Qlik Community team about the latest platform enhancements, announcements, and more.

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 Insider Webinar

Join the last Qlik Insider Webinar of 2019, where our experts will discuss the latest features and capabilities in Qlik's platform.

November 20, 2019 Webinar

Events

Events & Meetups

Participate in an upcoming local Qlik Meetup


Events

Qlik Data Revolution Tour

Discover how to transform your entire data value chain for deep insights at unprecedented speed.

Find a location One Day Event