Qlik Community

Welcome to Qlik Community

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

    Time as Axis, formatted AM/PM , but with granularity of milliseconds.

    So  a picture is worth a thousand words  - I'm recording activity on our SQL server to show high resource / long running queries daily/weekly etc.I'm ... Show More

    So  a picture is worth a thousand words  - 

    I'm recording activity on our SQL server to show high resource / long running queries daily/weekly etc.

    I'm trying to set-up an axis without doing any conditional stuff in the dimension column, so users can click the relevant sections and not see a long   IF(a=1 and b=1,c,d)  instead of myDimTimeOfDay.

     

    The top  axis uses a time field imported from SQL server as 'HH:MM:ss.fff tt' format.   

    The bottom axis uses "=Time(Frac(WAT_Collection_Time))"  (Time portion of a TimeStamp )

     

    Is there a way to force Qliksense to format the SQL imported time dimension in the load script to display the same as the bottom one?  I'd rather the user didn't have to see the whole Time(Frac( stuff when selecting etc.. 

     

     

    sql_servER-illiseconds.png

     

     

    Show Less
  • Qlik NPrinting Discussions

    Bookmarks in Nprinting

    I'd like to use bookmarks in Nprinting. I already have a bookmark in Qlik sense, but I don't know how to use it in Nprinting. I'm not sure if it's bec... Show More

    I'd like to use bookmarks in Nprinting. I already have a bookmark in Qlik sense, but I don't know how to use it in Nprinting. I'm not sure if it's because of the type of installation (Designer). 

    Can anyone help please?

     

    Annotation 2019-12-13 104058.png

    Show Less
  • QlikView App Development

    When opening list box, close all others

    Hi all,I have a selection of list boxes that are opened / closed depending on the push of a button. I want to be able to make it so when I click the b... Show More

    Hi all,

    I have a selection of list boxes that are opened / closed depending on the push of a button. 

    I want to be able to make it so when I click the button to open another list box, all other list boxes close.

    So essentially I only ever have one list box open at a time.

    Any suggestions?

    Thanks

    Show Less
  • New to Qlik Sense

    Table

    Hi team,I need this kind of output.. Current SchemeNew Scheme  Sl NumBonus %Current IncrementalBonus %New  73.25%227,5000.50%35,000 H483.50%280,00011.... Show More

    Hi team,

    I need this kind of output..

     Current SchemeNew Scheme  
    Sl NumBonus %Current Incremental
    Bonus %
    New  
    73.25%227,5000.50%35,000 H4
    83.50%280,00011.00%145,000 H5
    93.75%337,50011.00%255,000 H6
    104.00%400,00012.50%380,000 H7
    114.25%467,50012.50%505,000 H8
    124.50%540,00012.50%630,000 H9
    135.00%650,00012.50%755,000 H10

     

    However, We need to calculate the Current and New column.

    Formula for Current is = Sl num*Bonus*1000000

    Formula for New is = Sl num*IncrementalBonus %*1000000

    Formula for New is = Sl num*IncrementalBonus %*1000000+H4

    Formula for New is = Sl num*IncrementalBonus %*1000000+H5

    Formula for New is = Sl num*IncrementalBonus %*1000000+H6

    Formula for New is = Sl num*IncrementalBonus %*1000000+H7

    Formula for New is = Sl num*IncrementalBonus %*1000000+H8

    Formula for New is = Sl num*IncrementalBonus %*1000000+H9

     

    Kindly Help me in this

    Show Less
  • Qlik Sense App Development

    Max Value based on set analysis

    Hi guys - I'm trying to work out how to show, on a text box, the field which relates to the MAX value within my data.I currently have the following se... Show More

    Hi guys - I'm trying to work out how to show, on a text box, the field which relates to the MAX value within my data.

    I currently have the following set analysis:

    =Count({<CP_DateofReport={'04/12/2019'},CP_ReportName={'Req to Att'}>}CP_EventKey)

    -

    Count({<CP_DateofReport={'27/11/2019'},CP_ReportName={'Req to Att'}>}CP_EventKey)(CP_DateofReport is the date of each report which goes out weekly; CP_ReportName is the specific report I need to refer to; CP_EventKey is the unique ID of each patient and I use this to count).

    The difference between the two counts for each report gives me a value - the highest of these values will be what I want to show as being the MAX - as an example, if my value was 7, I'd like the NAME of the exam (CP_ExamCombined) to show in the text box rather than the value itself...

    Any ideas?

    Kind regards

    Show Less
  • Qlik Sense App Development

    align axis within combochart to same scale

    hi there,similar to this chart in the upper right at 2:30 https://youtu.be/RkVDi0b2hmk?t=150I want to create a combo chart with a metric on the left a... Show More

    hi there,

    similar to this chart in the upper right at 2:30 https://youtu.be/RkVDi0b2hmk?t=150

    I want to create a combo chart with a metric on the left and another target metric using lines and the right axis. as seen in the video, this doesn't make sense if those two axis don't align and share the same scaling.

    so is there a smart solution to align those two ? automatic scaling works good for a single axis, but not for both

    I came up with calculating the scale limits for both like

     

    =if(
    max(aggr(Sum({<Version={'$(=only(RefVersion))'}>}Value),[Date...YearMonth]))
    	>max(aggr(Sum(Value),[Date...YearMonth]))
    ,max(aggr(Sum({<Version={'$(=only(RefVersion))'}>}Value),[Date...YearMonth]))
    ,max(aggr(Sum(Value),[Date...YearMonth]))
    )

     

    which translates to: if(left axis > right axis, left axis, right axis)

    but this is a very fragil approach and is also doesn't react two changes of the x-axis.

    any ideas ?

    thanks;

    alex

     

    Show Less
  • New to Qlik Sense

    Disabled TLS V1.0 and TLSV1.1 and Enable TLSV1.2

    Hi ExpertI want to know if there is any process to Disabled TLS V1.0 and TLSV1.1 and Enable TLSV1.2 in QlikSense September 2018 version or in higher v... Show More

    Hi Expert

    I want to know if there is any process to Disabled TLS V1.0 and TLSV1.1 and Enable TLSV1.2 in QlikSense September 2018 version or in higher version?

     

    Thanks a Lot

    Fernando

    Show Less
  • New to Qlik Sense

    Average per category expression.

    Hi all,I want to build a chart where the height of the columns are the COUNT OF WORKBOOK,  AVERAGE PER USER: The structure of the data table is the fo... Show More

    Hi all,

    I want to build a chart where the height of the columns are the COUNT OF WORKBOOK,  AVERAGE PER USER: 

    The structure of the data table is the followiing: 

    Table: 'Query Detail - Workbook and Worksheet'

    DateUserWorkbook 
    DesemberJohnPlanning sheet 
    DesemberJohnPlanning sheet 
    DesemberJohnPlanning sheet 
    DesemberMarkPlanning sheet 
    DesemberMarkPlanning sheet 

     

    With this table, I want to build a graph with dimension "month" and with measure "Count of workbook, average per user". In this case, the result of the measure for desember would be 2.5. 

    In powe BI(DAX), the expression is the following: 

    Count of Workbook average per User =

    AVERAGEX(
        KEEPFILTERS(VALUES('Query Detail - Workbook and Worksheet'[User])),
        CALCULATE(COUNTA('Query Detail - Workbook and Worksheet'[Workbook]))
    )
     
    Thanks!!!!!
    Show Less
  • Qlik GeoAnalytics Discussions

    Problem in visualization of layers with (in/Out) Resolution Limit in geoanalytic...

    Hello, we are using qlikview 11 and GeoAnalytics.we have some layers with (in/Out) Resolution Limit, in order to do drill based on level of zoom.But s... Show More

    Hello, 

    we are using qlikview 11 and GeoAnalytics.

    we have some layers with (in/Out) Resolution Limit, in order to do drill based on level of zoom.

    But sometimes( lets say most of the time) we could not see layers and it needs some action ( such as click on one button or opening the layer and ....)

    In your opinion what could be a problem and does any workaround comes to your mind?

    some extra information :

    • we tried with variable and fixed number as  (in/Out) Resolution Limit in layers.
    • We tried to use Group in order to impliment drilling ,But we should change manually dimention of the group and the layer could not undrestand just with name of Group as Dimention and Restrict Drill Down option.
    • we tried with one variable which changes every 15 seconds( based on now() function) and put trigger on this variable,in order to  reset every 15 secons .But we saw 2 problems :
      • since we need auto zoom, when trigger was executed ,the map always starts from starting Point( Max zoom Out )
      • since function Now does not work from access point correctly and we could not see automatic updated value, It needs clicking on dashboard.

    another question : Is there any function in order to get zoom level of the Map in geoanalytics?

    Thank you in advance.

    Regards,

    Matsa

    Show Less
  • Qlik GeoAnalytics Discussions

    GeoQlik

    Hi,My name is Victor, and I'm new on this Community.I have a question regarding GeoQlik. I've inserted the object, but the map isn't uploaded. I don't... Show More

    Hi,

    My name is Victor, and I'm new on this Community.

    I have a question regarding GeoQlik. I've inserted the object, but the map isn't uploaded. I don't understand why is this happening. Few months ago worked. It is possible to be a server issue ?

    Image in attachment

    Show Less

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for October and November 2019.

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 World 2020

Get the most value from your data and see the hottest trends in data and analytics. Join us in Phoenix, AZ. Register by December 31 to save $400.

May 11- 14, 2020 Conference

Events

Events & Meetups

Participate in an upcoming local Qlik Meetup


Events

Data Revolution Virtual Forum

An exclusive online event where industry experts share practical advice to help your entire team take charge of their data.

Find a location December 3, 4 and 5th