Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
1,831 online

Find the forums for your Qlik data analytics products to ask a question, start a discussion, or review documentation.

Find the forums for your Qlik Data Integration products to ask a question, start a discussion, or review documentation.

This forum will provide you with event highlights and related content to get you energized and ready for QlikWorld 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.

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

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 ten unique blogs. Check out the new Product Insight & Ideas Blog!

Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.

Discussion Boards and Documents for Qlik Services.

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.

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

Recent Discussions

  • New to Qlik Sense

    Hide column filled only with nulls

    Hello dears!Please tell me how to hide a column in pivot table which has only zeros (nulls) - see example below. I know about unchecking button "inclu... Show More

    Hello dears!

    Please tell me how to hide a column in pivot table which has only zeros (nulls) - see example below. I know about unchecking button "include zero values" and "include null values". Normally, if I have only one measure, it works correctly, but I have to add one more measure (which has a lot of null values for prior months). 

    In this particular case I want to hide month "2018-01" in measure "LM growth"

     

    Capture.PNG

     
    Show Less
  • New to Qlik Sense

    Hide the data for those ObjectIDs in a pivot table that have totals value 0 in ...

    HI Devs,I have a pivot table in Qlik Sense as below. I wish to hide those Obj IDs in the table that have the total value for the 'Calculation ' field ... Show More

    HI Devs,

    I have a pivot table in Qlik Sense as below. I wish to hide those Obj IDs in the table that have the total value for the 'Calculation ' field as 0. (Totals is the subtotal field i got when i added data to the pivot table)

     
    Obj IDMONTHYEARMeasure1Measure2Calculation
    10001Totals0-9000
     Jan-190-3000
     Feb-190-4000
     Mar-190-1000
     Apr-190-1000
    10002Totals41040
     19-Feb0040
     19-Mar0040
     19-Apr40040

     

    Here I would like to see only the values for Obj ID 10002.

     

    Thanks.

    AJ

    Show Less
  • New to Qlik Sense

    Calculating values in script inside loop

    Hello Everyone,We are trying to calculate values of certain KPIs at script side and storing those values into Qvd but we are facing challenge in that,... Show More

    Hello Everyone,

    We are trying to calculate values of certain KPIs at script side and storing those values into Qvd but we are facing challenge in that, need help on that.

    Below is the script which we have written and with that we are not getting appropriate output:

    LET rowText = NoOfRows('Threshold');

    for i=1 to $(rowText) // loop through every row

    let vMETRICID = Peek('METRICID',$(i),'Threshold'); 
    Let vDOMAINID = Peek('DOMAINID',$(i),'Threshold');

    Let vBrkFixReslDen='Count({<DOMAINID={''$(vDOMAINID)''},ExcludeFromSLAFlag={0},SLA_ResolutionTargetBreachFlag={0,1},isInternal={1},ToolType={1}>}Task)';
    Let vBrkFixReslNum='Count({<DOMAINID={''$(vDOMAINID)''},ExcludeFromSLAFlag={0},SLA_ResolutionTargetBreachFlag={0},isInternal={1},ToolType={1}>}Task)';


    Set vBrkFixRespDen='Count({<DOMAINID={''$(vDOMAINID)''},ExcludeFromSLAFlag={0},SLA_ResponseTargetBreachFlag={0,1},ToolType={1}>}IncidentID)';
    Set vBrkFixRespNum='Count({<DOMAINID={''$(vDOMAINID)''},ExcludeFromSLAFlag={0},SLA_ResponseTargetBreachFlag={0},ToolType={1}>}IncidentID)';

     

    Let SLA_M1 = '=Pick(match($(vMETRICID),51,61),
    Num($(vBrkFixReslNum)/$(vBrkFixReslDen),''##0.00%''),
    Num($(vBrkFixRespNum)/$(vBrkFixRespDen),''######.0'')

    )';

    SLAValues:
    Load '$(vMETRICID)' as Metid, '$(vDOMAINID)' as Domid, '$(SLA_M1)' as SLAMI,
    '$(vMETRICID)'&'|'&'$(vDOMAINID)' AS SLAID
    AutoGenerate 1;

    LET vQVDexists = if(FileSize('lib://QVD_DATA/SLAValues.qvd') > 0, 1, 0);


    IF vQVDexists = 0 THEN
    Store SLAValues into [lib://QVD_DATA/SLAValues.qvd](qvd);
    Else
    Concatenate(SLAValues)
    Load * FROM [lib://QVD_DATA/SLAValues.qvd]
    (qvd) where Not Exists(SLAID);

    Store SLAValues into [lib://QVD_DATA/SLAValues.qvd](qvd);
    End if;
    Drop table SLAValues;
    Next

     

    in the SLAMI column of SLAValues table instead of getting the result value we are getting a string with formula in it like:

    "=Pick(match(51,51,61),
    Num(Count({<DOMAINID={'1'},ExcludeFromSLAFlag={0},SLA_ResolutionTargetBreachFlag={0},isInternal={1},ToolType={1}>}Task) / Count({<DOMAINID={'1'},ExcludeFromSLAFlag={0},SLA_ResolutionTargetBreachFlag={0,1},isInternal={1},ToolType={1}>}Task),'##0.00%'),


    Num(Count({<DOMAINID={'1'},ExcludeFromSLAFlag={0},SLA_ResponseTargetBreachFlag={0},ToolType={1}>}IncidentID) / Count({<DOMAINID={'1'},ExcludeFromSLAFlag={0},SLA_ResponseTargetBreachFlag={0,1},ToolType={1}>}IncidentID),'######.0')

    )"

    but instead of formula we want to get the calculated value in this column or else if we can get the value in the chart/table when we select this column that should also work.

    Looking forward for help.

    Regards, Tauceef

    Show Less
  • New to QlikView

    Independent Summary count for each customer based on percentage from straight ta...

    Hi,I want to get the count of each customer based on the utilization percentage and group the count under each percentage range (ie, <50% , 50-70%, 70... Show More

    Hi,

    I want to get the count of each customer based on the utilization percentage and group the count under each percentage range (ie, <50% , 50-70%, 70-90% and >90%). Attached the input data and straight table.. Please share your inputs on how to get this designed. Thanks!

    Attached the screenshot  (count may not be accurate in the screenshot)

     

     

    Show Less
  • New to Qlik Sense

    Problems accessing the hub on the consumer node of a multinode server

    We want to migrate from single node architecture to a multinode architecture.We start with a single node server where we access to the dashboards, sch... Show More

    We want to migrate from single node architecture to a multinode architecture.

    We start with a single node server where we access to the dashboards, schedule and development. This server has an associated URL from which we successfully access both the qmc (https://mydomain.com/qmc) and the hub (https://mydomain.com/hub).

    Due to customer demand we want to move to a multinode server

     adding a consumer node to the central node. From now on we will refer to the central server as "Central" and the consumer server as "Node".

    We successfully install the Node server according to (https://help.qlik.com/en-US/sense/June2017/Content/Videos/Videos-join-node-to-cluster.htm) and we link it correctly to the Central server by activating Consumer Node Services (Repository, Engine and Proxy):

    Picture1.png

    We have configured the two proxies the same and they are in Running status.

    Picture2.png

    Then we have done several tests to ensure that access to the applications is configured correctly:

     Access applications with load balancing through a virtual proxy called uve:

    Picture3.png

    And we link the two proxies:

    Picture4.png

    This virtual proxy is what we use in a single server configuration, we just added the load balancing node and the Node as its associated proxy.

    We have also enabled the load balancing rules which give us the following accesses:

    Picture5.png

    If we go to https://mydomain.com/uve/hub and open the apps, we open them correctly with both nodes. Checking the logs we see that he has opened two apps with one node and two apps with another node.

    From this point we want to access some apps only through the "Central" node and others through the "Node" node. To do this we want to do it through virtual proxies.

    If we look at the configuration of virtual proxies:
    Only use the Central proxy as Load balancing:

    Picture6.png

    With the associated Central Proxy:

    Picture7.png

    And if we look at the virtual proxy / uve we see that we have updated it to:

    Only with the node proxy as load balancing:

    Picture8.png

    With the associated Node and Central Proxys:

    Picture9.png

    If we access the URL of the app with the node proxy, if the load balancing rule allows it, then we access the application correctly.

    But if we want to access the hub through the Node proxy: https://mydomain.com/uve/hub

    We get the following error:

    Picture10.png

    Show Less
  • New to Qlik Sense

    When I select a monthyear value in a filter I want the selection to include all...

    HI Devs,I have a complex report ready and I have a monthyear filter.When I select a particular MonthYear value in the filter, I want the selection to ... Show More

    HI Devs,

    I have a complex report ready and I have a monthyear filter.

    When I select a particular MonthYear value in the filter, I want the selection to include all the previous MonthYear values upto the current selection.

    ex: My MonthYear filter has values Dec-2019,Nov-2019,Oct-19,Sep-19,......starting from Jan-2013

    When I select Oct-19 in my filter, all the MonthYear values from Jan-2013 to Oct-19 should be selected.

    I do not wish to change anything on my pivot table report. 

    Is there a way to way to achieve this using filters alone?

    Show Less
  • QlikView Layout & Visualizations

    Gantt Chart Axes

    Hi,I am creating a gantt chart but the axes displays year 1900 instead of current year from data. Please let me now what needs to be changed. Thanks!  Show More

    Hi,

    I am creating a gantt chart but the axes displays year 1900 instead of current year from data. Please let me now what needs to be changed. Thanks!

    1.PNG

     

    Capture.PNG

    Show Less
  • New to QlikView

    which Questions will be asked on Qliksense Interview

    Hi All,which Questions will be asked on Qliksense Interviewplease help.
  • New to Qlik Sense

    Generic Load from QVD

    Hi,I need Your help, Guys. I tried to use Generic Load to reversal my table with Attributes. Unfortunately, it's about 80 000 000 records, and system ... Show More

    Hi,
    I need Your help, Guys. I tried to use Generic Load to reversal my table with Attributes. Unfortunately, it's about 80 000 000 records, and system  memory is full. I want to store every table to QVD in Generic Load, and then join every table from qvd, not from memory. My script looks now like that:

    Attributes:
    Generic LOAD
    %OrderBookingKey,
    Code,
    Value
    Resident Attributes_tmp;

    Set vListOfTables = ;
    For vTableNo = 0 to NoOfTables()
    Let vTableName = TableName($(vTableNo)) ;
    If Subfield(vTableName,'.',1)='Attributes' Then
    Let vListOfTables = vListOfTables & If(Len(vListOfTables)>0,',') & Chr(39) & vTableName & Chr(39) ;
    End If
    Next vTableNo

    CombinedGenericTable:
    Load distinct %OrderBookingKey Resident Attributes_tmp;

    Drop Table Attributes_tmp;

    For each vTableName in $(vListOfTables)
    Left Join (CombinedGenericTable) Load * Resident [$(vTableName)];
    Drop Table [$(vTableName)];
    Next vTableName

    Store CombinedGenericTable into [lib://Transformed (win-f2om7p4maoo_followup)/Attributes_transformed.qvd] (qvd);

    I think I should store the "little tables" to QVD before creating CombinedGenericTable, but I don't know how can I load all of them to my Generic table.

    Thanks in advance for Your help!

    Show Less
  • QlikView App Development

    Autonumber() No Duplicates

    I am trying to use Autonumber() to generate a number for Cost and Customer.  I have sorted already sorted in the order needed but I do not want the Au... Show More

    I am trying to use Autonumber() to generate a number for Cost and Customer.  I have sorted already sorted in the order needed but I do not want the Autonumber to repeat when multiple Customers have the same cost.  How do I end up with an Autogenerated Number equal to the number of rows with no duplicates when the cost is the same.  Example: If I have 4000 rows  I want my ending AutoNumber to be 4000 not 3500 with duplicates.  Hopefully, that makes sense.  Any help will be greatly appreciated.

    Show Less

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for December 2019 and January 2020.

Blogs

Customer Success Blog

Read all about Qlik's Voice of the Customer program and Customer Success initiatives.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.

Groups

Qlik Insight Bot

Join the Qlik Insight Bot Group and bring the power and simplicity of natural-language, conversational analytics to everyone in your organization

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

The Human Impact of Data Literacy

Boosting the data skills of your entire workforce can exponentially increase your data’s value. In this webinar, discover the big opportunity in data literacy.

On Demand Webinar

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

What's New in 2020?

Join us on for a deep-dive discussion and tailored product demonstration on the newest capabilities delivered as part of Qlik’s most recent product release.

Now Available on Demand